Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / guest513
OPNQRYF has multiple usages
- for dynamic selection of records, no overhead as per the
access paths.
- if needed we can create the copy of the above selected
records using CPYFRMQRYF
- to share the data path for the dynamic selected records,
so that the overhead in accessing the above records will be
simple.
| Is This Answer Correct ? | 15 Yes | 0 No |
Post New Answer View All Answers
what is *iso date format?
what are the three types of keywords associated with printer file ?
What are the different opcodes used for file operation on a subfile in a rpg pgm?
can anybody give the interview questions list of RLU. plz mail me: dinesh_sati07@yahoo.com
define data structure?
Explain The Keywords Edtcde & Edtwrd?
How Many Specs Are There In Rpg & Which Are They?
what opcode could be used to test an alphanumeric field for all numeric values?
In 'o' Specs What Is The Opcode For Write?
what is the use of data structures?
how do u compile rpgle program?
What is %CHECK?
which indicator is used for read?
WHICH REPLY CODE IS USED BT sftp ? ... (e.g.226 is used by FTP IF FILE IS TRANSFERED)
I have created a command that display Source file and library. Now i want that when i enter library name and press f4 on Source file, pgm should display all the PF- SRC's in that Library. For F4 option i have used Choice program but since only limited paramters are passed in Choice pgm i am not able to paas library name and further can't call a pgm that will display list of Source files. Below is the Code snippet for CMD type object :- CMD PROMPT('Source Scan for HUB Standard') PARM KWD(SOURCE) TYPE(*CHAR) LEN(1) RSTD(*YES) + VALUES(N A) MIN(1) + CHOICE('N,A') PARM KWD(SRCFILE) TYPE(FILE) RSTD(*NO) + PROMPT('SOURCE FILE') FILE: QUAL TYPE(*NAME) LEN(10) RSTD(*NO) EXPR (*YES) + CHOICE(*PGM) + CHOICEPGM (XXXXXLIB/YYYPGM) QUAL TYPE(*NAME) LEN(10) DFT(*LIBL) + SPCVAL((*LIBL)) EXPR(*YES) PROMPT ('Library') Below is the Choice pgm:- PGM PARM(&PARM1 &PARM2) DCL VAR(&PARM1) TYPE(*CHAR) LEN (21) DCL VAR(&PARM2) TYPE(*CHAR) LEN (2000) IF COND(%SST(&PARM1 1 10) = 'CHOICE ' *AND + %SST(&PARM1 11 10) = 'SRCFILE ' *AND + (%SST(&PARM1 21 1) = 'C' *OR %SST (&PARM1 + 21 1) = 'P')) THEN (DO) /* (%SST(&PARM1 21 1) = 'C' *OR %SST (&PARM1 + */ CHGVAR VAR(&PARM2) VALUE('Name, F4 for List') ENDDO IF COND(%SST(&PARM1 1 10) = 'CHOICE ' *AND + %SST(&PARM1 11 10) = 'SRCFILE ' *AND + %SST(&PARM1 21 1) = 'P') THEN (DO) CHGVAR VAR(&PARM2) VALUE('Name, F4 for List') CALL PGM(GTSQL) PARM ('XXXXLIB') return ENDDO Thanks in Advance for looking into.
