DSXchange

Perhaps this helps:

http://www-01.ibm.com/cgi-bin/common/ss ... guage=enus

No, you can't "pass the file" to the command but you can craft a script that reads the file and calls the export command for each record / job name. And from what I recall of previous conversations here, it does not support appending output so your script would need to create multiple output files a...

Not in a Server job, boys and girls. 'Ware the Job Type.

vmcburney wrote:Some other things I couldn't type quickly enough...

... without spilling your grog.

You wouldn't call the Manager but rather dscmdexport.exe for an entire project or dsexport.exe for a single job.

The 'DS Manager' is a client tool. Windows, not UNIX.

An Oracle function is used in sql, selected like a column would be. You don't need a stored procedure to make use of it.

Use an input link. Start from a Transformer, adding a dummy stage variable so it will compile and a constraint of "OUTROWNUM=1" so it only generates one row. Set your job parameters into fields in the input link so they can be easily passed to the stored procedure.

Hmmm... are you able to use them in a Server job or not at all?

Short answer? No. You must ensure that what you've marked as the Key fields for the update uniquely identify a single record. If your update leaves fingerprints on each record updated, say like a timestamp, then you could check after job that the link count sent to the Oracle stage = the number of u...

Nothing wrong, just a useless role. Operators can only see Released jobs and releasing jobs is soooo 90s.

The only reason your Aggregator is in trouble is because you either haven't presorted the data or haven't presorted the data properly. So, you need to ensure two things: you're sorting in a manner that supports the grouping being done and you've asserted the sort order in the Aggregator. Doing that ...

Read your man pages for 'sort'. You'll need to tell it what your field delimiter is so it knows which is the 1st field and which is the 2nd. This is pretty easy to setup as a Filter because by default sort writes to standard out.

All I meant was - there ya go, now you know they are tabs. Scratch that off your list of "things that may be wrong".