DSXchange

Interesting, thanks for posting that. Was curious about the "piece-wise" in your subject, found this when searching for the ORA error: ORA-03127: no new operations allowed until the active operation ends Cause: An attempt was made to execute a new operation before the active non-blocking o...

I have no clue never having used the stage but perhaps someone else does. Or ask support.

Hence the suggestion to contact support.

Any chance the partition you are writing to is filling up?

Welcome. Not sure why there was a need to create that text file, anything the Notification stage needs should already be there. Curious why you did that and wondering if "%Server%" should really be "%server%" but from what I recall that's not even leveraged on a UNIX system. :? F...

What kind of problem / errors are you seeing when there is more than 4? Are you supplying the SQL or is the stage generating it? I've seen limitations in the past with other stages when the size of the user-defined SQL exceeds what the stage could hold and the end of it would get trimmed off, result...

There's also this, allegedly patched in an earlier release:

http://www-01.ibm.com/support/docview.w ... wg1JR41831

Still, in your shoes I'd contact support.

You may also be able to get away with just the "last update date". We use that as the high water mark from our source systems and then extract where the last update date is greater than the previous max last update date, which we have stored. This because when they create a new record, the...

Thinking you may need to leverage the UstringtoString() function here.

All of that is in my very first reply. Ray touched on it as well. Go back and reread those posts and let us know if any of that is still unclear.

Perhaps an explicit conversion is in order?

Ah... that could be. Use whatever Century value is appropriate in your shop based on the incoming date.

cyclogenisis wrote:The routine is working very well. Thanks Craig & Ray.

See your quoted text, the value is right there.

Ah yes, I recall that now but funny it didn't come up in my quickie search of the Server pdf. Further perpetuating the myth of the Julian date! And one of the Mainframe folks here gave me a "Perpetual Julian Date" calendar just because they knew it would irk me. :wink: And both of you guys...

Thanks Thomas, moved it. Unfortunately, right off the top of my head I don't have an answer and don't have the proper time to research. I wonder if Ray's freely available date routines do that kind of conversion?