I need to read a file through a routine. Can anyone help me out with this?
Thanks In Advance
Reading a file through a routine
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
We are trying to do the auditing of the jobs basically.The file which is to be read contains all the jobs source name, target name, and their respective input and output link name. Through a dummy job I need to call a before Job routine which would read this file. Could you help me on this?Sainath.Srinivasan wrote:Why and What do you want to achieve ?
-
- Premium Member
- Posts: 142
- Joined: Mon Jun 27, 2005 5:31 pm
- Location: Atlanta GA
Craig has already recommend the preferred method, using DataStage to read and work on this file.
There are a number of DS/Basic routine calls which let you open, close, read records or even read bytes from sequential files; but they involve a lot of programming and testing unless you have done this sort of thing before; so why not let the built-in DataStage functionality take care of it instead of trying to re-invent the wheel?
There are a number of DS/Basic routine calls which let you open, close, read records or even read bytes from sequential files; but they involve a lot of programming and testing unless you have done this sort of thing before; so why not let the built-in DataStage functionality take care of it instead of trying to re-invent the wheel?