IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Finding an vsam file


IBM Mainframe Forums -> DFSORT/ICETOOL
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
honey

New User


Joined: 15 Sep 2004
Posts: 5
Location: india

PostPosted: Mon Oct 18, 2004 12:52 pm
Reply with quote

Hi ALL

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

Regards,
MOZHI
Back to top
View user's profile Send private message
sandip_datta

Active User


Joined: 02 Dec 2003
Posts: 150
Location: Tokyo, Japan

PostPosted: Tue Oct 19, 2004 10:28 am
Reply with quote

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

Regards,
Sandip.
Back to top
View user's profile Send private message
honey

New User


Joined: 15 Sep 2004
Posts: 5
Location: india

PostPosted: Tue Oct 19, 2004 1:05 pm
Reply with quote

Regards,
honey
Back to top
View user's profile Send private message
jz1b0c

Active User


Joined: 25 Jan 2004
Posts: 160
Location: Toronto, Canada

PostPosted: Mon Nov 15, 2004 11:58 pm
Reply with quote

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

Regards,
Sandip.


Sandip

For an ESDS VSAM file Organization can be sequential in that case how do you find it out
Back to top
View user's profile Send private message
chandrasekhar

New User


Joined: 29 Sep 2004
Posts: 35
Location: bangalore

PostPosted: Thu Dec 09, 2004 9:17 pm
Reply with quote

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


Use of ORGANIZATION clause indiacate that the file is a VSAM file
Back to top
View user's profile Send private message
jz1b0c

Active User


Joined: 25 Jan 2004
Posts: 160
Location: Toronto, Canada

PostPosted: Thu Dec 09, 2004 11:52 pm
Reply with quote

Great day!

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

I guess it looks same as flat file.
Back to top
View user's profile Send private message
veera
Warnings : 1

New User


Joined: 24 Nov 2004
Posts: 20
Location: chennai

PostPosted: Sun Dec 12, 2004 9:08 pm
Reply with quote

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

New User


Joined: 15 Oct 2004
Posts: 17

PostPosted: Mon Dec 13, 2004 4:52 pm
Reply with quote

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

New User


Joined: 29 Sep 2004
Posts: 35
Location: bangalore

PostPosted: Mon Dec 13, 2004 7:28 pm
Reply with quote

Quote:

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


Dear friend
I am agre with VEERA .
AN ESDS muust prefixed with AS-


THANKS
CHANDRA
Back to top
View user's profile Send private message
jz1b0c

Active User


Joined: 25 Jan 2004
Posts: 160
Location: Toronto, Canada

PostPosted: Mon Dec 13, 2004 9:58 pm
Reply with quote

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

New User


Joined: 24 Nov 2004
Posts: 20
Location: chennai

PostPosted: Wed Dec 15, 2004 11:52 pm
Reply with quote

[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
Back to top
View user's profile Send private message
veera
Warnings : 1

New User


Joined: 24 Nov 2004
Posts: 20
Location: chennai

PostPosted: Wed Dec 15, 2004 11:53 pm
Reply with quote

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

Active User


Joined: 25 Jan 2004
Posts: 160
Location: Toronto, Canada

PostPosted: Thu Dec 16, 2004 12:16 am
Reply with quote

In your terms application means a program?
In that case, I have a program, in which I didn't mention any AS- suffix.
Back to top
View user's profile Send private message
ksivapradeep

New User


Joined: 30 Jul 2004
Posts: 95

PostPosted: Thu Dec 16, 2004 12:31 pm
Reply with quote

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
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DFSORT/ICETOOL

 


Similar Topics
Topic Forum Replies
No new posts Unable to interpret a hex value to De... COBOL Programming 4
No new posts how to eliminate null indicator value... DB2 7
No new posts VSAM LISTCAT INFORMATION JCL & VSAM 2
No new posts Format Binary file to EBCDIC JCL & VSAM 4
No new posts Binary File format getting change whi... All Other Mainframe Topics 7
Search our Forums:

Back to Top