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?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

In 'o' Specs What Is The Opcode For Write?

1128


which are control break logic indicators?

1050


How to add 99 menu (page down) option in menu creation..

2321


what is cab?

1117


To Add A File To The 'file Selection' Option Of A Query, The Function Key To Be Pressed Is?

1183


how to pick up the changed records every time in a subfile after the first change made ?

1749


Write a CL program which will run a batch job at 1 am every night

1065


what is term cua , saa?

1548


Can you summarize the steps I have to go through in writing my first cgi?

1078


Why we are not able to perform insert delete and update operation in Join logical file?

1426


is it there an easy way to determine if an html section is available to issue a wrtsection upon?

932


How Many Specs Are There In Rpg & Which Are They?

1070


what is scan and xlate?

1754


what are the uses of factor1, factor2 and result field for the rpg operation code parm?

992


how can you check for a records existence without causing and i/o (chain/read)?

2012