DSXchange

Welcome Aboard, Provide more information. The more you do, the more it will be easier for us to get to the bottom of this. We need to know your design, what you are trying to do, complete warning/fatal error messages copied from your log file. You can also use the site's search facility to pull up o...

Its better to modularize you job. But if you insist, I dont see any problem in using the reject file in the same job. Onces all the records are written to the file, only then the read operation is going to start. Thats how it works in server. I am guessing the same rule applies in px as well

swades wrote:How can I do this with Merge Stage ?

You asked for it to be done in Merge stage, you got expert advice on so many stages that can get your work done.

However, server jobs are very limited in processing possibilities, so I prefer to develop most things in parallel jobs. A simple storage of a value to be retrieved later on is best to be done in a server job. Its a small job and hence preferably done in server. For massive processing use parallel j...

Exports are on my desktop. Need to ftp the files on to my unix server (DataStage server) for the diff.

Constraint and then pivot. This way you dont need an extra stage. Why didnt I think of that. Probably I was too tired.

You manager or who ever signed the PO will be having more information about it. Or maybe if you guys have a product admin at your site, he/she will be able to help you out.

That is certainly a very good practice. All these things make up for a good design with no room for tuneups

Opsi , I got them in the wrong order then
Sorry umamahes.

Sure you can do this in one job but tell me this, when you get a max, you will get one value. Your file might have x records. Do you want the max from database to be with all the records of your file?

JobType = 0 for server job
JobType = 1 for parallel job
JobType = 2 is Job Sequence

Refer to Ray's first reply in this post.

Probably another transformer after the pivot stage to constraint the output maybe

Ray was talking about unix diff command. Craig was talking about ultaedit. Two different things.

Something like
in after job subroutine as Ray suggested.
If you want date in a different format, check for more formatting options in google or your favourite search engine.