DSXchange

What is the data type of column redflag-rec1 ? For example Char(2)

Search for rows where the length is greater than the precision in your metadata. For example, if the data type is Char(2), search for rows in which LENGTH(redflag-rec1) > 2.

You can set them as job parameters in server jobs, but they will have no effect whatsoever. You need the "regular" DB2 environment variables, not the APT ones, which are only for parallel jobs. For server jobs, it is enough to have the environment variables (such as DB2INSTANCE) set in the dsenv scr...

There are two other DLLs that you have to install with your dsjob executable. The Server Job Developer's Guide describes the process of deploying dsjob to other machines.

Doesn't matter. If running parallel jobs on Windows then MKS Toolkit is installed, and you CAN use Unix shell scripts.

There are built-in Transforms such as NullToEmpty and NullToZero that you can use. These ought to serve as a useful starting point. You need to import/create the table definition for the output link of the Transformer stage; server jobs do not have runtime column propagation.

Just create a text file in CSV format, with column headings and one line of dummy data. Then import the table definition from that. Store the table definition in an appropriate (to your standards) category.

Because there are no data types within server jobs, all you need to do is to convert the delimiter characters in the date portion and concatenate a time portion. Convert("/", '-", InLink.TheDate) : " 00:00:00" However, this solution assumes that the target database r...

This is a duplicate post, in the wrong forum

Please respond to this post instead.

Are the jobs in a runnable state? Compiled?

Enrol in a training class. Read about configuration files in the Manager Guide.

Have you specified "all rows in single transaction"?

Is it really a memory leak or just consuming a lot of memory that it will relinquish once it's done? A memory leak is a bug, using a lot of memory is not.

The "server" here is the email (SMTP) server, not the host name. Either you have not provided a server name or you have provided an incorrect one.

What do you seek to achieve? The "condition" determines whether to attempt the lookup at all, not the condition clause in the lookup processing. A Lookup stage can only do an "=" match on the key column(s).

It occurs to me to ask whether the data type is Char(6), noting that "PWRC" is not six characters long. Maybe you need to specify VarChar in the Sequential File stage output link.

You need to have DB2 Connect software installed and configured on the DataStage server machine. You also need SELECT privilege to those system tables that contain the DB2 catalog. You only need entries in .odbc.ini and uvodbc.config if you are attempting to access DB2 via ODBC.