|
anybody know if there is a template file that i5 uses to create the outfile of the following command?>DSPFD FILE(MYFILE) TYPE(*MBRLIST) OUTPUT(*OUTFILE) OUTFILE(MY/TEST)
I wrote a quick little CL program called "FINDTMPL" to find these for me (I can never remember them!) To use my program, I do this:
DSPFD FILE(MYFILE) TYPE(*MBRLIST) OUTPUT(*OUTFILE) OUTFILE(QTEMP/FOO) CALL FINDTMPL PARM('FOO' 'QTEMP')It will return the results as a completion message. In this case, QWHFDML.
Here's the code for the FINDTMPL program (it's not fancy, or particularly clever, but it works):
PGM PARM(&FILE &LIB) DCL VAR(&FILE) TYPE(*CHAR) LEN(10) DCL VAR(&LIB) TYPE(*CHAR) LEN(10) DCL VAR(&RCDFMT) TYPE(*CHAR) LEN(10) DCL VAR(&EOF) TYPE(*LGL) VALUE('0') DCLF FILE(QAFDRFMT) DLTF FILE(QTEMP/XXFINDTMPL) MONMSG MSGID(CPF2105) /* PUT THE REQUESTED FILE'S RECORD FORMAT INTO THE WORK FILE */ DSPFD FILE(&LIB/&FILE) + TYPE(*RCDFMT) + OUTPUT(*OUTFILE) + OUTFILE(QTEMP/XXFINDTMPL) /* PUT ALL OF THE RECORD FORMATS OF ALL FILES IN QSYS INTO + THE WORK FILE. */ DSPFD FILE(QSYS/*ALL) + TYPE(*RCDFMT) + OUTPUT(*OUTFILE) + FILEATR(*PF) + OUTFILE(QTEMP/XXFINDTMPL) + OUTMBR(*FIRST *ADD) OVRDBF FILE(QAFDRFMT) TOFILE(QTEMP/XXFINDTMPL) /* READ THE REQUESTED FILE'S RECORD FORMAT NAME */ RCVF CHGVAR VAR(&RCDFMT) VALUE(&RFNAME) /* LOOK FOR A FILE IN QSYS WITH THE SAME RECORD FORMAT */ LOOP: RCVF MONMSG MSGID(CPF0864) EXEC(CHGVAR &EOF '1') IF (&EOF *EQ '0') DO IF (&RFNAME *EQ &RCDFMT) DO SNDPGMMSG MSGID(CPF9897) + MSGF(QCPFMSG) + MSGDTA(&RFNAME) + MSGTYPE(*COMP) ENDDO GOTO LOOP ENDDO /* THAT'S ALL, FOLKS! */ DLTOVR FILE(QAFDRFMT) DLTF FILE(QTEMP/XXFINDTMPL) MONMSG MSGID(CPF2105) ENDPGM
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.