Interested to Buy Any Domain ? << Click Here >> for more details...
CAN WE INSERT FIELD IN PHYSICAL FILE BY USING OPNQRYF?
- 4 Answers
- 12955 Views
- I also Faced
- E-Mail Answers
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 |
how do you use commitment control in rpg program ?
List the steps/commands necessary to accomplish the following: a. Copy data from the file ORDHDR into file ORDHIST b. The file ORDHIST may or may not exist c. If the file ORDHDR does exist, it may or may not contain data d. The file ORDHIST may or may not contain data, if the file does contain data the old data should be erased
all i need to know about cmpseqdat parameter in cmppfm, how it works and can we retrieve line sequence and date from the output?
What are the steps to retrieve the records from Journal file...?
what is the difference between clear and reset opcodes and open and close opcodes?please tell me in real time senario with example please? And What is the use of SFLNXTCHG?Where we can use this?
In there is 100 no. of recordsin PF, if i delete all the records. Then what is the Size of the PF?
what is the use of dspatr(mdt) keyword?
What is the use of OVRDBF ?
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..?
what is overlay?
what is data structure?how many types of data structers?
Hi friends i have i question please reply me asap. what would be coding in DDS and programing part for this condition suppose that i have three fields in the display file(subfile)which has 7 record format. Condition is ''The supplier LOT, ISSUED TO PROD and LINE GRP fields in display file(Subfile) will not be shown if their respective fields are blank/zero in the record formats WIM311FM and Record format WIM311FM. I want coding part in DDS and Programing. Please reply me as soon as posible.
RPG400 
