I need a help. I have a VSAM file which has many records(around 6K).
All the data present are in hex format. and the VSAM is a KSDS format.
I need just one record from that VSAM file into my note pad. Is there any possibility for that to be done.
Joined: 06 Jun 2008 Posts: 8237 Location: Dubuque, Iowa, USA
If you read the "How to code subparameters" chapter of the manual Access Method Services for Catalogs in the DFSMS bookshelf for any release of z/OS, you will find that subparameters (such as FROMKEY and TOKEY in a REPRO command) can use text, hexadecimal, or binary values. So you could code the FROMKEY and TOKEY as (X'ROBERTSAMPLE') and the REPRO will work. Or, you could code your JCL with spaces for the length of the FROMKEY and TOKEY fields, turn hexadecimal on (with the HEX ON ISPF/EDIT command), change the FROMKEY and TOKEY values to the necessary hexadecimal values, and then turn hexadecimal back off.
This is, of course, assuming that you are looking for a record in the KSDS by the key value. If you are looking for some random character string (which you did NOT state in your original post), your best procedure will probably be to dump the entire data set to a sequential data set, edit the sequential data set, and then use a FIND command. On the ISPF EDIT command line typing X ALL; F X'??????'; DEL X ALL will leave you with only the line (or lines) that contain your desired data in the data set -- assuming you're using the ; as a command separator.
Use File Aid if you want -- but my suggestions are for IDCAMS, not File Aid. I know File Aid supports hexadecimal values since I used it at a previous employer, but I do not currently have access to it and hence cannot speak about how to get what you want with it.