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

Why we have multiple data types in As400 and why we use numeric, packed, decimal, zoned the basic difference between this?

836


how may a cgi control duplicate inputs?

775


Hello, I have created a CMD type object. In one of the fields in Display file , I would like to see All the Source files present by pass the name of Library. Tried using CHoice(Keyword) and Choicepgm on PARM , but doesn't seems to be working. Any help please..

1970


how can a message from a message file appear as a constant on the screen?

1205


what is the use of jdftval in join logical file?

1398






what is the function of rlu ?

1267


the maximum number of subfiles that can be active for a single file is ____ .

1438


in which specification the report layout can be defined?

1252


How can we change the uppercase to Lowercase in RPG?

1092


what is a composite key?

1282


how can I control from my cgis the cache of a remote browser?

870


In AS/400 projects in Companies whats the meaning of production support team.what production support involves.also what work does development,maintenance involve what are the other teams or processes that are available for as400 project.

8764


How do you check object lock

528


How to reverse the string in rpg

1436


what is full form for dds?

943