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

maximum number of subfiles that can be active for a single file is?

1 Answers   IBM,


Define the purpose of the following code (If you know, how would this be written in RPG ILE) HI LO EQ C *IN66 DOUEQ *OFF C KEY1 CHAIN FILEA 90 66 C 66 CALL PGM1 PRM C ENDDO

1 Answers  


What are the valid user defined data area types?

1 Answers  


it is possible declare variable values as variable using cl ? any cl command is there to declare values as variable

2 Answers  


how do you know that records are locked?

1 Answers   IBM,


what are two types of record are used in subfile?

1 Answers   IBM,


What is the difference between non-join logical files and join logical files?

0 Answers  


What is Data Area?

1 Answers  


Service Program : S1 Modules in S1 : M1 M1 having two procedures : ADD, SUB Current Binder Language STRPGMEXP PGMLVL(*CURRENT) EXPORT SYMBOL("ADD") EXPORT SYMBOL("SUB") ENDPGMEXP Doubt: I need to add one new Module to the Service Program M2 having one procedure ‘MULT’ How to add this new module to the service program S1 ? If I need to recreate the service program again, Do I need to mention the Module M1 again while recreating along with new Module M2? There is no Binding Directory. Binder language structure will be like this STRPGMEXP PGMLVL(*CURRENT) EXPORT SYMBOL("ADD") EXPORT SYMBOL("SUB") EXPORT SYMBOL("MULT") ENDPGMEXP STRPGMEXP PGMLVL(*PREVIOUS) EXPORT SYMBOL("ADD") EXPORT SYMBOL("SUB") ENDPGMEXP

0 Answers  


what is the use of sflend keyword?

1 Answers   IBM,


how can you specify no duplicate key?

0 Answers   IBM,


how can we view the entire objects and its types in a pgm?

7 Answers   Mind Tree,


Categories