DSXchange

Welcome aboard. :D I'm not sure what you mean by "network interfaces" in this context. SMP to me implies one machine with multiple CPUs. If you want to extend processing to multiple machines, then you're effectively talking MPP. Read the chapter on configuration files in the Manager manual. In it yo...

If any byte in your Char(80) has the value 0x00 this will be treated as the C "end of string" marker, possibly with undesired results.

My error - my brain was thinking of the server ODBC stage. Please disregard my earlier post. I think you may have uncovered a bug; I can't check it, since I'm at a server-only site this week. What does your support provider suggest?

No, I mean the UNIX at command. Where use of cron is governed by the cron.allow file, the at command is governed by the at.allow file.

Not all variants of UNIX support an at command but most seem to.

Check - thoroughly - that both Sequential File stages have exactly the same settings for delimiters, both at the file and record level.

EVERY uses cron, but TODAY uses at - maybe you don't have some required permission to use cron?

By "hang" do you mean "don't advance to a status of running" or "reach a status of running but never reach a status of finished".

The SQL you posted won't update anything. Try the oerr command (oerr ORA 12535) to get recommendations for this particular error. I suspect it's something to do with locks on the table; you may still have a lock from the earlier cursor not released when you come to do the update. If you do the updat...

That message has nothing whatsoever to do with the fact that you're casting a CLOB as a VarChar. Read the error message again. The Oracle server is busy at the time. Something preceding hasn't finished when the next call is made through the OCI. Have your Oracle DBA help you to trace what requests a...

Clearly your not noticing a failure to compile is NOT a bug in DataStage.

Check permissions on every directory in the pathname.

There is no line terminator ("final delimiter") on the final row in your file. It's a data problem.

ANY stored procedure invoked from DataStage must work with a record set. You can find this in the documentation. Any other kind of stored procedure will return that - or a similar - message, often when you're importing the SP definition. And you must import the SP definition before attempting to use...

Write to a text file in a Sequential File stage. Specify compress or gzip in the filter.

You could have pressed F1 or selected the Help menu urgently to get this answer.

If you would like to engage my professional services to read manuals and help files for you, or even to present training, please contact me off-line.

Recommendation Don't hard code 0, 1 and 2, etc. Use DataStage constants from the expression editor drop-down list. That way, if "they" ever change the return values, you're covered. stage_label.$JobStatus = DSJS.RUNOK Or stage_label.$JobStatus = DSJS.RUNWARN Or stage_label.$JobStatus = DSJS.RESET I...