DSXchange

A parameter for the path will work in the Folder Path name of the Folder Stage Properties tab. This didn't work for you? I do not know a way to replicate the folder stage write in EE although I am sure that cat can be skinned.

One thing it will do is re-compile any transformers regardless of whether they have been changed. There may be other differences. Recompiling transformers is the only one I know for sure.

-run works no problem. I forgot about the server credentials. Thanks.

I happened to be doing a little light reading yesterday and came across this in the client readme of our 7.5.2 Windows Client install; DSjob is now installed with DS client installation -------------------------------------------------- The dsjob command-line utility is now installed as part of the ...

Drop the DSCAPIOP_ part. Are the parameters $ORADB, $OraDBUserID
and $OraDBPswd defined in the job and as Project level env variables in the 7.5.2 project?

Option 4
A single job that contains an output link to a Folder stage. This will write a unique file per row of incoming data almost exactly like Option 3. The first column in the derivation would be the file path/name, the second, third, etc. is the data.

RCP is NOT applicable to all PX stages. Specifically, it cannot be used with the Teradata API stage. I'd like to make this generalization; wherever a column is needed to generate the SQL at compile time, RCP cannot be used. The teradata API stage is such a place.

You're SOL my friend. Those pesky IBM Developers didn't make environment variables work for all stages of a given job which limits the utility of environment variables for use in any DS job. Bummer. Perhaps there is a DB2 patch? The giveaway is seeing the DSCAPIOP_. DataStage is not resolving this t...

Here's a Teradata example; If you know exactly how many rows will be returned from Teradata and this number of rows is less then the number of nodes, a warning will be generated because at least one node will not get any data. If you constrain by Node Pool to the number of rows you know will be retu...

XMLOutput Stage? I would have thought the XMLInput stage is more appropriate. Is the entire XML in a single MQ Message body? If so, it should be read from MQ that way and passed en-masse to the XMInput Stage as a longvarchar chunk. Parse,filter,pass and kick the whole XML into the donwstream links f...

And PREVDTD not PREV_DTD

Yes. Can you go to this directory, as the user that ran the job, and try to manually create a file? If you can't then that's the answer.

You asked two UNIX questions;
2 is stderr
/dev/null is a special UNIX file or null device. It discards all data written to it. In this case it is getting rid of any errors being written by the previous command.

All the "Experts" are laughing and playing at IOD with their fancy two drink minimums and dancing girls of easy virture so I'll answer your questions. I think you are mis-understanding the purpose of the universe database(s). It is a multi-valued database whose sole purpose should be to su...

It doesn't have to be the same machine as where the DataStage Engine is located and all nodes don't have to be on the same box. Resource disk file systems can be anywhere the DataStage Engine can reach in any combination. Should it be anywhere? That all depends.