DSXchange

What changed 'day before yesterday' or its day before ?

What happened after your reboot?

How are you running the jobs? i.e through OS prompt or via DS?

What steps happen before you get the error ?

Or simply to a StringToDate and use it as a date.

Can you create a new job with ODBC stage and see whether it works ?

Craig,

I also do not have Premium but assume you are referring to placeholders for binding variables.

Karthik,

Can you provide the full error with associated ora code.

Did you do OR

Log the ids to a sequential file and do a diff to confirm the exclusiveness.

Check the memory usage and locking with your DBA.

Did you try using sqlldr with externally generated ctl file.

There must be more log. Can you let us know of them too.

Also
1.) what is the sequence doing?
2.) when it fails?
3.) does it always fail in the same place with the same message?
4.) What is the activity where it fails? (is that compiled and not in aborted state)

Convert '/' to newline.

Doh !!! Not server.

Surprising that the delete will go for table level lock rather than row level. Maybe it is escalating because of low memory.

Try to monitor with help of your DBA.

With no disrespect, did you try to search? There are loads of examples.

things are same in 8

You can do a regular expression match in Oracle itself (in source SQL).

In DataStage, you can do an Index()

Simplest will be to have 2 columns - keyCol and nonKeyCol (both Varchar). Send all key cols concatenated with markers into keyCol and non key to nonKeyCol. When reading, split them accordingly. Second option (This is a guess...maybe Ray can ratify !!) 1.) Create an universe ODBC link 2.) First job t...