Opening a VSAM file

ritesh pandey · New User Joined: 09 Feb 2007 Posts: 11 Location: Pune

Hi ,

Can anybody send me the syntax for opening a VSAM file through Print command .

expat · Posted: Wed Jul 23, 2008 2:49 pm

The PRINT command of what, IDCAMS, COBOL, SAS ???

Rajesh Sampath · New User Joined: 18 Jun 2008 Posts: 9 Location: Pune

U mean Print statement.

print ids(/) ch ?

ritesh pandey · New User Joined: 09 Feb 2007 Posts: 11 Location: Pune

Thanks Rajesh for quick reply, but i have already tried . It doesn't work.
Do you know any other option to open a VSAM file without File Aid .

expat · Posted: Wed Jul 23, 2008 4:05 pm

What is it that you want to do with the VSAM file, and what organisation is it, ESDS, KSDS, RRDS, Linear ?

Please post your errors from your abortive attempt - "It doesn't work" is hardly much for anyone else to go on ...........

karthikr44 · Posted: Wed Jul 23, 2008 4:58 pm

HI,

If its OPENed somehwere, then you will get open error 168.

If error code 168 occured for u then
Find out who else is using this dataset, get it closed, then type PRINT IDS command, you won't get 168 then.

Regards
R KARTHIK

ritesh pandey · New User Joined: 09 Feb 2007 Posts: 11 Location: Pune

WE don't have any tool like file Aid .So anybody suugest me how can i see the content of the KSDS VSAM file ?

expat · Posted: Wed Jul 23, 2008 5:47 pm

Itanium · Active User Joined: 22 Jan 2006 Posts: 114 Location: India

ritesh,
Can you please explain what you want and what you are trying to do ?

Have you already checked VSAM Manuals for your queries ?

Thanks.

ritesh pandey · New User Joined: 09 Feb 2007 Posts: 11 Location: Pune

I am tring to see the content of the VSAM file through print statment ie print ids(/) ch . I am getting the error message
** VSAM OPEN RETURN CODE IS 160
NUMBER OF RECORDS PROCESSED WAS 0
LASTCC=12

NitinP · New User Joined: 12 May 2008 Posts: 3 Location: Chennai

Hi Ritesh ,

The Command you are asking is PRINT IDS(/) CH , Type this command before your vsam file , I would not suggest using this because you have to keep pressing Enter until end of file reaches , Check if your shop uses FILEAID, INSYNC etc

Regards

expat · Posted: Wed Jul 23, 2008 6:24 pm

Well, we are sort of getting there ................

1) Please post your code and JCL
2) Please post the complete message, including the message ID's - e.g. IDC3009I

Quick thoughts - are you using INDATASET rather than allocating the dataset via a DD and DISP=SHR then using INFILE in your control statements. Using DD name and INFILE is much safer and causes less enqueue problems

Robert Sample · Posted: Wed Jul 23, 2008 6:25 pm

Run a LISTCAT on the VSAM file to see if it has data. One of the reasons for a return code 160 is that the file contains no records.

dbzTHEdinosauer · Posted: Wed Jul 23, 2008 6:26 pm

and since your dd statements are correct,
your jcl syntax for the utility being invoked is correct,
and all the parms that you provided the utility are correct,
there can be only one answer: the computer made a mistake

Robert Sample · Posted: Wed Jul 23, 2008 6:28 pm

Dick:

If I posted something like that, I'd make sure I was in a well-grounded location because lightning just has to be on the way!

dbzTHEdinosauer · Posted: Wed Jul 23, 2008 7:01 pm

Robert:

(might want to check out another thread - This isn't the first where I made 'questionable assumptions'.

17 posts in this thread, and we are finally getting around to what the OP would have said if he knew enough to do so.

He only wants to print some records from a vsam file. quite a leap from this:
Can anybody send me the syntax for opening a VSAM file through Print command?

enrico-sorichetti · Posted: Wed Jul 23, 2008 7:05 pm

i wish that everybody before posting had read
http://catb.org/~esr/faqs/smart-questions.html

dbzTHEdinosauer · Posted: Wed Jul 23, 2008 8:06 pm

Read? Read! Read?

most posters do not even read the preceding posts; why expect them to read a near document type thing? the whole (hole) idea of this forum is to try to find some eager-beaver to provide code for 'my' problem. Why read, when one can just continually type 'I NEED THIS or is it that, or that and this, or that that and this'?

enrico-sorichetti · Posted: Wed Jul 23, 2008 8:10 pm

and every time You say... never never again, and the next time....
You provide manual reading services as usual

Robert Sample · Posted: Wed Jul 23, 2008 8:27 pm

Itanium · Active User Joined: 22 Jan 2006 Posts: 114 Location: India

sometimes it reduces the interest to answer other questions... ;-)