DSXchange

As yet, the DSXchange group has no version 8.0 training to offer (though some is in the pipeline, I understand). IBM has released DataStage Essentials for version 8.0 (code DX444) which includes a couple of modules on setting up and configuring IIS and DataStage. It's other courses in the suite are ...

Find out the job number.
SELECT NAME, JOBNO FROM DS_JOBS WHERE NAME = '<<Job Name>>';

Look in subdirectory RT_SCnnn (where nnn is the job number) in your project directory on the server for the generated code, generated osh, and scripts to run them.

Try setting the Record Delimiter String property to \r\n and removing the Record Delimiter property.

Please post the entire, exact error message, and a description of your job design, including the stage types used.

.... except that there IS a line terminator as every 16th character in the source file.

Abhilasha wrote:can u suggest some approach with existing resources and technology.

Manage expectations better.
Drop indexes and constraints from the target table. If that's not acceptable, use bulk-loader technology for the inserts.

Or use a Filter command in your Sequential File stage to effect the same pre-processing using, for example, a sed or awk script. The Sequential File stage reads stdout from the filter command.

These routines attempt to create SDKSequences if it can't be opened. Check permissions on SDKSequences and D_SDKSequences in your project directory. If someone has deleted these (find them and convince them that this was a very bad thing to do) you need to delete the VOC entry. DELETE FROM VOC WHERE...

Can you script Cybermation to check for both times (the CoSort finish time as well as the job finish time), and only proceed when both indicate that they are finished? I guess CoSort is busy cleaning up the resources (including disk resources) that it consumed, even though it's delivered the final r...

1. Radically different. In version 8 DataStage is an optionally installed component of IBM Information Server. 2. What's your IT budget? (Ask IBM or search their website - the suite grows nearly every month.) WebSphere is IBM's marketing term that encompasses everything that could be called "middlew...

You don't actual need the A margin (where the level 01 item begins) to be in column #8 - that's just a convention. You can tell the import process where the A margin is. Similarly, the B margin is conventionally four places indented from the A margin - so, if your level 01 item begins in column #8 t...

Manage expectations better.
Get faster hardware and more memory.
Drop indexes and constraints from the target table. If that's not acceptable, use bulk-loader technology for the inserts.

Oh yes it is - the executable checks that both APT_CONFIG_FILE and APT_ORCHHOME are set.

Pretty much the case - you do have to make sure that a small number of components are deployed to the other machines, perhaps by mounting disk, perhaps by other means. Details are in the manuals. But only the parallel framework supports this capability; server jobs expect to run on a server, hence t...

... which is the default value for APT_STRING_PADCHAR. Set this up as a job parameter and change its value to " " (a space character).