DSXchange

How strange. Can you please try using Char instead of VarChar for the length?
record
{final_delim=end, delim=none}
(
RecNum:string[18];
RecLength:string[3];
Other:string[max=50];
)

In Administrator client command window SELECT NAME,JOBNO FROM DS_JOBS WHERE NAME = 'InsCpsClaimAdj'; That will give you the job number. On the server look in a directory called RT_BPnnn, where nnn is that job number. A file whose name ends in TRANSnn is the source code generated by the Transformer s...

This is all so bad!

The "proper" way to abort a job (if there is any "proper" way, which I doubt) is to have some mechanism that the job sequence itself can detect, such as the existence/non-existence of a file.

You require line number 3 of the output.

(The arithmetic removes leading/trailing space.)

Weekends can be a delay too, because it's a manual process.

Please mark this thread as Resolved.

Welcome aboard. You connect initially to IBM Information Server, by specifying the name of the machine where that server is installed and its port number (usually 9080). Your authentication (user ID and password) are processed by IBM Information Server. If successful, the client connection dialog's ...

What you get back from wc is the result followed by a newline.
When this comes into DataStage, the newline is converted into a field mark.
You need to trim the field mark or extract the field from the returned dynamic array.

They are normally installed automatically with DataStage server components.

Select * means that you will get the default column widths. LIST.DICT hashedfile will give you a "file dictionary" (table definition) listing. You can get the column names from that - anything with a type "D" or "I" can be used in a SELECT query. "15L" decodes as 15 characters wide, left justified. ...

There is no HASH function available. You can write your own, either as a parallel routine or as a Build stage.

If your Lookup Failed rule is "Continue" then all fields on the reference input need to be nullable, as do any output fields derived from them. With "Continue" you are effectively doing a left outer join, with the reference input the right hand side of that join.

Welcome aboard. Define "performance" in an ETL context. What measurements are you taking about resource consumption? DataStage starts processes. Allocation of those processes to CPUs is a function of the operating system. Eight cores should theoretically be the same as eight single-core CPUs in stan...

You have to use your column names, not mine.

Get the metadata correct, or use command line overrides to get the display widths sufficiently large.