DSXchange

Use an after-job subroutine that renames the file/data set and then invokes the "real" after-job subroutine.

Please let us know when you 've performed DS.REINDEX ALL having exclusive access to the project, and the results. If there are still issues we can advise further, but prefer not to guess what advice to give.

Welcome to the wunnerful world of Oracle bin Larry! Oracle has only NUMBER for numeric data types. Therefore, when one interrogates its system tables, it reports NUMBER (and the default precision is 38 unless you specify something different in an Oracle CREATE TABLE statement). There's no such thing...

When the jobs abort, reset them in Director and look in the log for any entry "from previous run" which may contain diagnostic information. Are there any other warning messages in the job logs for these jobs?

Hi, Can u provide u r id so that i can send them zipped. Sri. Welcome aboard. Please use English, not SMS, on this forum. Not everyone understands your abbreviated forms, particularly those for whom English is not a first language. Also please read your licensing agreement with IBM, which I believe...

The main difference is that a Data Set is a parallel struture. A flat file is not. DataStage TX (the forum where you've posted) can not handle Data Sets. Data Sets store data in internal format (for example binary numbers).

Do it in an after-job subroutine. You can do whatever else it is you're doing in there AND re-naming/moving the file without any difficulty at all.

No facility exists for exporting a single table definition or a single routine or a single anything else.

I did once write a routinefor dumping a table definition into a number of formats, including XML.

You have hijacked this thread. Please start a new one. Your question is unrelated to the original post.

The method would depend on precisely how you create the rows for the CSV file but it's do-able in any particular case.

You'll probably find that the line number (plus or minus a few, depending on how many header files have been $INCLUDEd) refers to the line in the code generated by the Transformer stage in which your routine (ConvertIP) is called. Put a test into ConvertIP that uses the Num() function to check that ...

Find out from your DBA on which record the deadlock is occurring - for example it might be an update being performed by a trigger from each node, but of which you were unaware.

Why indeed are you using sequential files at all? This defeats the purpose of having parallel processing. Why not use Data Sets? (You can copy or move these with the orchadmin command.)

Get your SAP Administrator involved - this problem has occurred attempting to access an IDoc.

Use a before-job subroutine.
Use OpenSeq, a loop containing ReadSeq statements, and CloseSeq.