Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


CAN WE INSERT FIELD IN PHYSICAL FILE BY USING OPNQRYF?

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 Spool file, Why is it required?

1 Answers  


How to debug a batch job when it is in messagewait(mswg) status. I know the steps for batch ebugging, but im confusing with when we submit any job for batch debug we put in held state. So here also do same thing or any other way?

0 Answers  


define a output queue?

1 Answers   IBM,


Can anybody know what is Pick/Basic? Is it a programming language? can it be used in AS400 machine?

2 Answers  


What is left outer join?

2 Answers  


can anybody give the interview questions list of RLU. plz mail me: dinesh_sati07@yahoo.com

0 Answers   HCL,


How many secondary files allowed in a program?

1 Answers  


Is LDA can be access accross the Job?

9 Answers  


define the purpose/use for sflrna?

1 Answers   IBM,


Explain The Keywords Edtcde & Edtwrd?

0 Answers   IBM,


What are the types of data structure in as400?

0 Answers  


Hi All, Can any one give me a suggestion for below prob One job is in MSGW due to decimal dara error and I find out stmt error and Value in DMUP. but my file has millions of records.So how can i find out on which record the error was occured....?

3 Answers  


Categories