DSXchange

But... it must be DB2 version 9, or Oracle version 10g. Any earlier release will not work.

It is mandatory.

If you don't have one of your own, a copy of DB2 version 9 ships with IIS and you can use that.

From where do the two inputs come?

sed is the stream editor for UNIX. Issuing the man sed command will tell you most of what you need to know in terms of syntax - after that it's a matter of experimentation and practice. A book such as UNIX for Dummies is also useful.

This will always be an issue with AS/400, since every file in the operating system can represent itself as a table to the ODBC driver. You need always to configure ODBC with a table name filter. Doing the same with the DB2 Connect software is not a bad idea either.

Or perhaps not. If you purchased your DataStage through a reseller, IBM will insist that you continue to use that reseller. However, the same applies - your reseller may be able to provide a time-limited evaluation copy.

It ONLY works if execution is sequential.

Try VarChar. Are there any "zero bytes" in your data?

How many ways parallel?

$1 (indeed regular expressions) are used in Derivation Substitution, not in derivation expressions themselves. For example, if you have 200 VarChar columns and want to apply a Trim() function to all of them, select them all then right click and choose Derivation Substitution from the menu. The rest ...

Etiquette Note This is an all volunteer site. People post as and when they can. If you need urgent support, sign up with your support provider for premium service, and learn the true cost of urgent. DSXchange is not a substitute for a maintenance contract. That soneone has not posted within the hou...

IBM do, of course, publish this. That means that you can obtain it from your support provider or, indeed, from the IBM web site. If you now have 7.5.2 installed, there's documentation right there on your system in the form of Release Notes and the Install and Upgrade Guide.

Key-based partitioning involves the Hash algorithm unless the partitioning key is a single, essentially unbroken, integer sequence, in which case Modulus consumes fewer resources. (1) Aggregator: partition on grouping keys (2) Stored procedure: usually executed in sequential mode (3) Filter: any par...

Yes you can.

"The info" will surely depend on which job's dependent jobs you wish to list.

Do your metadata practices extend to maintaining the Dependencies grid in the job properties?