DSXchange

Well, apparently the temporal cliff did.

As noted, SPINTRIES are for HP systems and HP-UX. I'd check with your support provider before turning it on for anything else. Also note you cannot add your own entries to uvconfig.

Good find! Let us know...

Official information is here on the off chance you haven't seen it yet. The link is for Change Data Capture and there is another link to the Change Data Delivery product near the bottom. Why not engage IBM or other consultancy that specializes in things like Proof of Concepts and is familiar with th...

You. As noted. Assuming your tables are actually partitioned.

Search here or in your docs for the $Counter variable that is automatically populated per interation from your delimited list. Assuming the StartLoop stage has such a list, then pass "StartLoop_StageName.$Counter" as the filename inside the loop.

Run them to a Sequencer set to 'Any' - that in effect becomes your 'dummy job' and the end point of the sequence of tasks.

chulett wrote:Well... you can alway try stopping and restarting DataStage. Worst case reboot the server itself.

This was all about avoiding those two options.

I tended to avoid stages with a 'timeout' setting for precisely these reasons, at some point they will timeout. About all you can do is increase the timeout value. If that's not helping, all I could suggest after that is to contact your official support provider and see what other options you have, ...

Not really interested in the logs at the moment, more interested in the source code for the custom routines that are involved here. Find them in the Repository browser and double-click on them to get to the code. As to the jobs, that would just be whatever shows up in the Designer on the canvas. Des...

And? :? One would typically ask a question or detail out job designs with perhaps even whatever steps you've taken to attempt to trouble-shoot this. Not just simply dump some logs here. You would have to tell us what happened. All we can see from what you posted is the custom routine GetNextFile whi...

The devil is in the details, please be more precise. "Nothing just blank" means what, exactly? If the EOR is right after the comma then try checking for select.DATE='' rather than select.DATE=' ' and see if that is the magic you were missing.

Of course... everything must be read, it's the nature of sequential media.

Exactamundo.

Tell us what you mean by "empty". You checked for a single space and an empty string should be checked for with just a pair of qoutes: ''