DSXchange

the command orchadmin dump {dataset} will write the dataset to stdout; you can redirect that to a file and ftp that to your PC. Best do what Craig has already suggested, though.

should do the trick.

Is the key column present as a key? Is it present in both links? Did you declare the "key" in the join stage?

Yes, you can use the ereplace() function to convert "'" to "\'", i.e.

How about using the active stage that loads into the dataset stage to get the number of rows?

Is there anything similar in the places where the parsing stops? As Stefan noted, it might be special characters.

One of the first entries in your log file will be an echo of all the ENVironment variables. Check the path command to see if the Oracle paths are set. Is it the same for both the bad and the good run of the sequence?

The 1169 looks very much like the limit from your command line, not from DataStage. Try using Google to search for "{your UNIX} maximum command line" to get additional information.

Yes, this is most likely because the minimum kernel settings specified in the installation guide were not set. If that is the case, changing those (and most likely rebooting) will get you up and running again.

Thanks for the link, Ernie!

(well, sort of thanks, I can't get to the pages. I applied for an IBM id a while ago and was denied. When I responded by asking "why?" I never got an answer so gave up)

Ernie - Would it be possible for you to check on the product name and GA status? I was talking about DataMirror with 2 IBMers a couple of days ago who said that engineering was working on it andy they weren't aware that so much progress had been made. I just searched IBM's website but didn't find an...

DataMirror was just recently acquired by IBM and is not {yet} integrated into DataStage. See DataMirror.Com's website for details on the product's functionality.

That is different from you first post, which indicated you only had 2 stages. Can you replace the output with a PEEK stage and see if the error goes away? If not, start removing stages until you get no error; that way you can narrow down the cause.

Can you rename "ROOT" to something else then delete it? Can you try to move it to another category then delete it? I recall having a similar V8 issue where the internal metadata and the repository metadata didn't match. This was a category with no components and I think we only got rid of it when we...

Since it won't compile, DSParams is not the factor. Odd that it said "variable" instead of "function" since it is GetNextSurrogateKey() with an empty parameter list