DSXchange

Obviously didn't like the answer and intends to keep posting the question until the preferred answer is posted.

Start with a Search for "abnormal termination of stage".

I suspect the interviewer, lacking knowledge of how DataStage works, had in mind an answer involving a system variable such as @INROWNUM. Similarly, the output of the SELECT statement might be piped through a UNIX head command. We, of course, know that such a design would actually select all the row...

If it's any consolation, it's a trap that catches many new players.

The name of the function is Substrings (with a final "s"). You left this off, so DataStage is looking for a variable called Substring.

It would be edifying if you could post the combined wsdl.

... or even a UV table in DataStage

Remove Duplicatesstage.

The message "traversed 33 fewer bytes than present in the record buffer" means that your data do not match your metadata. The difference is 33 bytes.

The Sort stage in server jobs is not particularly efficient. It is often more efficient to have the UNIX sort command sort the data. If even more speed is required, you can use products such as SyncSort or CoSort.

The subroutine that writes to the log runs from line 265 (address 0x684) to line 288 (address 0x78c). As you can see, it uses the value from the control record //SEQUENCE.NO - which is an integer. So I don't think that's the problem. The problem may be in one of the other routines invoked in DSD.Wri...

Welcome aboard. You can simply import the DataStage components from your DSX file. The jobs will run, from a DataStage perspective. However, if you have anything DOS-specific in your designs, such as pathnames and record delimiters in text files, your jobs (or DSX) may need some tweaking for UNIX ru...

Look for the "bad file" generated by sqlldr.

Etiquette Note Do not hijack threads. This thread is nearly 18 months old. Start a new thread where you have a new question. Search the forum first; you question may already have been answered. Further, your question does not relate to the subject of this thread. Once you have created a new thread ...

Welcome aboard. 8 + 10 + 10 is only 28; what do you want to do with the other ten characters? You can use the Left( string , n ) function to get the leftmost n characters from a string, the Right( string , n ) function to get the rightmost n characters from a string, and Substrings( string , start ,...