Updating in Server jobs

[chand]

Hi all,

Can any one help me finding out.. how to update the files in the server job.
I know that in parallel jobs we use change capture and chage apply stages to update the data.....

Thank you,
Regards,

[kcbland]

To "update" a file you must read the existing file and write a new one. Do not attempt to read and write to the same sequential file, as it won't work. Simply design a job of SEQ --> XFM --> SEQ.

[chand]

Thanks Kcbland,

I guess i got your point, but little bit confused still.
you mean i dont need to do anything except using 'Xfm' Stage and writing it to new file simply.

[kcbland]

Yep. One SEQ stage to output the contents of the file to a XFM stage to map it to the input of another SEQ stage. The XFM stage applies whatever changes you need to the data content.

[chand]

I got you, Thanks for the help 'KCbland'