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

what is the use of UNIQUEUE KEY WORD?
what is the difference between PFILE AND REF?

Answer Posted / vp86

unique keyword is file level keyword you can use physical file as well as logical file also if you use the unique keyword then you prevent the duplicate value in particular filed and one more necessary condition file should be keyd.

pfile : That keyword is logical file keyword its record level keyword through we can create the logical file .

syntax for that keyword : pfile(physical file name).

ref: this keyword is file level keyword we can use only taking the field attribute reference .
syntax for that keyword :ref(lib/file/rcdname)

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how do you read changed records backward in subfile?

1144


What is %CHECK?

1329


when do you use f-spec. Continuation line ?

1801


what is the clp command to access a query/400?

2231


WHAT is STORED PROCEDURE CONCEPT IN AS400 WITH EXAMPLE?

2575


Difference between NOPASS & OMIT?

1935


difference between view and index ?

1198


how to get the cursor position?

1191


how do u compile rpgle program?

1171


what is the maximum number of records you can specify in a display file?

1947


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

1883


what is match field indicator?

1820


if we tried to move year part of *iso date into a field of length 3, what will happen ?

1372


what is a program described file in rpg?

1815


which are the query selection criteria, which can be given in a query?

1216