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

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

Question Posted / gv.change

2 Answers
7067 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

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

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

why we sometimes use same file name in FILE and TOFILE in OVRDBF and sometimes different??please tell

3 Answers

what are the parameters required for calling ls & get command(SFTP COMMANDS) from cl progtram.... I want to transfer files(using GET COMMAND) that are retrieved by LS command ...FROM 1 SYSTEM TO ANOTHER... STEP 1:LS-list all files...from remote system STEP 2:GET-actually transfer the files(listed in step 1) from remote system to local system & get stored in some Physical file....Plz reply in detail...Thanx

1 Answers EDS,

What is the maximum number of elements in an array?

1 Answers

using dfu, user will be able to ___________ from physical file?

0 Answers IBM,

Want to know related Interview questions and answers for seniors

1 Answers

how can I give more performance to some selected pages?

0 Answers IBM,

How to change file attributes such as size, file wait time, record wait time etc., permanently?

1 Answers

How are the objects stored on AS/400?