Finding an vsam file

honey · New User Joined: 15 Sep 2004 Posts: 5 Location: india

Hi ALL

How to find out the file is a VSAM file in application program itself

Regards,
MOZHI

sandip_datta · Posted: Tue Oct 19, 2004 10:28 am

In SELECT Clause, the organisation is "INDEXED" for VSAM File.

Regards,
Sandip.

honey · New User Joined: 15 Sep 2004 Posts: 5 Location: india

Regards,
honey

jz1b0c · Posted: Mon Nov 15, 2004 11:58 pm

chandrasekhar · New User Joined: 29 Sep 2004 Posts: 35 Location: bangalore

jz1b0c · Posted: Thu Dec 09, 2004 11:52 pm

Great day!

Can you give me the syntax of select clause for an ESDS file.

I guess it looks same as flat file.

veera · New User Joined: 24 Nov 2004 Posts: 20 Location: chennai

[quote="jz1b0c"]Great day!

Can you give me the syntax of select clause for an ESDS file.

I guess it looks same as flat file.[/quote]

hi,
FILE-CONTROL.
SELECT FILENAME ASSIGN TO AS-DD1.
IN THIS WAY U CAN FIND OUT IN APPLICATION PROGRAME.

REGARDS,
VEERA.

unna · New User Joined: 15 Oct 2004 Posts: 17

Hi,

The syntax is

Select filename assign to dd1
Organization is Sequential
Access mode is Sequential

for ESDS which is also the same for a Flat file. Organization varies depending on the VSAM file.

Organization is Indexed for KSDS and RRDS
Access mode is Sequential for ESDS and for RRDS it may be Seq,Random or Dynamic

chandrasekhar · New User Joined: 29 Sep 2004 Posts: 35 Location: bangalore

jz1b0c · Posted: Mon Dec 13, 2004 9:58 pm

Chandra,

I still want to make it clear,
Because even without giving AS- you can code your file defination in cobol program, I have a program, in which I didn't mention any AS- suffix.

So I guess its some standard followed to make it understood.

Otherwise how do you find out?

veera · New User Joined: 24 Nov 2004 Posts: 20 Location: chennai

[quote="jz1b0c"]Chandra,

I still want to make it clear,
Because even without giving AS- you can code your file defination in cobol program, I have a program, in which I didn't mention any AS- suffix.

So I guess its some standard followed to make it understood.

Otherwise how do you find out?[/quote]
HI,
FIRST SEE QUESTION,HE WANT TO FIND OUT IN APPLICATION
WHETHER IT ESDC OR FLAT FILE,WHAT I AM GIVE IN EARLIER CORRECT
ACCORDING QUESTION.IF U WANT TO FIND OUT WHETHER IT VASAM,OR NONVSAM,WITH THE HELP OF AMP PARAMETERS ONLY GIVEN FOR VSAM DATA SETS

veera · New User Joined: 24 Nov 2004 Posts: 20 Location: chennai

[quote="veera"][quote="jz1b0c"]Chandra,

I still want to make it clear,
Because even without giving AS- you can code your file defination in cobol program, I have a program, in which I didn't mention any AS- suffix.

So I guess its some standard followed to make it understood.

Otherwise how do you find out?[/quote]
HI,
FIRST SEE QUESTION,HE WANT TO FIND OUT IN APPLICATION
WHETHER IT ESDC OR FLAT FILE,WHAT I AM GIVE IN EARLIER CORRECT
ACCORDING QUESTION.IF U WANT TO FIND OUT WHETHER IT VASAM,OR NONVSAM,WITH THE HELP OF AMP PARAMETERS ONLY GIVEN FOR VSAM DATA SETS[/quote]

THANKS®ARDS,
VEERABABU.

jz1b0c · Posted: Thu Dec 16, 2004 12:16 am

In your terms application means a program?
In that case, I have a program, in which I didn't mention any AS- suffix.

ksivapradeep · New User Joined: 30 Jul 2004 Posts: 95

hi unna,

for sequential(flat file) we mention s-suffix and for ESDS we can mention AS-suffix ok how can u find out for ksds or rrds by seeing only the select query.and then one more is even u didnt mention the S-suffix for flat file it will give output so at that time how we have to identify the file

regards,
siva pradeep