DSXchange

Yes, [] is substring but you need to recheck the start position, your number starts at something more like 84 or 85.

I thought you had checkpoints? Meaning, if the routine successfully completes and the checkpoint is cleared, it will not run again on a restart. Why is the routine being executed again?

Why did you add the Div to the suggested solution?

That sounded fine... what "failed" about it?

Fair enough.

Why not Folder stage what? Have you read up on how it works? It was built for XML and not really appropriate here. IMHO.

I doubt that unless 'resources' means 'disk space'... have you actually tried it? Ray's way does this in a virtual fashion, so no 'extra' resources there. You could also consider a named pipe...

Ah, the perils of user-defined sql. You need to select the same number of columns as are defined in the stage, in the exact same order.

Performing without a net, eh? Or I guess we be the net.

I'll see what I can find.

Or we could just wait for you to copy/paste all the rest of it in.

Use the debugger to determine what is wrong with your constraint such that it doesn't allow any rows to pass through it.

When you get the pack you'll get the documentation that comes with it. It's all there.

As noted, your problem comes when the 'current date' has changed before you get around to restarting the sequence. Why are you not getting things restarted in a timely manner? If 'next time' means the next day, should you not reset the sequences so they in fact do not restart where they left off but...

You'd have to ask IBM that question. Many times what you'll find is the old code is indeed no good but a bug in the old version allows it to seem to work. They then tighten up the code and you can no longer get away with it in the new version. Or it could be a new bug. Ask your official support prov...

I'm curious, if you are under pressure for a fix have you not asked your support provider for help?

I had a similar issue with Server on Itanium, when I get in the office I'll see if I can find their answer in my archives.