DSXchange

Open the transformer stage, go to the top menu bar, on the right side is a button for output link order. Set the order you need.

Be careful if you're attempting to group rows in a single commit. Read the manual for the conditions to make this work.

It has been undocumented since I started working with release 3.1, from the looks of it is must have existed since the beginning of the product.

Your best luck is to search this forum and the Oliver archives held here, as we've posted a lot of commentary regarding using it.

For a hash file, the order of the columns (hash files are really delimited strings of data, therefore "positional") and the key designations are what matters. The data types and widths currently don't matter to hash files. Make sure you compare apples to apples. When referencing a hash file, you mus...

The metadata used to write a hash file has to be the metadata used to reference the hash. The values defined as the keys are written to a different area in a hash file, therefore, using a different metadata definition does not correctly find rows in the hash file. If you used 3 columns as a multi-pa...

Only using proprietary, undocumented, and unsupported library information will allow you to do what you want, and word is that the internal repository design is about to change (again) rendering these hacks useless in future releases. In order to get the column name, you must resolve the internal st...

You have to have the values in your source data that can successfully match to the key values in your hash file. If your hash file key should just be error_cd, then build your hash file that way. You must change the job that creates that hash file and reprocess the data into the hash file. Now, go b...

If your stored procedure is a "do something" procedure, as opposed to a "process with streaming data" procedure, then you're better off using a shell command to execute sqlplus. If you don't want that route, you will have to create a job like OCI --> XFM --> SEQ that will return at least a single ro...

Release 5.x running on Sun 2.8 had issues that required a Sun patch and a DS patch that was characterized by random abnormal terminations under heavy system load. Release 6+ incorporated the DS side fixes, but the Sun patch I believe is still required. You may consider contacting tech support and ve...

Make sure you NEVER use fully qualified embedded schema names. When you import metadata, NEVER use fully qualified names because when you load the table definition it shows up in the DERIVATION column. If you are not going to work thru public synonyms, then you need to parameterize the schema name a...

Make sure your T30FILES setting is high enough to support the number of jobs executing simultaneously. Your problem is a common one. Search the forum for discussions about the UVCONFIG file and recommended settings. The abnormal terminations can be related to not enough internal pointers available t...

Seems like I will have to take it as one of those datastage 'don't-know-why-it-happens' "features"... NO. I have trained, taught, and used this product since 1998. I am certified in deploying this product (got the paper to prove it) and served over 4 years with Ascential as a consultant. I have nev...

To find the first occurence of "test" in "thislongteststring", use


and it returns the character location of the beginning letter, otherwise 0 if not found.

Craig hit the issue on the head, I neglected to think in terms of OCI, just as an ODBC stage. Convert the format into the external format using oconv and it should work. Iconv(InDate,'D4/DMY'),'D4-YMD[4,2,2]'):' 00:00:00' Arnd means OCONV(Iconv(InDate,'D4/DMY'),'D4-YMD[4,2,2...

1. Please post in the correct forum going forwards.

2. Please state the target database, version, and what stage you are using (OCI, ODBC, etc).

Verify the path to the hash file. If you're using the project as the default, do a sanity check and View data. Sometimes the hash file being written to is not the same one being referenced. Also double-check the filename is still the same. DataStage Server has this "feature" of updating the hash fil...