Hi all
My requirment is as follows
I have a seq file (let's say name of the file is "customer.dat"
I wanna make 3 files from this file as follows :
1.customer.dat ----- which will contain all data of the parent file
2. customer.ctl------ which will contain record count , time of file generation,name of the parentfile.
3.customer.eot----- to indicate the end of transcation of dat file.
Can any one please suggest me , how can i design a job in DS7.5.2 to fulfilling this requirement ?
Thanks in Advance
TRIPLET FILE CREATION
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 29
- Joined: Mon Nov 20, 2006 7:17 am
- Location: Melbourne
TRIPLET FILE CREATION
Saugat Dey
-
- Participant
- Posts: 29
- Joined: Mon Nov 20, 2006 7:17 am
- Location: Melbourne
-
- Participant
- Posts: 29
- Joined: Mon Nov 20, 2006 7:17 am
- Location: Melbourne
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Use a Routine activity in a job sequence. This routine uses DataStage BASIC. Within this language the STATUS statement can retrieve the date/time created or modified, file size and other items of information. The routine can also execute a wc -l command to determine the line count. And, of course, the routine can write the information to the required files.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 29
- Joined: Mon Nov 20, 2006 7:17 am
- Location: Melbourne