MVSFORUMS.com

gharidoss

Hi All,

My input file contains 100 records. I want to load the data from 51 record onwards, by using Load utility.

Any ideas will be appreciated...

Thanks in advance
Hari

kolusu · Posted: Wed Jan 18, 2006 5:07 am Post subject:

gharidoss,

Run a utility (sort/fileaid/idcams...) step to copy the records from 51 and use that file to load. search for "split" in the utlities forum for examples.

Hope this helps...

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

Manas Biswal · Posted: Wed Jan 18, 2006 12:27 pm Post subject:

gharidoss,

You can also use the WHEN clause in the LOAD utility to filter out the records if they fall within some specific range, but as Kolusu said, the less time consuming method would be to use a sort step before the LOAD utility.

If you want to know more about the WHEN clause, then have a look at the following link -

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNUGH10/2.12.1.4?SHELF=&DT=20010216104113&CASE=

Regards,
Manas
_________________
There is no path to peace. Peace is the path.
- Mahatma Gandhi (1869-1948)

gharidoss · Posted: Thu Jan 19, 2006 12:10 am Post subject:

Hi All,

Sorry for the late reply.

I can do as suggested by Koulsu and also I verified the Link. It's very useful to me.

Thanks,
Hari
_________________
http://mainframe-world.com