DSXchange

Why not use a Sequential File stage with a Rejects output link? This will automatically "validate" the data types. Downstream on the Rejects link you could, for example, use a Column Import stage to reconstitute the record format from the raw string, and direct whatever you like to your errors table.

It's my undestanding that you need DB2 Connect for ALL cross-platform DB2 connectivity.

It's also my understanding that the serial number can not be changed in version 7.5 without uninstalling and reinstalling. Therefore export all your projects first!

In both editions there is a pad character property. In parallel jobs you can set APT_STRING_PADCHAR globally. Its default value is \0 which is why this is used to pad your strings. In C programming, a "\0" character is a string terminator, so it's a useful default choice. You can override this at th...

Thank you for that valuable information.

You can read the date column by changing its Format String property to "%yyyy%mm%dd" (with no delimiter characters); thereby avoiding the data type conversion.

Ultimately the answer is that the vendor elected to have server jobs perform lookups one way (Transformer stage) and to have parallel jobs do it a different way (Lookup stage). The parallel Transformer stage does not support reference inputs. As to why, only the vendor could answer that definitively.

Novneet, why do you say this is a "better" approach? Would an oversized VarChar (for example VarChar(255)) be even better? It's my understanding that unbounded VarChar fields are discouraged by the vendor except in one specific case (storage in persistent Data Sets). But I'd be glad to read your exp...

It's a good theory. The DS.CHECKER command will clean up any orphaned tables left over from partial deletion of a job.

Upstream of the Transformer stage define it to be larger, say VarChar(255). Downstream of the Transformer stage define it to be the desired size. Use a constraint expression in the Transformer stage to direct rows where it is of the appropriate size onto one output link, and use a reject or alternat...

This is a duplicate thread. Please continue the conversation in this thread.

This thread is closed.

How about we stop maintaining two effectively identical threads on this one? What you've typed in above is manifestly incomplete; you can't get a status of "Running" from uv -admin -info immediately after shutting DataStage down with uv -admin -stop command. In any case, it's now obvious that the f...

A hash file is a tool used for shaping blocks of hash.

A hashed file is a DataStage table particularly well-suited to key-based lookups because it determines the record location by applying a hashing algorithm to the key value.

It IS neat, isn't it? :D

If you had created the hashed file with a UV stage, however, you would have had to ensure that the system tables were also updated.


That's also how you'd do it in most databases.

Metadata for table definitions are stored generically. You can prove this easily; open the table definition and select the Layout tab. You can then view the same table definition as an SQL table definition, an Orchestrate record schema or as a COBOL file definition. I guess level numbers might inter...