DSXchange

Learn. Were any other errors/warnings logged? Did you transcribe the error message accurately? Note that pasting it as the subject line has truncated it - how about pasting the complete error message into the body of a post on this thread. Have you performed a Search to see whether anyone else has e...

Describe - exactly - how you have set up the SCD stage - ideally with a picture of each tab.

Talk to your DBA about keep-alive interval and/or inactivity timeout.

DataStage *should* disconnect; perhaps you could run an ODBC trace to see whether the SQLDisconnect() function is called - if it is, the problem is with ODBC, if it is not, the problem is with DataStage.

No. There are internal linkages maintained between the table definitions branch of the Repository and job designs into which those definitions have been loaded or from which table definitions have been saved. If you right click on the Columns grid in a passive stage in a job design you will find tha...

Check that the compiler is correct, that the four environment variables associated with the compiler and linker are set correctly on the new server.

The ODBC driver for Excel requires - mandates - that the worksheet be in "pure" tablular format with column headings.

Why did you bother buying DataStage, if you're going to script everything?!

What is the output link execution order in your Transformer stage?

If the rejects link is first, then all rows will be "rejected", because the rejects link handles any row that has not been processed by an earlier-executed output link.

The RESIZE is only ever required once per project - once &PH& has been converted to Type 19 it remains thus for ever. Clearing, or clearing old files from, &PH& is good practice - once jobs have completed and/or been reset the files in &PH& are no longer required. If you are ...

That's fair, bcause the job sequence has aborted in each case.
Restartable is clearly a different flag somewhere.

"Stopped" is usually stopped by operator - that is, a Stop request was issued.
"Crashed" is an internal error which is usually sufficiently severe as to preclude any diagnosis.

... or a custom routine with Open, RecordLockU, Write and Close.

Why not just create a server job to execute the query and load the result either into that job's user status area or into a file for subsequent retrieval?

Look on the Stage properties of your Sequential File stage - is it set for UNIX-style, DOS-style or None? Look in the file itself, using a hex editor. How are lines in the file actually terminated? Note that, if lines can be more, equal or less than 637 characters, then you do NOT have fixed-width f...

You seem to have a grasp of what is needed. While it is not necessary that the QS datafile definition for the Oracle table have the same name as the table, I would suggest that it is best practice to do so. With your QS Designer software is the QS help file (QualityStage.chm). Open this and do a sea...

I was editing the post when Arnd posted that!