DSXchange

Right, csplit isn't a complete answer all by itself as what it will do is create seperate files based on columnar data. After that, you still have the need to get them named appropriately. The Folder stage is a much better one step answer, IMHO.

Not really a question at all but rather another proposed solution...

Sorry, never seen an issue where a simple "-jobinfo" request would hang. Are you saying it always hangs for all jobs or you only have this problem with one particular job?

OK. Do other jobs run out of cron ok and just this one has an issue or do all cron jobs fail? Honestly, I have no idea what might be going on, just trying to ask intelligent questions to try and narrow this down. You really should put this in front of your official support provider, IMHO.

I have used dsjob command to trigger the job in my server routine. First of all I am checking the whether the job is in compiled/finished/aborted status using dsjob -jobstatus command. That option is actually used to run a job and then wait until it is complete before passing back the status of the...

ketfos wrote:A fatal error has occurred in DataStage.
Unable to re-open operating system file ""

You need to find out what this means. I wonder if the job instelf is corrupted somehow... can you run the job manually?

2) We did not use any surrogate key in the above algorithm anywhere Clarify this statement for us, please. Do you mean you just didn't include discussion of the role of a surrogate key in your talk about the 'algorithm' involved or are you saying that you did not leverage a surrogate key in your ac...

Please don't post the same question multiple times. Your first one is in the correct forum, this one isn't.

The job includes the need to "parse the feed and separate the Header, Detail and Trailer record", not just a straight conversion as noted in the subject...

Depends on what you mean by "binary feed". I'm guessing you mean a mainframe file either in EBCDIC or with packed fields or both. Can you clarify? And confirm you are using a Server job, please.

Well... then it sounds like you're stuck with the neck of that particular bottle.

... and then rebuild the dataset, I assume.

Welcome. There are several posts here on this subject. Vamsi has posted one iterative method. Another is to use a Folder stage as the target as it can do all that work automatically. Note, however, that the Folder stage is a Server stage so you'd either need to use a Server job (which would be the b...

It is a solution to the issue.

Across jobs? Can't be done, at least nothing automatic. That's not to say you could build something to go back and "undo" a partial load but you would need to code the deletes / updates needed to reverse the load to that point.