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?
How to add trailer records?
Moderators: chulett, rschirm, roy
How to add trailer records?
222102
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Re: How to add trailer records?
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?
i am also facing same problem can any one plaese post draft routne code ,it is helpful for mesachin1 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 ?
mohan.
MOHAN
-
- Premium Member
- Posts: 273
- Joined: Wed Oct 18, 2006 12:20 pm
- Location: Porto