Q:
OVRDBF
In a single CL/400 program, is it possible to declare physical file File1, then read a record and later writing the record value onto the DSPF using OVRDBF with in a same CLP?
Software/Hardware used:
Iseries
Software/Hardware used:
Iseries
ASKED:
Sep 14 2009 6:01 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
A:
RATE THIS ANSWER
0
Click to Vote:
0
Click to Vote:
- 0
0
You use two DCLF statements and RCVF for the PF and SNDF for the DSPF
*************************************************************************
CL supports up to 5 files. Use OPNID to reference additional files.
///////
It'll work if you are on V5R4M0 or above.
Wilson
Sorry, mi mistake. More than one file in CL is allowed from V5R3 and above.
Wilson
*************************************************************************
The recent allowance of up to five DCLFs in a single CL program has made this fairly easy. However, there are various ways of accomplishing a similar result even in VRMs going back to V2R3. For example, the QLGSORT API can be used to retrieve record strings into CL variables, and a DSPF can then be the target of the single DCLF. Or the database file can be on the DCLF, and the DSPF can be replaced by a *PNLGRP -- use UIM APIs to write the output. Or, in ILE CL, use DSM APIs to avoid both DSPF and *PNLGRP requirements.
Tom
