| 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 |
|
|
|
|
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
