DSXchange

I can't think of a way to get this with a quick click method.

With a small DS/BASIC routine you could loop through all jobs, and in each job loop through all links, and then find those which have a passive stage at the source end and print those out where the stage type is db2.

If you look at this link it describes how to make a vertical or horizontal pivot. Once you read that and have tried to make the pivot work and still have a question then we should continue here.

I'm afraid I cannot understand if that is the same or different from what I meant and don't know what you mean. Would it be possible for a simple example to show what you expect DataStage to do? A normal lookup will return only the first returned value if there are several matches, but you can also ...

The solution is not simple or easy to implement. The first part would be to keep a dynamic metadata store somewhere accessible to DataStage which has the tables, columns, keys, and datatypes. In addition, the columns to be used for CDC would also need to be marked. The another set of jobs would read...

If you go to your designer, navigate the repository to

Stages Types -> Parallel -> Database -> {your stage type}

then right-mouse-click and "find where used"

you will get a list of jobs where that stage is used.

It would be helpful if you could post the error message you get when you view data.

At a Stage level go to Stage -> Advanced and you will see option to let you choose the config file, or node pool and resource constraints or node map constraints. These are documented in the product help files.

Run your job in a 1-node configuration and see if the error remains. If it is still there with 1-node then your partitioning is not at the root of the problem.

The APT_CONFIG_FILE has always been a component and possible parameter in DataStage parallel jobs.

Do you mean that if you get 2 or more records from the Oracle lookup for a given "Field_Key" then you want your job to fail?

Yes, it works with typical text files. But if the file contains 0x00 (nulls) then a normal FTP will interpret that as an end-of-file marker and stop. EXCEL files contain nulls and thus won't transfer correctly. Try FTPing a .JPG or .XLS file, even between Windows or UNIX machines, and you will see c...

I suggest using DataStage job parameters for this.

No, ASCII mode does not work when copying an excel file, you need to specify BINARY mode.

Try:

StringToTimestamp(DSLink77.AA,"%yyyy-%mm-%dd %hh:%nn:%ss")

(last "%" was incorrect)

You need to FTP the Excel file using normal FTP and not the FTP stage. As said earlier, the FTP in DataStage is for processing remote flat files.