DSXchange

This may or may not work - I can't recall whether UV/Net functionality was incorporated into DataStage.

Try using a pathname in field 2 of the hashed file's VOC entry of the form hostname!pathname.

Did your routine compile successfully?

Note that it will not return any results in the Test bed of the Routine editor (since it's not being called from a job there).

What happened to your "in parallel" requirement?

Probably best is the Education Assistant

You can also check out the IBM Knowledge Center and, of course, the pertinent manuals.

Favourite t-shirt ever:

Yes, hosted there.

You can easily do what Kim suggested by making a copy of the job, selecting the container and choosing the option to deconstruct it.

Rows out of order ARE detected and will cause the job to abort.

There is an option to tolerate unsorted data, which increases memory demand. This property value is set to False by default.

Resist stupid requirements!

It's not there, but you can append it to the Table Name field. The content of the Table Name field becomes the FROM clause of the generated SQL. Just make sure that the WHERE clause (and GROUP BY, HAVING and ORDER BY if you wish) occur in the correct order and after anything that needs to end up in ...

Once you're in the before-job subroutine the job is already attached and is available via the job handle DSJ.ME. Therefore you can use the DataStage API functions to do any discovery using that as the job handle (first argument). For example TrueJobName = DSGetJobInfo(DSJ.ME, DSJ.JOBNAME) Place the ...

You can not. Your reading is inaccurate. Data Rules can be shared between Information Analyzer and DataStage, in particular the Data Rules stage. Data Rule definitions can be created in either tool, and published into the repository to make them available to the other tool (and to Metadata Workbench...

D_Last_Batch will always be created, irrespective of the hashed file type. This is the "Dictionary" which contains the column definitions, etc. If you've settled on using Type 2 as recommended, delete first the contents of Last_Batch directory (using rm -rf Last_Batch/*) then delete the di...

Make sure that the Unicode extension is either set on all links (input links and output link) or not set on all links.

What does your official support provider advise?