How to write in same file which is also a source file ?

[sid19]

Hi All,



I have one problem, I am using a unix .text file as a one of the source file for a parallel Job, after look up and funnel stage one out put file(.txt) will come from the job which one should have same name (with the same path) as a source file.

How Can I handle this situation , one solution I have that is, we can give the another name to out put file and from unix overwrite this new file to old one.

but my question is how can i do this from Data Satge Parallel

Thanks,
Shamim

[mansoor_nb]

you can do one thing, create the output staging file and then in the after job subroutine delete the source file and rename the output staging file with the source file name.

[aakashahuja]

Read the source file in to another file / dataset for intermediate staging before doing any of your processing....

[JoshGeorge]

Regardless of Px job or Server job, you can create the output file with a temporary name (Ex: temp.txt). Now in job properties afterjob ExecSh specify on successfull completion (Mind this condition) of the job, rename the temp file name to source file name

mv temp.txt sourcefile.txt

This will overwrite sourcefile.txt with temp.txt and temp.txt will be removed also.

One solution I have that is, we can give the another name to out put file and from unix overwrite this new file to old one. but my question is how can i do this from Data Satge Parallel

[sid19]

Read the source file in to another file / dataset for intermediate staging before doing any of your processing....

Hi Akash,
Can u please give some detail about dataset file so that I can use it in my job

[DSguru2B]

Read Joshy's answer again. He gave a very viable solution.