Interested to Buy Any Domain ? << Click Here >> for more details...
how would you design the process for a nightly, high volume check producing process that needs to select only records that are flagged to be processed?
- 1 Answers
- 1586 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / jayvardhan
With the help of OPNQRYF Clp command, we can select the records from the data base file. The process involves following steps:
Steps: 1. OVRDBF with SHARE (*YES)
2. OPNQRYF
3. CALL the program
4. DLTOVR
5. CLOF
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what is a spool file?
what would be the effect on the field where reverse image, underline and highlight display attributes are active ?
how many maximum spaces could be given in o specs?
How can we arrange duplicate records in a file?
how can I give more performance to some selected pages?
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.
what does vldcmdkey means?
why do we use readc? What is sflnxtchg?
difference between sflrcdnbr and sflnxtchg?
how would you design the process for a nightly, high volume check producing process that needs to select only records that are flagged to be processed?
To Add A File To The 'file Selection' Option Of A Query, The Function Key To Be Pressed Is?
What is access path in as400?
How can we change the uppercase to Lowercase in RPG?
what is the difference between seton lr and retrn?
how you will know whether you are in sfldrop or sflfold mode?
