DSXchange

Challenge that requirement, for it is asinine. The right place to capture job statistics is after the job is finished. [Fundamental principle; the act of measuring invalidates the measurement while a process is executing.] This means in the job sequence or shell script that controls it. That, in tur...

Prefer DSExecute(). The third argument captures the output and the fourth argument captures the exit status.

Check for /tmp becomin full during execution of the job.

If this is happening, change the setting of UVTEMP and TMPDIR environment variables to point to somewhere with more space.

Declare the fixed-width columns as being of type Char with an appropriate precision, but as soon as you have even one delimiter character, you must describe the record structure as delimited. If there are no delimiters between the "fixed-size" fields, you must read them as one and parse them within ...

That's no big surprise, since you installed it having Administrator rights, so that the Adminstrator user became the owner of all kinds of things.

Irrespective of platform, an osh script is generated. An operating system control file (shell script or bat file) to execute the osh script is also generated. If the job includes Transformer stage(s) or BuildOp(s), then some C++ modules will also be created, and compiled and linked.

What will happen when the source value is too large to fit in a decimal[9,2] field?

Please post your exact decimal_to_decimal specification (I am assuming here that you are using a Modify stage).

It is always safest to treat text files as if they contain text as the only data type. Within the DataStage job you can then apply data type conversion functions using a Modify stage or a Transformer stage. The obvious exception is when you know that there are binary data in the "text" file.

It's easy to write such a routine. The down side is that you can not invoke that routine from a parallel Transformer stage. And you've indicated that this is a parallel job. The particular compilation error suggests absence of a required DEFFUN declaration, but that's just an educated guess.

I don't know if "u" can (whoever "u" is), but I can. This information is in the manuals, which a thorough reading will reveal, and/or in the readme notes that ship with the product. The knowledge is also conveyed in the vendor's training classes; in this particular case DX434 (DataStage Essentials, ...

Here is a good start point for IBM training, near the bottom you will find references to what you want. The course code is DX500 and its particular catalog entry can be found here - you will find links to schedules, etc., on these pages.

The file is expected to be in the Data directory of your project on the server. How you get it there is up to you. Once it's there its name alone is sufficient to have QualityStage find it.

The problem is that it's not just "a thing or two" - it's literally thousands of things. And, being a totally customizable environment, my system may have command that yours doesn't and vice versa.

Does your file description exactly match what's in the file? Does your file have an empty line at the end?

There is a SUSPEND.FILES command (only in the UV account and only for Administrator login) that can be used to quiesce the Repository databases. That handles any connected developers. Running jobs, though, are a different story entirely. They *should* hang the first time they try to update their sta...