DSXchange

That wont change the nature of the signed packed fields. The packed fields can be handled by the CFF stage. Use that.

ray.wurlod wrote:...the child processes turn into zombies, which are very difficult to kill.

That almost sounded like a dialogue from "Resident Evil".

The previous phenomenon that the OP was experiencing was weird. As in, sending the date in internal format. You guys think its possible that since the column type is set as "Date", the DSEngine takes the internal conversion and changes to the right format ?

Change it to YYYY-MM-DD format using ICONV/OCONV and then send it to oracle as date.

Can you execute the batch script residing on the remote server from your datastage server, via command line, using rsh? If you can then you definately can specify that command in your execute command stage.

Almost all unix systems are SMP. If your system has 2 or more cpu's then its SMP. MPP is more of an architecture towards an application. Each system can have multiple CPUs, you can have many such systems connected to run one application which is broken into many sub processes running at the same tim...

Is this the only job thats behaving like this. If yes then I have no idea whats going on, without further detective work. Delete the job and rebuild it. See if this behaviour goes away.

When you view data, make sure your Skip Count is set to 0 and Period is set to 1.

DB2 API does not support reject links. Only enterprise stages do. User DB2 Enterprise stage to capture rejects in a PX job. In a server job you can only capture rejects using the transformer. Right click on the extended expression window, go to Link Variables and select Output . There extend the lin...

To move a directory you can use the mv command

As far as ftp is concerned, I doubt it. But you can ftp all the files within a directory.

a) They should be able to capture the sysout. I know ControlM does. b) Correct, double check with your scheduling group about the return codes. c) dsjob -run, if successful will return exit code of 0. 2 means something went wrong in the command itself. Now if you want the jobstatus then you need to ...

Guess what, you are right, funny ideas keep popping in my head

WHat happens when you run the job. Do all the records get processed?

I know I contradicted myself as the second thought came up. When you have two links going out to the same file and you have links ordered, then a single row will go through the first link first and then to the second link (round robin). This way each record will be appended to a file, one at a time....

Did you try searching my friend. Its all here, covered before, along with syntax.