DSXchange

Excellent!

You can use boolean job parameters to accomplish the same thing as your 'hard coded' constraint - which, while it will stop the flow of records down the link, will not stop the file from being created. It will just be empty when you are done.

madhonrougeuri wrote:Could some body give me any pointers

Your DBA, I would think. Unless by "JDEdwards buffer file" you mean something other than a DB2 table.

Check your install under Routines\Built-In\Before/After. On release 7.1 and prior Unix servers ExecDOS does not appear. On NT servers it is there. Trust us I do trust you, Uncle Ken. I'm sure there's an ExecDOS on a Windows server and (only having made it to 7.0.1 so far) hadn't seen one on a UNIX ...

Interesting... that's not my understanding as to how it works or how I've been using it. I'd need to double-check the docs and play around a bit to have any more feedback on the subject.

If you've got it working that way, then great. Are you sure it actually did the sort?

Really? I don't recall ever seeing it in any of my drop-down lists... ExecSH yes, but no ExecDOS.

I've always had this issue and just changed my offset by one so that it stopped bugging me.

Or they are running a UNIX server, in spite of how the post is labelled.

That's new in 7.1 ? Doh! I specifically went out and read the "What's New in 7.5" pdf and it sure made it sound like it was added in that version. So, all it turns into is checking off an option and the Sequencer will automagically add the code to handle restarts. That's what I get for still being o...

It would probably make it a little easier to get the statistics you are after if you did. But either way can be made to work.

Upgrade. Probably the simplest answer. Otherwise you can download a 'Restartable Job Example' that is posted in the File Library on ADN - looking at how to do it is much better than someone trying to explain it here as it's rather... messy.

What exact version of DataStage do you have? 7.5.x includes the ability to automatically do what you want, lower versions would require alot of custom tweakage to accomplish the same thing.

Through shell scripting you are going to need to leverage the dsjob command. Search the forum for the syntax of the command and suggestions that others have already posted, like this one for example.

so do i also need to specify the input data file in the filter command ? does datastage not indirect the file specified in the sequential file stage to the filter command? Nope, it doesn't do anything automatic with the normal 'Filename' in the stage. You are required to put something in there, but...

Not really sure what might be wrong. All the Filter command does is execute the command as entered and the stage then reads 'standard out' as if it were a flat file (so to speak). So, yes, any informational or extraneous messages would be a problem.