DSXchange

JD Edwards has an idiosyncratic way to store dates. Extract them as VarChar and convert them within your job. Search the forum for examples.

Send it to a text file and use a hex editor to find out what the box character represents. My guess would be the character specified by APT_STRING_PADCHAR environment variable, used to pad Char fields to their correct length. In a hex editor this will probably be displayed as 00 or, in the viewable ...

It does NOT have to be re-compiled if it aborted. It only needs to be reset. You can accomplish this with dsjob -run -mode RESET ...

You can also accomplish it automatically ("reset if required, then run") if running your job from a job sequence - the job sequence can be started from dsjob.

In a word, "MORE". Data Sets, particularly with unbounded strings, consume rather more disk space than you would expect. There is an 80-bit-per-record storage overhead at the record level that also needs to be considered. The Parallel Job Developer's Guide (page 2-32) helps you to calculate the stor...

It's a UNIX kernel parameter. It's not called MAXUPROC on all variants of UNIX - you need to determine what the kernel parameter that sets your "maximum number of processes per user" is. Then you need to learn how superuser goes about changing it in that UNIX (which may require a re-boot of the UNIX...

To quote from an old Nike ad campaign - just do it. YOU tell DataStage where the files are. You might even arrange for the files to be brought locally first - such a script could be run under DataStage control. YOU tell DataStage how to merge the data by choice of stage type (could be Merge stage). ...

Check with "them" but, surely, if you were blocked, you wouldn't get in at all. The only time I've been blocked (because of the proximity of "S" and "X" in DSXchange, in a country in which English was not the official language) I got nowhere near DSXchange until I had access unblocked following repr...

You an use server routines in an MPP setup, provided you license DataStage server on every machine in the cluster or grid. Your account rep will be able to retire on the commission! Server routines require the DataStage Engine to execute. This only exists on the machine where the DataStage server is...

You might also try searching for, or asking support about, exit status 256 (which is 65536 - 65280).

Set APT_STARTUP_STATUS environment variable so that you can watch distribution of the score. It is this procedure that is failing to complete successfully.

We haven't had that spirit here since nineteen sixty nine.

And still those voices keep calling from far away: wake you up in the middle of the night just to hear them say...

There are many dangers inherent in moving DataStage projects without due care and diligence. Thanks for posting this particular one.

Unlikely to be "first line is column names" from a Data Set. What is your job design? Please use "ASCII art" within Code tags - it makes it so much easier to read. What row counts are reported on each link? Enable APT_RECORD_COUNTS (perhaps as a job parameter) so that the player processes log their ...

Encrypted <> Encoded

We can not see your job logs. Right now your question is in the "my car won't start, what's wrong with it?" category.