HI,
i should create control job to get the record count of the of the target file,my source is flat files ,how should i create this.what are the fields i should configure.how to use it in job sequencer to load 5 flat files.
Thanks
sunitha
create control jobs to get the record count in the target
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 98
- Joined: Thu Feb 05, 2009 1:14 am
- Location: visakhapatnam
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
However you like. Simplest is probably a wc -l command on source and target, executed through Execute Command activity in sequence or DSExecute in job control routine.
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: 98
- Joined: Thu Feb 05, 2009 1:14 am
- Location: visakhapatnam
- Contact:
-
- Participant
- Posts: 51
- Joined: Sat Dec 09, 2006 3:32 am
If you want to get the number of records processed in the job then After job routine would do fine.Remember few records could be rejected at stage level for such issues this is a better option.
Or If you just want the count of records from source and target files then wc -l suggested above is the best option .
Or If you just want the count of records from source and target files then wc -l suggested above is the best option .
------------
Elias
Elias
-
- Participant
- Posts: 51
- Joined: Sat Dec 09, 2006 3:32 am