DSXchange

You'd need a user you could ssh to on the DataStage server, yes. Or something equivalent.

Check what I posted and what you implemented - they ain't the same.

ETLStats. 'Nuff said.

Remote system triggers job, dsjob or API. UNIX script polls for files and launches job. Looping Sequence job with Wait For File or scripted poll. All kinds of ways.

I got 22 matches doing an Exact search for "Possible range/precision limitation", how are you "unable" to do the same?

Search the forums for discussions of the DS_AUDIT table.

Read the Command Line Interface chapter in either Developer's Guide, you'll find both 'dsjob' and the internal API documented there.

Neither the 'manual' or 'automatic' options in the Bulk stage require the Oracle database to be co-resident with DataStage, in spite of what the docs say. Nor does sqlldr.

Oh, and welcome to the Dark Side AJ.

What exact information are you looking for? Just to know if the job is aborted? I use grep for that in a shell script, something like this: eCount=`grep '(3)' /tmp/dsjob$$.out |wc -l` if [ $eCount -eq 1 ] ;then echo "Job is aborted and must be reset..." <run reset> I just have no c...

For UNIX, sure. Under Windows? Nope, sorry, my DOS days are well and truly behind me.

mail2hfz wrote:I used wc -l aud_d_*...it throws error..Cant we use * to read multiple file using filter command..please advice

No. While I believe you should be able to, it doesn't seem to work.

Redirect the output to a file, then check the file.

Output like that is returned in a dynamic array, so you need to either remove any Field Marks (@FM) or just reference the first element. Try:


For example.

Parallel routine? Nope, not my bag baby. However, you don't need one - just some piped OS commands using DSExecute will work: "head -1" and "cut" for example.