CAN WE INSERT FIELD IN PHYSICAL FILE BY USING OPNQRYF?
Answers were Sorted based on User's Feedback
Answer / manish kumar
MAPFLD is used to change the format of the fields used in
the OPNQRYF statement. When I say changing the format the
format of the field will not be changed but we can format
the data as we wish and store it in a diffrent variable.
For eg. You want check for year to be some value and are not
concerned abt date and month then you can follow as below.
OVRDBF FILE(FILEA) SHARE(*YES)
OPNQRYF FILE(FILEA) QRYSLT('YEAR *EQ "88" ') +
MAPFLD(YEAR '%SST(DATE 5 2)' *CHAR 2)
CALL PGM(PGMC)
CLOF OPNID(FILEA)
DLTOVR FILE(FILEA
| Is This Answer Correct ? | 9 Yes | 0 No |
Answer / sumit gupta
Hi Suma..your question is wrong...OPNQRYF is used to select
some records from a physical file which is overide or
simple 1 file(without OVRDBF).
We cannot insert field into physical file throgh OPNQRYF.
But yes you can change the format of field as SAID BY
MANISH and then bys using CPYFRMQRYF...you can write the
selected record into physical file.
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / venkat
it is not possible to insert a field using openquery file
because of there is no parameter to insert the field at
opnqryf
| Is This Answer Correct ? | 3 Yes | 0 No |
Q. 1.What are the in build functions in CL program and what are uses of thes in build functions? 2.How we can create own command in CL program? 3.What is use of STRSRVJOB?
can a join logical file be updated?
Define what the operation will do, the purpose of the result field and the purpose of *IN66? HI LO EQ C CALL 'CVTDAT' DTPRM 66
What are the functions of Remote Job Entry (RJE) ?
how may a cgi control duplicate inputs?
when you are defining a flat file in your program in f specs which format will you specify?
how many printer files can be defined in f specs ?
how many types of display are available on as/400 for user interaction?
How to create a user defined (general) data area?
When does the DFT keyword in PF be used?
Apart from opening of a file do we have any other use of USROPN?
what is a program described file in rpg?