How can u create a temporary file in CLP @ how to access
that temporary file in RPG program?

Answer Posted / svankipu

Use OVRDBF Command with SHARE(*YES) to share the ODP of this
file to othr pgms.

create temporary file using Open Query file command(OPNQRYF)

and use "Allow copy of data" (ALWCPYDTA) attribute to copy
the selected data into this file.

Now call the RPG pgm to use this file.
Thanks!

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is overlay?

681


distinguish between terminating a program through seton lr and return?

565


which of the following operations does not zero the field flda defined as 4,0?

705


how do you specify page overflow indicator for printer files in rpg?

1467


how can you check for a records existence without causing and i/o (chain/read)?

1294






how you will know whether you are in sfldrop or sflfold mode?

631


what is the purpose of overrides?

1022


Difference Between Call & Sbmjob?

775


explain the purpose of keep and assume keywords?

1065


all i need to know about cmpseqdat parameter in cmppfm, how it works and can we retrieve line sequence and date from the output?

2415


What are the different opcodes used for file operation on a subfile in a rpg pgm?

1095


What is the Difference between command attention key and command function key ?

788


What are the record format field mapping options in cpyf?

613


what are different types of substems?

1341


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.

3037