DSXchange

Note also that ProfileStage ceases to exist as a separate product in version 8.0. It, AuditStage, and some of QualityStage are all rolled into a new product for learning about your data. The name of the new product is IBM WebSphere Information Analyzer.

None of the "Ascential" products is presently available to download as a "personal edition" for private study. I suggest that, if enough people make this request to IBM (for example 10 thousand from here), they might take some notice.

The usual technique is to capture them individually in stage variables then use other stage variables to assemble the output message.

vmdsapi.so absolutely must be present. Use find to determine where this library is, and include it in your library search path. Also make sure that DSHOME is actually set.

There are many possible answers. Possibly the simplest is to interpose an Execute Command activity to invoke the test -z filename command.

As well as reindexing, Cleanup also searched for and removed orphans left over from incomplete job deletions. Yes, "they" took it out with no explanation given.

Create THIS job using the same SQL and report the flow rate:
This will serve as a start point for determining where the bottleneck - if any - exists.

Is Oracle server on the same machine as DataStage server, or are you performing lookups over a network connection?

Are you getting untranslated EBCDIC data from the AS400 or ASCII?

Thanks Participants As you all know very well that datastage repository is stored under operating system level. so the behaviour of datastage is dependent on Operating system , that's why some times we will be encountering unidentified errors though the things are fine as per our design. RK That is...

Doctor: "Does this hurt?"
You: "Yes."
Doctor: "Well don't do it!"

You may prefer the Left() and Right() functions, as being more meaningful to future developers.

Some people here would be happy to sell - not give - you routines and other tools; but it would still be incumbent upon you to create some form of specification. There are two types of routine for server jobs; before/after subroutine (callable from jobs and active stages) and transform functions (ca...

Don't hold your breath: the new version has only just entered beta testing.

Obvious, I should have thought: smaller queries or larger result buffer.

Look at Metaview360 - they have experts, "fast start" packages, mentoring and so on that can really give you a "kick start".