View previous topic :: View next topic
|
Author |
Message |
mkssampathkumar Warnings : 1 New User
Joined: 31 Aug 2006 Posts: 57 Location: chennai
|
|
|
|
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 |
|
|
William Thompson
Global Moderator
Joined: 18 Nov 2006 Posts: 3156 Location: Tucson AZ
|
|
|
|
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 |
|
|
mkssampathkumar Warnings : 1 New User
Joined: 31 Aug 2006 Posts: 57 Location: chennai
|
|
|
|
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 |
|
|
William Thompson
Global Moderator
Joined: 18 Nov 2006 Posts: 3156 Location: Tucson AZ
|
|
|
|
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 |
|
|
mkssampathkumar Warnings : 1 New User
Joined: 31 Aug 2006 Posts: 57 Location: chennai
|
|
|
|
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 |
|
|
William Thompson
Global Moderator
Joined: 18 Nov 2006 Posts: 3156 Location: Tucson AZ
|
|
|
|
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 |
|
|
mkssampathkumar Warnings : 1 New User
Joined: 31 Aug 2006 Posts: 57 Location: chennai
|
|
|
|
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 |
|
|
William Thompson
Global Moderator
Joined: 18 Nov 2006 Posts: 3156 Location: Tucson AZ
|
|
|
|
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 |
|
|
mkssampathkumar Warnings : 1 New User
Joined: 31 Aug 2006 Posts: 57 Location: chennai
|
|
|
|
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 |
|
|
mkssampathkumar Warnings : 1 New User
Joined: 31 Aug 2006 Posts: 57 Location: chennai
|
|
|
|
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 |
|
|
William Thompson
Global Moderator
Joined: 18 Nov 2006 Posts: 3156 Location: Tucson AZ
|
|
|
|
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 |
|
|
mkssampathkumar Warnings : 1 New User
Joined: 31 Aug 2006 Posts: 57 Location: chennai
|
|
|
|
Hi
If u can send me the code???? |
|
Back to top |
|
|
h.dinesh
New User
Joined: 06 Dec 2006 Posts: 46 Location: Chennai
|
|
|
|
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...
May be it's time to dig up...
Dinesh |
|
Back to top |
|
|
mkssampathkumar Warnings : 1 New User
Joined: 31 Aug 2006 Posts: 57 Location: chennai
|
|
|
|
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 |
|
|
mkssampathkumar Warnings : 1 New User
Joined: 31 Aug 2006 Posts: 57 Location: chennai
|
|
|
|
Hi William
Any updating regarding ESDS random read?????????????? |
|
Back to top |
|
|
|