MVSFORUMS.com

[tattva]

Hi all,

can any one help me out write a REXX utility which will extract the records ( based on some criteria) from a VSAM file.

Input to the rexx should be :- 1)criteria.
2) VSAM file name.
3) output dataset name

Note;- am new to REXX

Thanks,
Guru

[superk]

What would be the point? All of this can easily be done in a single IDCAMS REPRO command.

[tattva]

Superk,

I'm sorry !! .. But didnt know that approach..

can u post me the jcl please!!

Thanks,
Guru

[kolusu]

tattva,

Please search before posting. check these links for topics which discuss accessing vsam file in rexx.

http://mvsforums.com/helpboards/viewtopic.php?t=2702&highlight=vsam

http://mvsforums.com/helpboards/viewtopic.php?t=365&highlight=vsam

You could use sort/file-aid to copy the records from a vsam file to a flat using INCLUDE/OMIT conditions. Check the utilities forum for examples

Hope this helps...

Cheers

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

[kolusu]

Superk,

can you show me the IDCAMS repro Jcl which can be used to filter records? Let us say I want all the records which has 'kolusu' in the 1st 6 postions. As far as I know you can only select the records based on key. ie. FROMKEY to TOKEY or FROMNUMBER to TONUMBER

Check this link for repro command parameters.

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/dgt1v403/3.25?DT=19990113080956

Thanks

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

[superk]

My concept of "filtering" records from a VSAM file is to retrieve them by the index key. For anything else, a SORT "INCLUDE COND" would be a better solution.

[superk]

For my understanding, and to help me provide better responses in the future, maybe the original poster could define what was meant by