DSXchange

The rule here is, in a Boolean context: 0 or "" is False, anything else is True. '119FSA' is therefore True LkpSYSTEMIC.ACCOUNT = '119FCE' or '119FSA' is parsed as: (LkpSYSTEMIC.ACCOUNT = '119FCE') or ('119FSA') (Logical operators have the lowest precedence.) (LkpSYSTEMIC.ACCOUNT = '119FCE...

Wnat version exactly? From version 8.7 (if I recall correctly) the CFF can have multiple output links, one for each Level 01 item in the FD.

So you're saying that imcl.ini exists, but no executable called imcl ?

Maybe it's something simple, like the fact that you left the trailing semi-colon off the SQL query. Each link has two "pin" entries (a pin is the end of a link, that connects to a stage). Link entries in DS_JOBOBJECTS have an identity of the form VnSmPk where n is the view number (job or c...

You can install DB2 client software on the Linux machine and configure it to point to wherever the DB2 database is. Or you can make use of the ODBC wire driver, which ships with DataStage, and does not require the DB2 client software. But you can't use this with the DB2 UDB API stage; you can only u...

If that's all you need, then COUNTRY.SET is more efficient. However, it only generates the two-character ISO country code; you would need to map to the three-character code downstream of the Standardize stage.

Whoever sent you that email is WRONG.

My DS_JOBOBJECTS table has over 1000 records in it, in a project with only 30 jobs. There are two entries per job, one entry per container, one entry per stage, two entries per link, and one entry per annotation. We are running version 8.7.0.1. That is, Fix Pack 1 is installed. Can you try this quer...

How many listeners has the DBA configured? How many of these are you trying to use? What other competition is there for listeners?

You don't.

You can connect from a Windows DB2 client.

The DataStage clients only ever connect to a DataStage engine. They use connectivity defined in the engine, and through the engine, to connect to data sources.

Use an Execute Command activity to echo $NM_USER

Here psQualifiers is the name of a Parameter Set and DEV is the name of a values file in that Parameter Set.

Removing the directory has caused all kinds of issues. You will - at the very least - need to remove entries from UV.ACCOUNT and UV_SCHEMAS (the latter using VERIFY.SQL), and the project entry from the XMETA database.

What version are you on? I am very surprised to learn that DS_JOBOBJECTS is empty. I will check my 8.7 system when I next get access to it.

In that case uninstall and reinstall the client on your machine.