DSXchange

It remains the case in 7.5 that compilation from the command line is not supported.

There is a tool called "multi-job compile" that you can access from the Tools menu of the Designer client; this may be the "new feature" that you read about. But it's still executed from a DataStage client.

How do you make sure that all associations of multivalued fields are properly defined in the file dictionary for a hash file? For any multi-valued field that has an association name in field #7 of its dictionary entry, ensure that there exists a phrase of that name in the same dictionary that refer...

I have successfully used MAXFETCHBUFF at 16K with UniVerse (not from DataStage, though). So I don't believe that 8K is the upper limit.

None! Sounds like a good question to post on ADN

If the "Lookup Not Successful" rule in your Lookup stage is "Fail" then your job will abort. Change the rule to "Continue" or "Drop".

Do mnemonics for LINKMODE also need to be added to JOBCONTROL.H ? (You can tell that I am not doing DataStage things this week.)

The message itself says it all. Check the schemas rather than the "SQL" column definitions. At one point you have the column declared as an unsigned long integer (uint64); subsequently you load that value into a column designated as a signed integer (int32). The warning alerts you to the fact that n...

QualityStage is the perfect tool for the specification you have given. It is callable from DataStage or works stand-alone, and can perform freeform probabilistic matching.

There's nothing special you need to do. Can you copy/paste within the same job? When you use the right mouse button on a stage, do Copy, Cut and Paste appear in the pop-up menu? Can you use copy/paste in other (ideally non-Microsoft) applications? If not, probably the easiest "solution" is to uninst...

There is no override.

Change the Oracle password, perhaps using sqlplus.

Then change the default value (if any) stored in DataStage. You can do this in Director; choose Set Defaults from the Job menu.

Exactly how are you "flattening" the file with a Sequential File stage? As far as I am aware the Complex Flat File stage is the preferred stage for handling an OCCURS clause.

Please advise exactly where you found DSGetStageLinks() function in "the docs". Include the page number as well as the manual name. I'm not aware of this function.

Welcome aboard! :D I suspect whoever imposed the requirement for test cases meant that you need to be able to prove: that the jobs are identical on each machine that, given the same source data, the jobs will produce identical results on each machine Performance comparisons don't really come into it...

Search the forum for dsjob also.