DSXchange

Then it is no longer the 'same file' if suddenly it can't find the record delimiter.

IMHO they serve two purposes. One is the typical 'reusable code' usage. If you have common business logic that will be used in multiple places, they allow you to have one set of code that everyone can use so the rules are applied correctly in all cases. Another use is as a local container (not share...

Please let me know if we need to verify any other place holders to understand the reason for slowness in post process routines functions execution. Hard to say much more until you provide enough details of exactly what it is you are doing to allow someone to help you. Suggest you either spell out i...

Did you check 'paramerr' after the function call? What is 'job2'? It needs to be a handle to a job, not an actual job name, obtained using DSAttachJob.

It all by itself doesn't have to reach 2GB, it just has to push the total used by that process over 2GB. Wow, the entire project has everything running on a single node? Kind of defeats the purpose of the tool IMHO. And yes, using multiple nodes would mean understanding and testing partitioning. So....

Yup! It needs to know what ran ok or with warnings.

Ack... forgot to point out the fly in the ointment! :shock: Those values are just the "1" and the "2" you used explicitly in your second example, they do not stand on their own. So your first attempt equates to saying "1 or 2" which is always true. Combine the two to ge...

No, he means set the stage property so it runs sequentially in your parallel job, i.e. one instance only. That or run on a single node. IMHO a better solution would be to understand why it is 'suspended' - deadlocks? Blocking locks? And then change from 'auto' to one where you control the partitioni...

Sorry but what kind of response are you looking for? Seems like you have identified your 'issue' so perhaps you need to look at optimizing your routine... hard to say without knowing anything about it, what it does and how it is coded. Or perhaps some of those activities can be time-shifted? Meaning...

I opened it up, hopefully it helps.

RUNWARN means "finished with warnings" so it would have to "succeed" but have warnings rather than actually ABORT for the trigger to pass control thru. One suggestion - if you have two triggers and one should go forward and everything else should stop, I always used "Otherwi...

Note that is error about "not enough space" is a bit confusing as it has nothing to do with disk space but is really all about RAM driven by the "bit-ness" of the application as you noted in your subject. You are running a 32bit version of DataStage which has the 2GB limit you me...

Why in the heck did you feel the need to come back here and nuke all of your posts?

Not that I recall on 'standards' and such. There has always be a Server Job Developer's Guide that shipped with the product or the online documentation that you can find here.

It means... get your Official Support Provider involved if you haven't done so already.