HOW to see the data(records) in the VSAM file using ISPF?

crrindia · Posted: Thu May 25, 2006 10:11 am

Hi All, can any one explain me HOW to see the data(records) in the VSAM file using ISPF? without using File-Aid.

Thanks!
Rathna..

gskulkarni · New User Joined: 01 Mar 2006 Posts: 70

You can not. One way is to run a simple step in JCL to copy the vsam file in PS dataset using sort or idcams.

rajandhla · Posted: Thu May 25, 2006 1:45 pm

rathna

go to 3.4 option specify file name press enter

you will see related file for the given file name

then use VB row level command against the data file of KSDS

regards
jai

gskulkarni · New User Joined: 01 Mar 2006 Posts: 70

Jai, i tried what you are saying but i get

rajandhla · Posted: Thu May 25, 2006 2:10 pm

I have checked

when i use the option that i specified it is opening the file in VSAM Browse
By seeing the editor after opening the file it seems it using the DITTO/FILE-AID which i have not noticed earlier . But directly i can open the file as i told

I think now i should be with you.....but still am not sure

Regards,
jai

kalyanp_80 · New User Joined: 03 Feb 2006 Posts: 41 Location: Hyderabad

I have soloution for your question. But that allows you only to view the records.

Command is PRINT IDS(/)

Use the command in the followinf way:
1) Go to 3.4. Type the name of the VSAM data set you want to view.

2) Once it display the data set, type the above command against the data file of KSDS. And press enter.

3) This command is long, it will over write the file name. Dont bother. That is how this command works.

Ex: PRINT IDS(/)AMPAT.VOTESTAT.VSEC.MSTR

Please let me know if it doesn't work.

Thanks,
Amith Patalay
Senior Member Technical,
ADP Pvt. Ltd.
Hyderabad

[/img]

rajandhla · Posted: Thu May 25, 2006 4:11 pm

Amith,

I have used the above command, but it displaying VSAM processing unavailable ......what might the reason any thing missing......

Regards,
jai

gskulkarni · New User Joined: 01 Mar 2006 Posts: 70

can you please elaborate more on the command? what is AMPAT.VOTESTAT.VSEC.MSTR?

kalyanp_80 · New User Joined: 03 Feb 2006 Posts: 41 Location: Hyderabad

Jai,

This command shld work as it is widely used to view the VSAM datasets if we dont have DITTO.

Please give me your e-mail id, I will send you the screen shots for reference.

Thanks,

Amith

kalyanp_80 · New User Joined: 03 Feb 2006 Posts: 41 Location: Hyderabad

AMPAT.VOTESTAT.VSEC.MSTR, is sample VSAM file I used in the example.

Actual command is PRINT IDS(/). This you type against any VSAM file. That will display the records.

gskulkarni · New User Joined: 01 Mar 2006 Posts: 70

Amith, i tried what you said. But upon entering teh system went crazy and i had to press almost 2000 enters to reach final record and final message said "number of records processed 2000.
Now i am not sure what exactly you wanted to convey.

thanooz · New User Joined: 28 Jun 2005 Posts: 99

hi Rathna,

can you give print ch aginest ksds cluster then pres enter,it will display the records.

if it is not work try this give print aginest ksds cluster and press enter.

then it will give this type of prompt.

REENTER THIS OPERAND -
then give ch and pres enter.

then it will prompt like this.

ENTER SUBFIELD OF KEYWORD 'INDATASET' -

then give your ksds cluster name like this . 'your ksds cluster name' and press enter.

I think this will solve your problem.

Thanks,
thanooz.

kalyanp_80 · New User Joined: 03 Feb 2006 Posts: 41 Location: Hyderabad

That is how this command works. It wont open any editor to show the records but display all records one after other in sequence.

I know issuing this command is crazy. But this is the only way you can view the records of VSAM, if we dont have FILEAID or DITTO.

I should have warned initially. Sorry for that.

Amith

gskulkarni · New User Joined: 01 Mar 2006 Posts: 70

hmmm.... and i was struggling to get out of that mess! How do you terminate once it starts? attention/f12/f3 nothing stops it! you have to go ahead with those many ENTERs?

thanooz · New User Joined: 28 Jun 2005 Posts: 99

hi gskulkarni,

if you want to skip press Esc key.

thanks,
thanooz.

crrindia · Posted: Tue May 30, 2006 10:53 am

Hi, Jai, Amith, thanooz, thanks for every one of you who contributes your efforts into this issue. Now I got the resolution thru your suggestions.

Thanks & Regards,
Rathna..

sundaresanjs · New User Joined: 29 May 2006 Posts: 18 Location: USA

hai ratna,

u can use the following type command, let u assume the panel looks like this

main.file1.ps sms001
main.vsam.cluster *vsam*
main.vsam.cluster.data sms010
main.vsam.cluster.index sms020
main.file2.ps sms001
main.file3.ps sms001
main.file13.ps sms001
main.file15.ps sms001

in this panel (3.4 option) in which you see the list of data sets available
now you type the command "PRINT CH IDS(/)" in the arrow shown below

main.file1.ps sms001
main.vsam.cluster *vsam*
=>print ch ids(/)sam.cluster.data sms010
main.vsam.cluster.index sms020
main.file2.ps sms001
main.file3.ps sms001
main.file13.ps sms001
main.file15.ps sms001

and then enter you will get the records.

if you get any error, besure that the records are present in the vsam file

thanks

regards
Sundaresan J

comment if any errors

manishram1 · New User Joined: 23 Mar 2006 Posts: 34

Hi Man,
Just type F2 on the left side of the VSAM.
Like this

F2 ABC.DEFG.HIJKLMA *VSAM*

bcmohanty · New User Joined: 17 May 2006 Posts: 17

The command is PRINT IDS cars

prashant.m · New User Joined: 31 Jan 2006 Posts: 11 Location: bangalore

TRY !!!

PRINT IDS(/) CHAR......as a Line Command against the VSAM file. It displays all the records.

VikasG · New User Joined: 28 May 2021 Posts: 1 Location: India

Joerg.Findeisen · Posted: Wed Feb 01, 2023 9:32 am

Please, do not resurrect 17 year old posts. Start your own new topic when needed.