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

at what level s,o are defined and what they will do?

1339


writing an sql statement from selecting records from two files using single statement and nested select statement.

925


what are the different types of arrays available in rpg ?

1274


How to debug a batch job when it is in messagewait(mswg) status. I know the steps for batch ebugging, but im confusing with when we submit any job for batch debug we put in held state. So here also do same thing or any other way?

941


what are members?

822


what is *iso date format?

831


when do you use f-spec. Continuation line ?

1313


how many maximum spaces could be given in o specs?

826


any one have give AS400 study material? pls pass it to gopalsai789@gmail.com

1456


what keyword must be used with protect keyword ?

1442


what is the maximum number of fields under a record format of physical file?

1350


If i change any file through application after entering data , how to check which file is updated through applications . For call stack we takes esc 3 then we chose 11..But What is answer of below qtn..?

1686


How to reverse a string using RPG?

1128


Can level check error occur if we do chgpf?

1013


how to write code for singlepage in sqlrpgle with update ?

2595