Page 1 of 1
How to add trailer records?
Posted: Tue Jan 29, 2008 1:43 am
by SHARAD123
Am extracting a set of details from three different tables and inserting them to a file. Now at the end of the file i need to add a record stating the numer of records and the status of the job.
can a routine be enough to do this?
Posted: Tue Jan 29, 2008 1:53 am
by ray.wurlod
Yes.
Re: How to add trailer records?
Posted: Tue Jan 29, 2008 10:49 am
by sachin1
how are you processing your tables, do you have 3 jobs for 3 tables, or just one job for 3 tables, because i think you will be using routine only if your jobs runs successfully and in "After job subroutine", if your extractions is fine you add a record to end of processed file right ?
Re: How to add trailer records?
Posted: Wed Jan 30, 2008 3:49 am
by mohandl
sachin1 wrote:how are you processing your tables, do you have 3 jobs for 3 tables, or just one job for 3 tables, because i think you will be using routine only if your jobs runs successfully and in "After job subroutine", if your extractions is fine you add a record to end of processed file right ?
i am also facing same problem can any one plaese post draft routne code ,it is helpful for me
mohan.
Posted: Wed Jan 30, 2008 7:41 am
by chulett
"cat trailer_record >> detail_records"
Posted: Tue Feb 12, 2008 2:14 am
by SHARAD123
Thnx 4 de help chulett. The suggestion really worked.
I used it in the job control at the end of all process.
Posted: Tue Feb 12, 2008 6:37 am
by asitagrawal
Time to mark the thread as "Resolved"
