DSXchange

0 means "infinite wait" but that does not directly affect the current problem. Timeout allows the reader process to conclude that no more rows will be arriving or the writer process to conclude that the reader process has died. You might try setting the writer timeout to a finite value, say two minu...

DateToString() and StringToDate() functions with appropriate format strings.

I am not aware of any.

1. Yes. But it's obvious - they are different products. They put different magic numbers in the object code header, and generate similar but different sets of opcodes. For example UniVerse does not have memory caching for hashed files. 2. No. 3. Precompilation is a "sanity check", for example making...

DSProjectMapName is an internal parameter. The error message suggests that your old server has NLS enabled and your new server does not.

When you buy the server to parallel service, you have to agree to your job designs being "offshored". Make of that what you will.

You probably have a syntax error in the Transformer stage which therefore can not compile.

A good place to begin would be to look at whether the examples mentioned in the error message apply in your case - the temporary directory is non-local or not have enough free space at the time when the error occurs.

DSGetLinkInfo() is a transform function, not a before/after subroutine. You will need to write an interlude before/after subroutine that invokes DSGetLinkInfo().

Writing to a pipe can fail if the pipe itself becomes full - the reader process is draining data from the pipe more slowly than the writer process is sending data into the pipe.

Ultimately - and particularly in Japan where there are many different encodings of characters - you need to know how the character set is encoded. ASCII and ISO8859-x are "single byte character sets" so it should be a simple matter of reviewing which map(s) handle all the character in your data. The...

MNEMONICS is a pseudo map that recognizes "ASCII representations" such as <N?>.

You may find MNEMONICS-1 even better, as it recognizes "ISO885901" representations such as <o>> (LATIN SMALL LETTER O WITH CIRCUMFLEX).

keshav0307 wrote:you can find what query statement is submitted through your job?

Yes, it's reported in the job log.

There is no Pivot stage in DataStage TX.

Please post in the correct forum (Enterprise Edition).

General

Or, drawing a slightly long bow, Metadata