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

How to use AIX in ESDS to faster the processing


IBM Mainframe Forums -> JCL & VSAM
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
mkssampathkumar
Warnings : 1

New User


Joined: 31 Aug 2006
Posts: 57
Location: chennai

PostPosted: Wed Feb 07, 2007 2:33 pm
Reply with quote

Hi
how to Use AIX in ESDS.
i created a AIX ,Path.But i dont know hot to use it in program.

Normally ESDS is used for sequential processing.How AIX will be used to faster the processing?

Plz explain with sample cobol pgms.
Thanks in advance
Back to top
View user's profile Send private message
William Thompson

Global Moderator


Joined: 18 Nov 2006
Posts: 3156
Location: Tucson AZ

PostPosted: Wed Feb 07, 2007 2:52 pm
Reply with quote

mkssampathkumar wrote:
how to Use AIX in ESDS.
i created a AIX ,Path.But i dont know hot to use it in program.
Normally ESDS is used for sequential processing.How AIX will be used to faster the processing?
Putting an AIX on an ESDS turns the ESDS into a KSDS, just code your program as such. Keyed access is fsete than sequential access if only a few records are needed.
Quote:
Plz explain with sample cobol pgms.
I think not, it would be more educational for you to provide your code for review and assistance.
Back to top
View user's profile Send private message
mkssampathkumar
Warnings : 1

New User


Joined: 31 Aug 2006
Posts: 57
Location: chennai

PostPosted: Wed Feb 07, 2007 3:14 pm
Reply with quote

Hi
Thanks for ur reply
Normally ESDS will be support only for a sequential access.
key is used to fetch the record directly.

SELECT INPUTFL ASSIGN TO AS-DD1
ORGANIZATION IS SEQUENTIAL
ACCESS MODE IS SEQUENTIAL
ALTERNATE RECORD KEY IS EMPID
FILE STATUS IS INPUTFS.

I coded the above statement in my program.but am getting
A "RECORD KEY" or "ALTERNATE RECORD KEY" clause was found for a file that did not have "INDEXED" organization.

Thanks in advance
Back to top
View user's profile Send private message
William Thompson

Global Moderator


Joined: 18 Nov 2006
Posts: 3156
Location: Tucson AZ

PostPosted: Wed Feb 07, 2007 3:24 pm
Reply with quote

If you are going to access the file "sequentially" why use a key? If you are going to access the file by a key, then its organization is not "sequential", it is "indexed".
Does that help?
Back to top
View user's profile Send private message
mkssampathkumar
Warnings : 1

New User


Joined: 31 Aug 2006
Posts: 57
Location: chennai

PostPosted: Wed Feb 07, 2007 3:28 pm
Reply with quote

Hi
Yes i understood.
Then how can be use the alternate index in esds?
whats the use of ALternate index in ESDS?
Can we specify some other access mode in ESDS?
Back to top
View user's profile Send private message
William Thompson

Global Moderator


Joined: 18 Nov 2006
Posts: 3156
Location: Tucson AZ

PostPosted: Wed Feb 07, 2007 3:43 pm
Reply with quote

mkssampathkumar wrote:
Then how can be use the alternate index in esds?
Keyed access for a few select records instead of sequentially scanning the entire file.
Quote:
whats the use of ALternate index in ESDS?
What's the use of sequential access against a KSDS file?
Quote:
Can we specify some other access mode in ESDS?
Yes, you have already named another.
Back to top
View user's profile Send private message
mkssampathkumar
Warnings : 1

New User


Joined: 31 Aug 2006
Posts: 57
Location: chennai

PostPosted: Wed Feb 07, 2007 4:39 pm
Reply with quote

Hi
we can specify Access mode is sequential in KSDS.like that we cant specify Access mode is indexed in ESDS.

how can u access using key?

Can u give with examples and select Clause???

What i mentioned other than Sequential?
Back to top
View user's profile Send private message
William Thompson

Global Moderator


Joined: 18 Nov 2006
Posts: 3156
Location: Tucson AZ

PostPosted: Wed Feb 07, 2007 4:49 pm
Reply with quote

