CAN WE INSERT FIELD IN PHYSICAL FILE BY USING OPNQRYF?

Question Posted / suma

4 Answers
13145 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

CAN WE INSERT FIELD IN PHYSICAL FILE BY USING OPNQRYF?..

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

CAN WE INSERT FIELD IN PHYSICAL FILE BY USING OPNQRYF?..

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

CAN WE INSERT FIELD IN PHYSICAL FILE BY USING OPNQRYF?..

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

CAN WE INSERT FIELD IN PHYSICAL FILE BY USING OPNQRYF?..

Answer / rake

we can insert a field using MAPFLD in opnqryf

Is This Answer Correct ?

6 Yes

14 No

Post New Answer

More IBM AS400 AllOther Interview Questions

What is a Library in AS/400?

2 Answers

What does the keyword UNIQUE mean ?

1 Answers

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..

0 Answers BlackRock,

How are the objects stored on AS/400?

1 Answers

What is access path in as400?

0 Answers

How many Printer Files can Declare in a CL Program?

4 Answers

What is the native language of AS/400?

1 Answers

how you will find an error which is not in the first page of the subfile without using rolldown key?

0 Answers IBM,

is it possible to create a join logical file using two join logical files ? give exact reason for your answer