DSXchange

No. DataStage will tell you how many rows it sent to DB2, and can capture any that were rejected (which you could also count and perform arithmetic). But the only way you can reliably determine what's in a table is to query the table. If your records include a run identifier or last updated timestam...

Make sure that you have read, write and execute permission to the /datastage directory.

Investigate the Difference, Compare and Change Capture stage types.

You could also perform a Lookup against table_new.

The Administrator client Command window does not permit execution of a LOGTO command.

A number of other commands, such as HELP, are also blocked, perhaps because they require terminal handling characteristics, perhaps because they are dangerous (for example QUIT).

That might also be T30FILE structure filling.

Permissions or space issues would relate to whichever directory you have specified to create the hashed file.

A non-pathed hashed file is created in the DataStage project directory.

Despite the dark nature of its contents, the message is largely informative. Because the owning process was killed, the cache had to be invalidated and the dynamic hashed file attached to it had to be forced closed (presumably updating the header information from the T30FILE array in memory in the p...

Check the setting of APT_STRING_PADCHAR environment variable.

Welcome aboard. This particular forum on DSXchange, as Craig implied, is to discuss topics for which a specific FAQ entry might be created. There is a specific forum for questions about parallel jobs, there is also a General forum. We have no forum for interview questions, because we believe that in...

Reindex the project. That should drop and create the indexes (this time without NLS) and re-populate them. The command, which must be executed when you have exclusive access to the project, is DS.REINDEX ALL. You execute this command from the Administrator client Command window or from a dssh enviro...

Why do you have % characters surrounding the format string?

Tip: When the Transformer stage expression editor throws a syntax error, right click on the expression and choose Validate Expression; the editor will report what it believes to be the actual syntax error.

Pivot first, concatenate later. A good rule to remember in parallel job design is "one stage, one task". That's why there are so many more stage types in the parallel job Palette than in the server or mainframe job Palettes.

Separate, I believe.

Make sure you have write permission to the folder where your DataStage client is installed. The reports have to write the intermediate XML on your client machine, even though the final report ends up in the common metadata repository.

You can license QualityStage alone. It shares the same Designer and engine with DataStage, but you will not be able to access some of the DataStage functionality. You can install QualityStage co-resident with DataStage even though their license counts differ. The licensing model is actually based on...

Version 8 uses the Information Server scheduling service. There may be a bug (especially in version 8.0 or 8.0.1) in which the Director client does not correctly report scheduled jobs. Use the Scheduling facility in the Web console for Information Server.