DSXchange

How are you specifying null handling? Have you nominated a default value for these decimal fields? Are there any warnings about nulls being logged?

Not seen it, but didn't have much experience with 7.1r2. It might be interesting to farm this back to IBM support, and watch the DS support point the finger at DB2 and vice versa. I suspect you're right, that there's a version compatibility issue. What does your DataStage manual say about the DB2 st...

From your Administrator client Command window:
to learn the column names.
to identify what was deleted when and by whom. Constrain on CLASS = '2' to limit the report to jobs.

We have had nothing but grief trying to use any Linux other than Red Hat AS3.0.

Check out PNav on Kim Duke's web site.

If you are going to write to named pipes it is your responsibility to make sure that there is some other co-ordinated process reading from those names pipes, so that the pipes do not fill. These are the "child processes" referred to in the error messages.

Yes.

You can put the second link into a second job.

Execute the two jobs consecutively from a job sequence.

There's nothing else to do. Assuming that the table and column names remain the same, the connectivity remains the same, and the SQL syntax remains the same, there's nothing inside the jobs for you to check. The only possible area to check might be the ODBC connectivity files (.odbc.ini and uvodbc.c...

The before/after subroutine is executed from the job properties itself, not from a stage. If you want to execute your command from every row processed, then you could use an External Source, External Target stage or an External Filter stage, depending upon whether you need input, output or input and...

For version 8.0 recommended physical memory (RAM) for IBM Information Server is at least 8GB. You can probably run the Application Server on this machine as well with some performance penalty. And 2GB is the recommended memory for the client.

That's your problem entirely, of course. Make time to garner some time management skills. Many of us read every post here, up to 200 per day. We allocate the time to do so.

It is a simplification to assume a one-to-one relationship between stages and operators. Some stage types generate a composite operator - for example a Lookup stage (other than for sparse lookup) or a Data Set stage (when overwriting). A Copy stage that makes one identical copy of its input will be ...

Not all conversions are automatic as in server jobs. Your mindset is still on server jobs - you even marked this as a server jobs. The error message codes indicate that it isn't. You need explicitly to address each of the issues, with data type conversion functions and appropriate data types. There ...

Have you tried re-indexing the DS_STAGETYPES table in the Repository? Otherwise, can you achieve any progress with customizing the Palette, as Craig suggested? If not, you probably have the mismatched versions issue. You CAN have two client versions installed, but they must be installed in different...

Reset 64BIT_FILES to zero and restart DataStage. As Craig said, to set this to 1 is a Bad Idea. Prefer to issue your own CREATE.FILE or mkdbfile commands to create 64-bit hashed files, but only when necessary. You can get the syntax from the Hashed File Calculator (on your DataStage CD). 64-bit hash...