DSXchange

Are you working with a PX or a Server environment (you posted in PX but the product is listed as server). The solution depends significantly on which flavour you are using. The .csv file will have empty strings instead of nulls. You will need to convert these values to null in order to do your compa...

Yes

rsh would be better if DataStage isn't also installed on your a1 server. But you can copy the program over from the $DSHOME/bin directory. I'm not sure if it needs any libraries on UNIX.

If ICONV() of a string is equal to the string then you have an invalid date.

George - you meant to say "in any SQL compliant database". Pick type databases such as the UniVerse/DS engine work differently. Hashed files cannot be created without unique keys, the terms "key" and "index" are synonymous in this context for hashed file keys.

It is most certainly a bug, I know I had a ticket open for that and ended up having to code a recursive routine to get the whole "family" of a job's parents.

Joshy - the output is right, but the overhead of 3 I/Oconv call is to much, just a simple "Iconv(Input.Date,"D-YMD[4,2,2]")=Input.Date" is sufficient.

The orchadmin program will be in the $PXHOME/bin directory and that path (and associated libraries) should be set by the "dsenv" script.

And what does the "ora.1221018.874080.9.log" log file contain?

Roy - how about you selecting what you think of as the "10 worst subject lines" and let us rank them. Although the outcome might be close we can see if such subject lines as "Data Stage", "Error", or "Help!" will win.

The command line program dsjob lets jobs be started on a remote system, the syntax is dsjob -server {name} -user {name} -password {name} -run -mode NORMAL {project} {job}[/b]

The first step is to ensure that you have sufficient space available now. Once you have done that, I would recommend you go into the admin tool and run the DS.CHECKER when NO other users are on the system and see if that discovers any error. p.s. This might be "urgent" for you, but not for the volun...

Unfortunately the ICONV() and OCONV() functions will return the original string, so the result of the 2 functions on an invalid string will be the original string - just as if it were a valid date. The correct way to do this is to use a ICONV() function and check the value of STATUS(); but as that c...

The secondary indices on hashed files are something completely different and are not used from DataStage. The indices created by CREATE.INDEX and BUILD.INDEX are on columns and are accessed when doing queries from the DataStage command line using commands such as SELECT (both the Inform and the SQL ...

Edward, the transform action doesn't affect this message. You need to right-mouse click on the column in the sequential file stage, then do and "edit row" and either explicitly set or remove the attribute there.