DSXchange

DataStage does not do this kind of "auto recovery". Can you be certain that the changes were successfully saved? Did you (she) compile the jobs after the changes were made? Perhaps you ran the previous version because you had not re-compiled?

Please advise how you resolved this, and whether your solution handles names like BILLIE JEAN KING.

Set the Field Width property for each of these fields.

About the only way I can think of (apart from using cascading reject links on Column Import stages) is to read the entire line as a single VarChar field and parse it using Field() functions in a Transformer stage. Missing fields will return "" from the Field() function; you can do with the...

Check with your Oracle DBA to determine the maximum number of Oracle listeners that have been configured. This will be a hard upper limit for your (system-wide) number of simultaneous connections.

These should not have entries in the catalog; DS_TEMP* are simply directories and RT_CONFIG* are regular hashed files. Try VERIFY.SQL TABLE /appl/Ascential/DataStage/Projects/DEV_XXX/DS_TEMP1 to see what it reports. If there's a fixable error, then run VERIFY.SQL again using the FIX option. (Having ...

Go back to DS_JOBS and find out what job numbers 1358 and 2934 are about. I suspect the latter is the main culprit.

Then review DS_JOBOBJECTS again, based on this number. just to see what else is there.

It does not. Please read what I said carefully. Do not confuse cause and effect.

What is your exact version number?

You may have encountered a bug that is fixed in a later release or for which a patch exists. Have you asked your official support provider?

If you've attended the class you should have been given a CD with the files on it. If not, ask IBM to supply the same.

may be slightly more efficient.

It is a fundamental tenet of database technology that the database engine determines the order of row storage, not you. If you want sorted values when you query the table, specify this requirement in the query.

Hi , Please see that i am getting these many error messages in log node_node1_1: Player 4 terminated unexpectedly. main_program: Unexpected termination by Unix signal 10(SIGBUS) main_program: Unexpected exit status 1 Unexpected exit status 1 Unexpected exit status 1 main_program: Step execution fin...

No, but you can get a UNIX-based ODBC driver for SQL Server (one ships with DataStage) and go through that.

The function is NextSurrogateKey() and requires you to have created a state file or to use a database sequence. Full details are to be found in the manual.