inserting stastic and dynamic data in txt file

[harryhome]

Hi

I need to enter following data in seqeuncial file.


Name
Address
Timestamp
abc|123|456
edc|567|789
piu|345|567
EndofFile
Endofchar


Here first 3 rows and last 2 rows are static and rest of the rows are retrived from database table.

I was trying to do this in 3 jobs, 1st job write first static part in file then in 2nd job append dynamic part into same file by reading database then in 3rd job append remaining dyanminc part in same file.

[Sainath.Srinivasan]

Have constant files for header and trailer.

You can concatenate them as part of the after-job command.

[ray.wurlod]

Agreed. As a before-job activity you may need to extract and preserve the header and trailer portions.