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
 

 

Finding an vsam file

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
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    Post subject: Finding an vsam file
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: 151
Location: Tokyo, Japan

PostPosted: Tue Oct 19, 2004 10:28 am    Post subject:
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    Post subject: THANKS SANDIP
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    Post subject:
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    Post subject:
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    Post subject:
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    Post subject:
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    Post subject:
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    Post subject:
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    Post subject:
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    Post subject:
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    Post subject:
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    Post subject:
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    Post subject:
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    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 SORTJOIN - Copy Matched and Unmatched... Steve Ironmonger DFSORT/ICETOOL 0 Tue Jan 17, 2017 4:26 pm
No new posts how to recover an uncataloged VSAM da... archanamuthukrishnan All Other Mainframe Topics 3 Wed Jan 11, 2017 6:18 pm
No new posts Underlying DB2 VSAM LDS - SMF recording vasanthz All Other Mainframe Topics 6 Thu Jan 05, 2017 4:20 am
No new posts Copy RECFM =VB TO FB file with RECL =... sahil41352 DFSORT/ICETOOL 3 Wed Dec 28, 2016 11:29 pm
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


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