Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
How to use AIX in ESDS to faster the processing

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
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    Post subject: How to use AIX in ESDS to faster the processing
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: 3158
Location: Tucson AZ

PostPosted: Wed Feb 07, 2007 2:52 pm    Post subject: Re: How to use AIX in ESDS
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    Post subject: Re: How to use AIX in ESDS
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: 3158
Location: Tucson AZ

PostPosted: Wed Feb 07, 2007 3:24 pm    Post subject:
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    Post subject:
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: 3158
Location: Tucson AZ

PostPosted: Wed Feb 07, 2007 3:43 pm    Post subject:
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    Post subject:
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: 3158
Location: Tucson AZ

PostPosted: Wed Feb 07, 2007 4:49 pm    Post subject:
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    Post subject: Re: How to use AIX in ESDS to faster the processing
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    Post subject:
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: 3158
Location: Tucson AZ

PostPosted: Fri Feb 09, 2007 2:39 pm    Post subject:
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    Post subject:
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    Post subject:
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    Post subject:
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    Post subject: Re: How to use AIX in ESDS to faster the processing
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    IBMMAINFRAMES.com Support Forums -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts processing a XML file in PL/1 grvtomar PL/I & Assembler 2 Fri Jun 09, 2017 1:07 pm
No new posts Issue with NDM process to transmit ES... chetanambi All Other Mainframe Topics 6 Wed May 03, 2017 10:52 am
No new posts File processing vishwakotin Mainframe Interview Questions 14 Fri Apr 28, 2017 11:38 am
No new posts Asynchronous CICS Processing Question moezbud CICS 1 Mon Mar 06, 2017 6:13 pm
No new posts CICS Question RE: Browse, Readnext an... moezbud CICS 7 Sun Mar 05, 2017 5:45 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us