DSXchange

That functionality is, unfortunately, not available.

Craig - doing a 'uname -a' might show differences in the 3rd column, without having to make the sysadm people do a more in-depth check.
How much work would it be to do a re-install over the existing version?

Ray - as you rightly point out, spaces cannot be in a packed decimal field.

Shiv - Think about it. Hashed files are stored on the DataStage server. You wish to store them on your client PC. (oops, re-read the original post and realized that I misinterpreted the question, I thought the server files were to be stored on the PC... I shouldn't be allowed close to a keyboard bef...

sanath1234 wrote:U can use UNIX command ls | grep dsjob| grep aborted...

Sure, you can issue that UNIX command, but it will not return the list of aborted jobs. Once jobs abort they stop and are no longer visible using the ps command.

To add to what gbusson suggested, make sure that all DataStage users are logged out when you do this, otherwise the index will be corrupted and no jobs will be visible until you correctly reindex.

The "reset if required" will do exactly that, reset a job if the previous run has failed so that it is in a runnable state. It won't help you if are trying to re-run an instance that is already running, but worth changing nonetheless.

gnan_gun (is this the same thread/poster as the original one by pimmit22043 ?) The line you posted that builds the date doesn't contain a date conversion using date_from_string; perhaps you could post that line as well.

There is no pattern equivalent for datasets. Have you tried adjusting the readers-per-node settings to add more parallelism to your sequential reads?

Craig - I don't have anything to add, the error does seem very odd. What about if you were to have the admin people restart DataStage from 'root' - do any of the symptoms persist (jobs running under dsadm, connectivity)? I would tend to think that something else has changed with regards to user perm...

How you parse the field depends upon what you wish to do with the sub-values. Do you want to 'raise' them to separate fields? In that case, an external command such as UNIX tr might be easiest. But if there are variable numbers of value in this sub-field then that method isn't optimal. You can get t...

You got it! I had a timeout on my first "submit" attempt after a couple of minutes of explorer-twiddling-thumbs-top-right-windoze-flag-waving and then I resubmitted

what happens when you use your favorite access tool to run the command "SELECT partkey,name,mfgr,brand,size,container,retailprice FROM manish_part3 ;" - does that also generate an error? Also, did you cut-and-paste the following error message from the log "ODBC_Connector_0,0: [IIS-CONN-DAAPI-000086]...

How about a rule that if there are two identical posts that are not the last ones in a thread then the system will remove one of the duplicates. I don't mean duplicate threads - just duplicate posts. Many of us have had quite a few in recent weeks, usually caused by sporadic transmission problems an...

If you restore the UNIX objects from a saved project directory to the same path then everything will work as most DataStage internal references are local and those few (but important) absolute paths used will also remain the same.