Can we use OVRDBF command without using of OPNQRYF ?
Or can we use OPNQRYF command without using of OVRDBF
command ?

Answer Posted / geo

OPNQRYF FILE((FILENAME))

CPYFRMQRYF FROMOPNID(FILENAME) TOFILE(QTEMP/TEMP) CRTFILE
(*YES)
This will copy the records selected from Open qry file and
put it in to the Temp file in Qtem that is newly created.
One can use the file i.e. QTEMP/TEMP with the records
selectes

Is This Answer Correct ?    1 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

The content of Physical file is as below: hfcftp wruquief SENDPASV 0 CDUP ASCII GET 01100901.CSV ramndk/ECP505.EC0110090 (REPLACE QUIT Thw above commands will get executed when we call STRTCPFTP from CL program.... Now if I want to use SFTP what can be the solution? plz reply in detail....Thank you for ny help... I m using RPG/ILERPG to download...

1917


in which specification the report layout can be defined?

982


describe the difference between the dowxx and douxx operations?

1176


To Add A File To The 'file Selection' Option Of A Query, The Function Key To Be Pressed Is?

795


which are the relational operators in rpg?

677






how can I automatically refresh a web page?

634


what is full form for dds?

745


How we will get issues on AS/400 technology ? I mean which issue/Defect Tracking tool is using in all companies when any issue comes? Can anybody explain about the work flow of AS/400 project ? plzzz

1157


which indicator is used for read?

629


Explain this error: "all record formats for externally-described file abcd ignored or dropped due to error; file ignored."?

756


define the purpose of the *cat function?

984


what is the purpose of dynslt keyword?

1038


Apart from opening of a file do we have any other use of USROPN?

959


how do you use commitment control in rpg program ?

1282


a multiple format logical file is also known as?

597