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

how can I predict the performance of my cgis?

0 Answers   IBM,


how can a procedure will be added in to a srvpgm

4 Answers   TCS,


maximum number of subfiles that can defined in a rpg program for one display file is?

1 Answers   IBM,


I/o error detected,Record Out of sequence,Permanent I/o error occured....I mean give one eg for these errors...i understand only,update/delete operation without prior read oprn..give details of remaining

1 Answers   CTS,


which type of object is used in db2/400?

0 Answers   IBM,


what keyword must be used with protect keyword ?

1 Answers   IBM,


what is full form for dds?

0 Answers   IBM,


Is qgpl a user library or system library?

1 Answers  


if &var='good++++' &var2='day' &var *cat &var2 &var1 *tcat &var2 what is output

2 Answers  


Space & Skip Are Which Level Keywords?

0 Answers   IBM,


in which specification the report layout can be defined?

1 Answers   IBM,


what is the maximum number of parameters allowed in clp?

2 Answers   IBM,


Categories