425 pts.
 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
ASKED: September 14, 2009  6:01 AM
UPDATED: September 16, 2009  11:08 PM

Answer Wiki:
You do not need the OVRDBF. 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
Last Wiki Answer Submitted:  September 16, 2009  11:08 pm  by  WilsonAlano   2,385 pts.
All Answer Wiki Contributors:  WilsonAlano   2,385 pts. , graybeard52   3,115 pts. , CharlieBrowne   32,945 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _