Interested to Buy Any Domain ? << Click Here >> for more details...
Can we use OVRDBF command without using of OPNQRYF ?
Or can we use OPNQRYF command without using of OVRDBF
command ?
- 4 Answers
- 33525 Views
- HCL, iGate, I also Faced
- E-Mail Answers
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
i am using non join multiple format my 3 database file is like that pf97 R REC ENAME ETENNO ESTATUS K ENAME pf98 R REC1 ENAME ESAL K ENAME PF99 R REC3 ENAME CRDCARD EID K EID & MY NON JOIN LOGICAL FILE IS ALSO SAME EXCEPT RECORD NAMES BEFORE I TRIED WITH 2 FILES SO ITS SAYS ERROR I.E.(Key field attributes must be same as for previous formats. ) SO I CHANGED KEYFIELD ACCORDING TO PF SO ITS WORKING BUT AFTER ADDING 3 FILES ITS SAYING SAME ERROR . I DONT KNOW I NEW IN AS400 PLLZ HELP ME I HAVE ONE MORE QUE. CANT BE USE DIFFERENT KEYFIELD (NOT ACCORDING TO PF) IN NON JOIN LOGICAL FILE.
what are various techniques to pass parameters from one program to another?
how can I control the way a remote browser uses its cache?
what is the use of jdftval in join logical file?
what are the different methods to access seu?
what are the different types of variables available in cl?
what is message file?
what are the three line types in rlu ?
how do you read changed records backward in subfile?
I need to insert a record in a file using STRSQL containing the some field values same as an already existing record in that file.I know to smple insert mentioning those values one by one.But is there any another query can be prepared for the same .Please share the query if known to you. Thanks in advance.
A join logical file has how many record formats?
What is the maximum number of subfiles that can be specified in a display file?
what is join logical file?
is it possible to create a physical file without dds?
can error messages as a result of a comp, range or values keyword be overridden?
