DSXchange

Ummm, since you have COMP-3 you must transfer in binary, otherwise the data is corrupted.

You will need one process to determine the correct file to use, then passing that value to the DataStage job that reads the file. There are many ways of getting the "latest" file; it depends if you do it by date-time created/modified or by the name. This would be a single UNIX statement, i.e. "ls /t...

Usually you can install UNIX commands with MKS Toolkit or a similar product. In your case just fool DataStage and, in the sequential stage, state "File has column headers" so the first line is skipped.

There is no Server certification and currently 3 certifications for PX/EE

1. Enterprise Edition
2. QualityStage
3. Information Analyzer V8

No, the only way to do this is to use sparse lookups and no buffering of output.

I just tested it and the demote works. I'm at V8 so my message-id is "IIS-DSEE-TOIX-00031" but I've used the message handling so much at V7.x that I know it works correctly.
You need to re-run the job after adding the handler for it to take effect.

Using that approach you could turn buffering off for the DataSet stage and get more records, but you cannot guarantee that no data loss will occur. The "Unit of Work" MQ stage will do that for you, or if you do a 2-phase MQ read with transactions, doing a non-destructive read in one job to a table o...

danc - if it is any consolation, I recently had similar issues with installing V8 but in my case the "test" project was created successfully but no others could be added. After running a number of diagnostics with IBM support and trying to localize the cause the problem suddenly disappeared and none...

In addition to Ernie's suggestions also turn off waves and see if the error behaviour changes.

DataStage will not automatically inherit metadata from changed tables. In many cases where Oracle will do implicit conversions you can change datatypes, but missing or new columns are not detected in DataStage.

LIBPATH=`dirname $DSHOME`/branded_odbc/lib:$DSHOME/lib:$DSHOME/uvdlls:$DSHOME/java/jre/bin/classic:$DSHOME/java/jre/bin:$LIBPATH export LIBPATH/bin:$LIBPATH:$INSTHOME/sqllib/lib; That doesn't look like a valid export command line at all! LIBPATH=`dirname $DSHOME`/branded_odbc/lib:$DSHOME/lib:$DSHOM...

It would seem that you have a "/n" in your string! Put a transform stage to create a column with the derivation "LEN(In.PROCESS_DATE) and display in a peek stage. Is the length 8 or 9?

Sounds like it is time to contact your support provider. Have you tried to create and compile a job with a transform stage as well? Does "View Data" on a sequential file work?

99% likely because your explicit (or implicit) mask starts off with %dd/%mm!

NLS and conversions are source of constant trouble in DataStage. If you don't have NLS then you will not have to worry about conversions, since characters coming in are not parsed as if they were multibyte but are just passed through. In your case the output in SAP seems to be correct, but you haven...