How to add trailer records?

SHARAD123 · Post by **SHARAD123** » Tue Jan 29, 2008 1:43 am

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?

ray.wurlod · Post by **ray.wurlod** » Tue Jan 29, 2008 1:53 am

sachin1 · Post by **sachin1** » Tue Jan 29, 2008 10:49 am

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 ?

mohandl · Post by **mohandl** » Wed Jan 30, 2008 3:49 am

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.

chulett · Post by **chulett** » Wed Jan 30, 2008 7:41 am

"cat trailer_record >> detail_records"

SHARAD123 · Post by **SHARAD123** » Tue Feb 12, 2008 2:14 am

Thnx 4 de help chulett. The suggestion really worked.
I used it in the job control at the end of all process.

asitagrawal · Post by **asitagrawal** » Tue Feb 12, 2008 6:37 am

Time to mark the thread as "Resolved"

DSXchange

How to add trailer records?

How to add trailer records?

Re: How to add trailer records?

Re: How to add trailer records?