DSXchange

You don't need a whole script, just use cron to start the DataStage job via the dsjob command.

I am not sure where the hashed file fits in. But which lookup is not working and can you identify a row which should be found in the lookup but is not?

No, that cannot be done from COBOL; but you should be able to do what about issuing a rsh from the JCL calling the program?

siva4joy - could you give some samples of the data, perhaps a programmed function might not be necessary

The routines you need are DSAttachJob() , DSGetJobInfo() and DSDetachJob() . I would prefer doing completely custom code but you could write a job that reads the DS_JOBS hashed file and for each entry uses the calls listed above to get information about the runs status of jobs and their instances.

Thanks iDomz!

You need to do this from a Job Sequence, as you are making decisions about which jobs to call. You can make the condition simple in the Job Sequence (i.e. execute a wc -l on the reject file to get the number of lines)

What format is the binary data? You need to know that in order to apply a conversion making the data legible.

Combine Craig's find options and replace his -print option with what I posted earlier "-exec gunzip {} \;" and you will have something that works for you. But you really should read up on UNIX, particularly how pipes, redirection and command lines work since this is fundamental to working in that en...

You can execute a CMD shell command on your windows server, and from that you can execute a rsh command to your UNIX server; assuming you have installed a tool like MKS toolkit or similar package.

kum_d - you are not passing the filename to the gunzip command, you are passing a string (containing the file name) to gunzip, which is detecting that the string is not compressed. What happened when you tried to use the find command I suggested?

No, the User Variable stage in Job Sequences has no counterpart at 7.1

gunzip is trying to interpret stdin (your list of files) as a compressed stream so it cannot unzip it. I am not at a UNIX box right now, but would recommend you use the find command, but I don't know the options from memory for selecting the appropriate single file, but the command would read someth...

I had no idea that $1 works in a transform stage. What value gets used?

Put a HandleNull() call in the derivations where you TRIM data that might be null and where you don't want it to be. Or a simple