mkssampathkumar wrote:
we can specify Access mode is sequential in KSDS.like that we cant specify Access mode is indexed in ESDS.
Only if you have an alternate index defined for it.
Quote:
how can u access using key?
Thru its alternalte index.
Quote:
Can u give with examples and select Clause???
You almost already had one:
Quote:
SELECT INPUTFL ASSIGN TO AS-DD1
ORGANIZATION IS indexed
ACCESS MODE IS SEQUENTIAL
ALTERNATE RECORD KEY IS EMPID
FILE STATUS IS INPUTFS.
Back to top
View user's profile Send private message
mkssampathkumar
Warnings : 1

New User


Joined: 31 Aug 2006
Posts: 57
Location: chennai

PostPosted: Fri Feb 09, 2007 10:01 am
Reply with quote

Hi William
Thanks for ur reply.
we cant uise the Alternate Index in ESDS Cobol.Its not possible.
in CICS we can use the alternate index for ESDS.

Select filename assign to dd1
Organization is indexed
access mode is sequential.

We cant give this syntax in ESDS file.It wont accept this syntax.
It surely gives error.
If u can try this and let me know.It will be very useful for most of the people.
Because,i studied like we cant use other than SEQUENTIAL in ESDS file.But u r saying we can use the INDEXED organization.

Thanks
Bye
Back to top
View user's profile Send private message
mkssampathkumar
Warnings : 1

New User


Joined: 31 Aug 2006
Posts: 57
Location: chennai

PostPosted: Fri Feb 09, 2007 10:06 am
Reply with quote

Hi

SELECT INPUTFL ASSIGN TO AS-DD1
ORGANIZATION IS indexed
ACCESS MODE IS SEQUENTIAL
ALTERNATE RECORD KEY IS EMPID
FILE STATUS IS INPUTFS.

This syntax will not be work surely.
Back to top
View user's profile Send private message
William Thompson

Global Moderator


Joined: 18 Nov 2006
Posts: 3156
Location: Tucson AZ

PostPosted: Fri Feb 09, 2007 2:39 pm
Reply with quote

mkssampathkumar wrote:
SELECT INPUTFL ASSIGN TO AS-DD1
ORGANIZATION IS indexed
ACCESS MODE IS SEQUENTIAL
ALTERNATE RECORD KEY IS EMPID
FILE STATUS IS INPUTFS.

This syntax will not be work surely.
All I can add to this is many people, including myself, have put a AIX on top of an ESDS and accessed it by key thru a COBOL program.
You keep stating that it won't work, but it did, does and will.
Back to top
View user's profile Send private message
mkssampathkumar
Warnings : 1

New User


Joined: 31 Aug 2006
Posts: 57
Location: chennai

PostPosted: Fri Feb 09, 2007 4:11 pm
Reply with quote

Hi
If u can send me the code????
Back to top
View user's profile Send private message
h.dinesh

New User


Joined: 06 Dec 2006
Posts: 46
Location: Chennai

PostPosted: Fri Feb 09, 2007 6:14 pm
Reply with quote

Hi,

I too tried to read ESDS randomly in Cobol but wasn't able to do. I got an old post which also says that we can read ESDS randomly in CICS

http://ibmmainframes.com/about160.html

I havn't tried in CICS till now... icon_sad.gif

May be it's time to dig up... icon_smile.gif

Dinesh
Back to top
View user's profile Send private message
mkssampathkumar
Warnings : 1

New User


Joined: 31 Aug 2006
Posts: 57
Location: chennai

PostPosted: Mon Feb 12, 2007 9:36 am
Reply with quote

Hi Dinesh
thanks for your post.Am also saying that what u posting.But William is in confident abt the ESDS random read in cobol.
William is keep saying that we can use the ESDS random read in cobol.

I asked him some sample code using ESDS random read in cobol..
Let us wait for his post..


Bye
Back to top
View user's profile Send private message
mkssampathkumar
Warnings : 1

New User


Joined: 31 Aug 2006
Posts: 57
Location: chennai

PostPosted: Thu Feb 15, 2007 11:13 am
Reply with quote

Hi William

Any updating regarding ESDS random read??????????????
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 -> JCL & VSAM

 


Similar Topics
Topic Forum Replies
No new posts Random read in ESDS file by using RBA JCL & VSAM 6
No new posts VSAM ESDS File to store large data 4GB JCL & VSAM 5
No new posts icetool empty file and not empty file... DFSORT/ICETOOL 5
No new posts RPLDDDD field for extended VSAM - ESDS JCL & VSAM 1
No new posts CICS file processing using applicatio... CICS 3
Search our Forums:

Back to Top