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?

Answers were Sorted based on User's Feedback



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

Answer / sj

UNIQUE - Its file level keyword in PF. If you specify this
keyword then duplicate key values are not allowed in PF.
Ex. IF key field is cusno then no duplicate records are
allowed in cusno field

PFILE: Its logical file keyword to specify the Physical
file name.

REF: To specify the file name where the field discriptions
are present.

Is This Answer Correct ?    4 Yes 0 No

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

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

More IBM AS400 AllOther Interview Questions

does cl support arrays

1 Answers  


How can the user implicitly open and close the files in RPG program ?

2 Answers  


what is sflrolval?

0 Answers   IBM,


what are the various types of device files?

1 Answers   IBM,


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

0 Answers   IBM,


what is the difference between sflclr and sflinz?

1 Answers   IBM,


Is it possible to add an keyfield or field to an Physical file without changing its file identifier. Example : - Say I have an existing physical file which is being used in 5 programs. Now I want to add an additional Keyfield or an field to it and I don't want to recompile the programs.

2 Answers  


What is the use of OVRPRTF ?

1 Answers  


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

0 Answers   IBM,


how does union file maintains record formats?

0 Answers   IBM,


What are the different definition levels in Data Description Specifications?

1 Answers  


what are two types of record are used in subfile?

1 Answers   IBM,


Categories