DSXchange

If other applications are also updating the table using the sequence, you can also refer to the sequence nextval property in user-defined SQL.

Analyze the SP logic and implement using DataStage. There are no "conversion" utilities.

DS_AUDIT is not reliable in version 8. I think Brad's technique is about as clean as you're going to get. The DTM is available through XMETA, but querying that is ugly, even if you use Metadata Workbench.

Clearly not. You created more processes than this amount of paging space could deal with. Try to create fewer simultaneous processes.

Not quite, I asked you to insert Char(10) (linefeed) characters where needed.

Clearing old entries from the &PH& sub-directory will help, too.

Welcome aboard.

System tables are read when DataStage checks the metadata in your design against those for the tables you're dealing with.

Did you use a different user name when the run worked?

Is col1 marked as Key?

Look in the job log to see the actual SQL being sent to Oracle. You may need to put single quotes around the parameter markers if their data type warrants. The error is an Oracle error, so you have to figure out why Oracle does not like the SQL that DataStage is sending it. I've even seen the need t...

So you can add in some literal (surrounded by ZQ delimiters) when needed, such as to specify the default country in a COUNTRY standardization.

Close and re-open DataStage Designer?

Commit is not relevant for bulk load. How have you set up the stage to communicate with the bulk loader?

Yes there is an issue. Domain administrator doesn't do it. You must be in the local Adminstrators group.

This is more easily accomplished with a server job, in which the Sequential File stage has a "missing column" rule.

D0n1117 wrote:does the Complex flat file stage support record_delim_string ?

No.