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

what is the version of os/400 that we have?

1 Answers   IBM,


what is the command used to invoke rlu ?

1 Answers   IBM,


how many printer files can be defined in f specs ?

1 Answers   IBM,


what are the different types of keys in AS400

2 Answers   HSBC,


is it possible to create a physical file without dds?

1 Answers   IBM,






What are the different ways to input data into data area?

1 Answers  


how to change job priority when it is running in sub system ?

11 Answers   IBM,


what is the difference between udate and the system date?

1 Answers   IBM,


how do handle file exception/error?

0 Answers   IBM,


what are different types of substems?

1 Answers   IBM,


how do you specify page overflow indicator for printer files in rpg?

1 Answers   IBM,


what is the main use of OPNQRYF ?? in that query why we can use OVERDBF and in that OVERDBY why should we use SHARE(*YES)

2 Answers   IBM,


Categories