Interested to Buy Any Domain ? << Click Here >> for more details...
Suppose you have 3 members in a database file. How to read
records from all the members
Without using CL (OVRDBF) i.e. it should be handled
exclusively in an RPG program?
- 6 Answers
- 16255 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / syam
Create diff. 3 RUNQRY with 3 members and save it. Run this
QRY inside the RPG Program thru using EXEC CL Cammand.
| Is This Answer Correct ? | 4 Yes | 11 No |
Post New Answer View All Answers
how many printer files can be defined in f specs ?
when should I use method get, and when should I use method post in my cgis?
How to add 99 menu (page down) option in menu creation..
some special characters I key in my html source members show different on my web pages. Why? How can I solve this?
what is the function of cpysplf command?
Difference Between Source Physical File & Physical File?
how does the runqry show the output?
how to define to define a hidden filed in dspf ?
how may a cgi control duplicate inputs?
which are the relational operators in rpg?
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.
at what level s,o are defined and what they will do?
name few ibm supplied libraries?
define the purpose of the *cat function?
what are the two record formats a subfile contain ?
