DSXchange

The Load option is going to use sqlldr, so you will be able to look in the "log" and "bad" files generated by the bulk loader utility.

... unless, of course, the persistent Data Sets contain data staged for tomorrow's run!

Please use APT_DUMP_SCORE to dump the score. The score will have two sections, one describing data sets, the other describing operators.

You seem to have a large number of buffer operators inserted in the job. Can you inspect the score and try to ascertain why this might be? Also, what are the settings of the environment variables associated with buffering? Also from the score can you determine how much use is being made of combinati...

Direct the value of the stage variable onto an additional output link, which writes it to a file. In the parent job sequence, read that file and pick up the value with which to assign the job parameter in a subsequent job. Or you could store the value in the job's user status area and pick it up fro...

Check your compiler options. In particular may require a space between the "I" and the "/".

1) It appears that there's something wrong with the connectivity parameters - database name (tnsname), user ID, password, owner or table name. 2) The Dynamic RDBMS stage will typically not offer any parallelism; it will execute in sequential mode. In theory, at least, this means that you will not re...

Or in general terms I believe my question is, How can UNIX script return values be used to assign values to job parameters? Use a job sequence. The output and exit status of the script can be had as activity variables from the Execute Command activity that runs the script. References to these varia...

Hi gurus, i want to merge 2 ODBC databases, but what i try to join two odbc stages, iam getting a message that merge doesn't support i/p links. what i learned is merge works just like a join, but now why am i getting this type of peculiar message, plz help me to analyze the property. cheers; vijay ...

Can you please mark the thread as resolved?

Try editing the FD so that it contains no comments or blank lines. I know this shouldn't be needed, but it sometimes works.

Don't ever believe what "view data" tools show you - they do their own conversions. Create this job to find out whether the extraction from DB2 is converting to internal format: DB2 -----> Transformer -----> SequentialFile Then let us know what the dates in the text file look like. We should then be...

Link row counts will only report the number of rows that DataStage sent to the database server/driver along that link. It does not report the number of rows in the table. For example you may have updated the same row 1000 times. The link row count will show 1000 even though there may be only one row...

What is combinational effect of check / Uncheck of the four options on the genral page, viz: 1. Add checkpoints so sequence is restartable on failure 2. Automatically handle activities that fail 3. Log warnings after activities that finish with status other than OK 4. Log report messages after each...

If I read the original question correctly, you have a DataStage export (DSX) file containing both parallel and server jobs, but you only have server edition installed.

If that's the case you will not be able to open the parallel jobs.