View previous topic :: View next topic |
Author |
Message |
vijay Beginner
Joined: 09 May 2003 Posts: 131 Topics: 64
|
Posted: Fri May 09, 2003 11:03 am Post subject: EZTREVE VSAM PROCESS ? |
|
|
Hi ,
When to use a POINT statement and when to use a START KEY statement
in EZT ?
Vijay |
|
Back to top |
|
|
CaptBill Beginner
Joined: 02 Dec 2002 Posts: 100 Topics: 2 Location: Pasadena, California, USA
|
Posted: Fri May 09, 2003 1:32 pm Post subject: |
|
|
What part of the manuals have you researched? |
|
Back to top |
|
|
kolusu Site Admin
Joined: 26 Nov 2002 Posts: 12369 Topics: 75 Location: San Jose
|
Posted: Fri May 09, 2003 2:13 pm Post subject: |
|
|
Vijay,
The POINT statement enables you to establish the position within an ISAM,VSAM relative record (RRDS), or VSAM indexed (KSDS) file from which subsequent data is sequentially retrieved. Data in the file become available only after the next successful sequential retrieval by either automatic file input or a GET statement.
For ex:
Code: |
FILE EMPLOYEE VS
%EMP
JOB INPUT NULL
POINT EMPLOYEE GE '01963' STATUS
|
Easytrieve does not have the feature START KEY feature. It has been a feature of COBOL. However Easytreive has START parameter identifies a procedure to be executed during the initiation of the JOB.Easytrieve Plus performs the procedure coded in proc-name-1 before it retrieves the first automatic input record. A typical START procedure sets working storage fields to an initial value or positions an indexed or keyed sequentially processed file to a specific record. You cannot reference fields in automatic input files since no records have been retrieved at this stage of processing.
eX:
Code: |
FILE EMPLOYEE
%EMP
CURRENT-DATE W 10 A
CURRENT-MM CURRENT-DATE 02 A
CURRENT-DD CURRENT-DATE +3 02 A
CURRENT-YY CURRENT-DATE +6 04 A
JOB EMPLOYEE START GETDATE
GETDATE. PROC
CURRENT-DATE = SYSDATE-LONG
END-PROC
|
Hope this helps...
cheers
kolusu |
|
Back to top |
|
|
RIA Beginner
Joined: 26 Feb 2004 Posts: 4 Topics: 1
|
Posted: Thu Feb 26, 2004 1:55 pm Post subject: |
|
|
Hi Kolusu,
I am working with 2 files. One is a VSAM file. The VSAM file key is made of 4 fields. The other file has 2 of these 4 fields. So, I sorted that file by those two fields and made them my key for that file.
How do I compare the two files in such a way to match the keys and output all data from the VSAM file for each record in the other file.
I know I have to use POINT statement to get this done....Please help ! _________________ Thanks
RIA |
|
Back to top |
|
|
|
|