DSXchange

In job sequences you have the Execute Command activity available. Does that name suggest its possible purpose?

Oracle wants a timestamp. Give it one. That means (almost certainly) year-month-day order in the date portion and "proper" delimiters. In short, what you get when you SELECT this field from Oracle.

Well, according to John's figures you should be able to finish the whole lot in about 3000 minutes.

Gosh, two on the one day, and neither of them thought to Search!

The input source query to the DB2 stage needs to be passed as a parameter to the job. Why? How do you propose to handle other queries that might return other than a single integer column? Have you really thought this through properly? Why are there no quotes surrounding a string that contains space...

DATATIME I doubt; DATETIME I'd believe. Did you import the Oracle table definition? Did it come in as Date or Timestamp?

Doesn't Search work for you? Lots of folks have encountered this; the error is one of omission when exporting.

There are NO DATA TYPES in server jobs. You can use any operator you like.

Umm.. don't give multiple values of user ID?

Unless you post your code we can't be more targeted than that.

Interesting also that you're getting LRM error rather than ORA error. But we'll let that ride for the moment.

What's different, what has changed? "Nothing" is not the correct answer, it may be the data, it may be the hardware, etc. Did you reset the job and, if so, was there any additional diagnostic information logged?

I'm going to get you to do a slightly unnecessary step that will make following explanations clearer. I want you to execute the same command but to include the headers from the list_readu command. list_readu | head -2 ; list_readu | grep CMN_GET_BATCH_ID_JBS Please post the result, as I am not at a ...

Welcome aboard.

You will not get any sensible answers here because this forum is for server jobs. You needed to post on the job for Enterprise Edition (parallel jobs).

What's different between your development and production environments?

Use substrings and concatenation - it's far more efficient. Right(InLink.TheString,2) : "/" : InLink.TheString[5,2] : "/" : Left(InLink.TheString,4) If you must use Oconv() include the delimiter in the format specification. Oconv(Iconv(Inlink.Field1,'DYMD[...

323032303230 is the hex equivalent of "202020". So, somewhere, a "raw to hex" conversion was being performed, either automatically because you're reading it into a VarChar or because you asked for it somehow. You can convert this back to raw (VarBinary) form using Oconv() with "MY" as the conversion...

Still doesn't obviate the need to loop over all projects. An export file can pertain only to one project.