DSXchange

This advice has been given lots of times previously. Does Search not work for you?

Or is this yet another interview question?

ODBC commands?


Please elaborate - I am not aware of any ODBC commands.

And?

Just because you are using more than one job does not preclude you from processing all rows.

Please pause to think about possible solution scenarios before replying.

Is this an interview question?

Why would you be using an ODBC stage to populate a DB2 table? Why not a DB2 stage of some kind?

Do you mean ODBC Enterprise stage or some other ODBC stage type?

Probably have a catastrophic effect on running jobs.

The better solution involves either or both running fewer jobs simultaneously and adding additional file systems to scratch disk.

Welcome aboard.

The best advice I can give is for you to wait until version 8.2 of DataStage is released. Of course, there may not even be a version 8.2 (for example the next version might become, say, version 8.5).

You can do whatever you like, of course, but DataStage_Users@oliver.com is a precursor to DSXchange, and has not been "alive" since 2002. You won't get any answers.

Start > All Programs > DataStage > Documentation

Please explain how you are trying to do this. In particular, have you selected "Range" and double clicked on the key expression field?

Note also that the ".ds" file does not contain any data. Ever.

A Column Import or Transformer stage will do it for you. But you need to have sufficient target columns available to receive the values, and these probably need to be nullable.

Welcome aboard.

Find where this library exists and make sure its parent directory is mentioned in your LIBPATH and LD_LIBRARY_PATH lists.

If a VALID ".ds" file exists then all will be well.

An empty ".ds" file is not valid.

The ".ds" file must not exist if you want to create a new Data Set.

Why did you create it? On whose advice? (It was incorrect advice.)