DSXchange

Do an exact search on 'fork() failed, Resource temporarily unavailable' to get a better understanding of the error message.

I'd be interested in 'its' implemention in server jobs

Sorry guys for the harsh words, in a bad mood this morning. But my understanding of the question was of a gui prompt. If anything other than that then I must have missed it. Even I have scripted solutions where the parameters are being passed during execution, but thats via another file and not a pr...

Thats rubbish. DataStage designer and director have excellent parameter prompts. dsjob is meant to be used for automated execution and not interactive execution.

Well explained Craig. Guess your enjoying your weekend and are in a good mood.

Great. Modularization always helps, especially for debuggin purposes.

Search the forum, there have been routines by kcbland and other folks to get a lot more information at different levels than just row counts. Kim duke leads them all with his ETLStats. Search is the key.

Sometimes the easiest workarounds get rid of stubborn errors. Dropping and recreation is on of them. Did you ever get to hear from IBM? Just curious.

Use it after the job finishes in a routine activity in a sequence job.
OR convert the routine from a transform to before/after job subroutine and call it in the after job subroutine.
You can also search the forum for other ways of getting row counts.

Use it after the job finishes in a routine activity in a sequence job.
OR convert the routine from a transform to before/after job subroutine and call it in the after job subroutine.

Read my explanation again. It tells you why I am creating a hashed file. The DICT VOC is used because I am selecting the first column using positional names (F1) which requires the key words DICT VOC. I realize that you have the values in a partiular field. You need to get them in a comma delimitted...

As the name mentions, while loading. These stage utilize the database's bulk loader to blaze data into the table. They are usually used for huge amounts of data.

Is this the last column in order? Some other data in some previous column must have taken up enough space as to not allow for another column. Check for each column, one by one.

Yup, in other words, just load 'em datasets without worrying about size limit. Your disk might burn out

Yea, that was my mistake assuming there is an MVS forum. The poor guy posted in the px forum and we continued with this post. O well.