DSXchange

One way to look at it is that what you can access from your PC is similar to what DataStage can access from its server. You can access databases on database servers with the right client software such as Oracle client or ODBC. You cannot open MS Access databases or files on other computers unless yo...

It's not a built in flag but rather a method you code in manually. You need to input one field into the QualityStage job - raw organisation/individual text. You output three fields from the QualityStage job - raw, standardised for organisation name only and standardised for organisation and individu...

If you have trouble connecting to DataStage when you are not hooked into a network try the "Omit" option with a server name of ".". This can work even when "localhost" or machine name or IP address does not work.

I don't understand why you are using an ODBC stage at all, surely two enterprise DB2 stages would be better. If they are two different remote DB2 databases you might have a problem with clashing environment variables. See the DB2 Remote Configuration Guide, if you don't have one ring Ascential-IBM s...

You would be hard pressed to find the differences in DataStage versions 7 and prior. Most of the IBM information is about the new features in the IBM Information Server. You can find a lot of IBM Information Server info on this site by searching for it. Ray had a long post. I had a couple posts on m...

Previously I have coded QualityStage overrides into a DataStage hosting job. The DataStage job had a set of flags as job parameters. It called the QualityStage plugin and standardised various name, address and company name fields. The override flags let the operator choose which version of a Quality...

There is the IBM certification exam 415. See dsxchange threads Certification Pass Score and Datastage Enterprise Edition Certification [ Test 415 ] and a FAQ post at How do I get certification for DataStage? . There is also a DataStage Certification information page with links to IBM pages and blog ...

You would have just the US states in the lookup. You would add the * to the output data in the transformer when a lookup row is not found. There is no reason to try and bring back ** records from the lookup when you can generate ** strings in the transformer.

As I said, get the DB2 Remote Configuration Guide.

Tricky, DataStage isn't great at creating new rows. You could have four outputs from a transformer, put a constraint on each: three "input.col3 = 'ALL'" links hard coded to X, Y and Z and one "input.col3 <> 'ALL'" that passes through a value. After the transformer you would need to merge the four st...

For those of you who frequently put links into posts, either to external sites or dsxchange threads, I got a firefox add-on CoLT that puts extra copy functions on my browser right mouse click menu. It let's me copy a link to the clipboard in BBCode format (with the url brackets). I can paste it stra...

There are some DB2 environment variables for setup documented in the Install and Upgrade Guide. These go into either the dsenv or the project specific environment variables. The former if you want all projects on the server to point at the same DB22 client instance, the latter if you want multiple c...

Not a fan of the database generated keys unless you have multiple products loading at the same time. The DataStage generated keys do a good job. See my comments at: Why database generated surrogate keys drive me nuts!!!

Your QualityStage Designer documentation directory on your install CD should have a PDF on the DataStage Plugin. It is free with QualityStage. Chapter 2 in the PDF covers installing the plugin and the QSRT Manager. There should also be a QS_DataStage_PlugIn_GUI directory on the disk that you need to...

You have two ways of doing it. The surrogate key generator stage does handle the multiple partitions to give you unique numbers. You can mimic this in a transformer stage variable following the instructions in the FAQ forum on creating a parallel counter.