DSXchange

It is the WEB CONSOLE.

You may choose to report the documentation error to IBM that they may fix it.

You should create uvodbc.config entries.

You need to open the twisty "Suite Component Roles".

Most of the "pull from mainframe" activities of which I'm aware have used the FTP stage type. But the mainframe application needs to have created one or more files that can be transferred via FTP. I am also aware of some cases where DB2 Connect has been installed on the DataStage engine an...

shiva_reddys447 wrote:Its not a good idea to open up 10 db connections in a single job

Why not?

I have a job that joins data from 20 different sources. It runs quite happily.

DataStage's FD importer must have at least one 01 level item. This becomes the "table name". Not all COBOL environments require 01 level items, though most do. It may also be the case that you have been supplied with portion of a larger FD. A quick solution would be to change the 10 level ...

I would prefer to use separate jobs, even if they are separate invocations of a single generic job design.

The transform operator (that is, its executable) cannot be found. This means that your PATH environment variable (the command search list) is not set up properly - in particular it does not include the PXEngine bin directory.

Not really. I've seen that before when someone inadvertently used Convert() to eliminate all spaces, but will choose to believe that you have not done that.

Welcome aboard. Are you sure these options were available in the release extant in 2008 when this thread was running? Your "solution" will only work if there is a disk pool named "LRF" in the configuration file. There is no evidence that such is the case for the original question...

Are the row counts identical on all partitions? The easiest way to determine this is to use the Monitor view in Director client, enabling display of instances.

Do some have Char(32) spaces and some Char(0) pad characters?

Probably not. While you could create a virtual column made up of all of those address fields, given that it actually contains two addresses per record how would you expect the Standardize stage to treat that free-form data? A moment's reflection will show that you need one record per address; as Stu...

Is there an index over the columns named in the WHERE clause of the DELETE statement?

A "cannot find the path" error, however, suggests that you have used an invalid pathname for a Surrogate Key state file somewhere, perhaps in an SKG or SCD stage.