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

Difference between NOPASS & OMIT?

1844


. How to know why the OPM job is in MSGWAIT state?..WHAT COULD BE THE REASON FOR it?

7942


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

970


How to avoid using indicators in ile ?

1266


how many printer files can be defined in f specs ?

1624


what is the purpose of data structure?

1734


distinguish between terminating a program through seton lr and return?

1091


Difference Between Call & Sbmjob?

1279


how to define to define a hidden filed in dspf ?

1331


any one have give AS400 study material? pls pass it to gopalsai789@gmail.com

1706


what does opcode post do ?

1756


what if my system I runs with system value qccsid 65535?

1036


what is the purpose of dynslt keyword?

1747


What is the default access path of a file?

1103


how can you detect and handle a record lock situation?

1976