Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

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

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
View previous topic :: :: View next topic  
Author Message
crrindia

Active User


Joined: 02 Jul 2005
Posts: 124
Location: Gurgaon

PostPosted: Thu May 25, 2006 10:11 am    Post subject: HOW to see the data(records) in the VSAM file using ISPF?
Reply with quote

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..
Back to top
View user's profile Send private message

gskulkarni

New User


Joined: 01 Mar 2006
Posts: 70

PostPosted: Thu May 25, 2006 10:50 am    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
rajandhla

Active User


Joined: 18 Oct 2005
Posts: 182
Location: Luton UK

PostPosted: Thu May 25, 2006 1:45 pm    Post subject:
Reply with quote

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
Back to top
View user's profile Send private message
gskulkarni

New User


Joined: 01 Mar 2006
Posts: 70

PostPosted: Thu May 25, 2006 1:59 pm    Post subject:
Reply with quote

Jai, i tried what you are saying but i get
Code:
IKJ56500I COMMAND VB NOT FOUND


are you sure it is not inhouse ISPF command? Is it used widely. may be my shop is not as updated, but i am doubtful if it is that.
Back to top
View user's profile Send private message
rajandhla

Active User


Joined: 18 Oct 2005
Posts: 182
Location: Luton UK

PostPosted: Thu May 25, 2006 2:10 pm    Post subject:
Reply with quote

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
Back to top
View user's profile Send private message
kalyanp_80

New User


Joined: 03 Feb 2006
Posts: 41
Location: Hyderabad

PostPosted: Thu May 25, 2006 3:59 pm    Post subject:
Reply with quote

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]
Back to top
View user's profile Send private message
rajandhla

Active User


Joined: 18 Oct 2005
Posts: 182
Location: Luton UK

PostPosted: Thu May 25, 2006 4:11 pm    Post subject:
Reply with quote

Amith,

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

Regards,
jai
Back to top
View user's profile Send private message
gskulkarni

New User


Joined: 01 Mar 2006
Posts: 70

PostPosted: Thu May 25, 2006 4:29 pm    Post subject:
Reply with quote

can you please elaborate more on the command? what is AMPAT.VOTESTAT.VSEC.MSTR?
Back to top
View user's profile Send private message
kalyanp_80

New User


Joined: 03 Feb 2006
Posts: 41
Location: Hyderabad

PostPosted: Thu May 25, 2006 4:35 pm    Post subject:
Reply with quote

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
Back to top
View user's profile Send private message
kalyanp_80

New User


Joined: 03 Feb 2006
Posts: 41
Location: Hyderabad

PostPosted: Thu May 25, 2006 4:38 pm    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
gskulkarni

New User


Joined: 01 Mar 2006
Posts: 70

PostPosted: Thu May 25, 2006 4:42 pm    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
thanooz

New User


Joined: 28 Jun 2005
Posts: 99

PostPosted: Thu May 25, 2006 4:43 pm    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
kalyanp_80

New User


Joined: 03 Feb 2006
Posts: 41
Location: Hyderabad

PostPosted: Thu May 25, 2006 4:50 pm    Post subject:
Reply with quote

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
Back to top
View user's profile Send private message
gskulkarni

New User


Joined: 01 Mar 2006
Posts: 70

PostPosted: Thu May 25, 2006 4:52 pm    Post subject:
Reply with quote

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?
Back to top
View user's profile Send private message
thanooz

New User


Joined: 28 Jun 2005
Posts: 99

PostPosted: Thu May 25, 2006 7:34 pm    Post subject:
Reply with quote

hi gskulkarni,

if you want to skip press Esc key.


thanks,
thanooz.
Back to top
View user's profile Send private message
crrindia

Active User


Joined: 02 Jul 2005
Posts: 124
Location: Gurgaon

PostPosted: Tue May 30, 2006 10:53 am    Post subject:
Reply with quote

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..
Back to top
View user's profile Send private message
sundaresanjs

New User


Joined: 29 May 2006
Posts: 18
Location: USA

PostPosted: Tue May 30, 2006 3:14 pm    Post subject:
Reply with quote

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
Back to top
View user's profile Send private message
manishram1

New User


Joined: 23 Mar 2006
Posts: 34

PostPosted: Wed May 31, 2006 5:20 pm    Post subject: Re: HOW to see the data(records) in the VSAM file using ISPF
Reply with quote

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

F2 ABC.DEFG.HIJKLMA *VSAM*
Back to top
View user's profile Send private message
bcmohanty

New User


Joined: 17 May 2006
Posts: 17

PostPosted: Mon Jun 05, 2006 1:59 pm    Post subject:
Reply with quote

The command is PRINT IDS cars
Back to top
View user's profile Send private message
prashant.m

New User


Joined: 31 Jan 2006
Posts: 11
Location: bangalore

PostPosted: Thu Jun 15, 2006 12:22 pm    Post subject: Re: HOW to see the data(records) in the VSAM file using ISPF
Reply with quote

TRY !!!

PRINT IDS(/) CHAR......as a Line Command against the VSAM file. It displays all the records.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Add PD field from 2nd file to PD in 1st Sushant Garje DFSORT/ICETOOL 6 Thu Dec 01, 2016 4:32 pm
No new posts File Aid to File Manager conversion murali3955 IBM Tools 4 Thu Nov 24, 2016 3:41 pm
No new posts Limit duplicate records in the SORT pshongal SYNCSORT 6 Mon Nov 21, 2016 12:54 pm
No new posts How to convert the VBM file to VB or... Sulabh Agrawal JCL & VSAM 4 Fri Nov 18, 2016 1:04 pm
No new posts CICS Roll back partially - Need to re... dwijadas CICS 4 Wed Nov 16, 2016 4:30 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us