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

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

what is *inzsr used for?

1460


What are the mandatory keywords of sub file?

738


What is the difference between crtdupobj and copyf?

667


what is the use of sflend keyword?

971


what are necessary keywords to code message subfile?

1004






explain the difference between defining subfile and message-subfile?

1094


what does vldcmdkey means?

808


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

1456


What is the Difference between command attention key and command function key ?

767


What Does 'sr' In Columns 7-8 Of C Specs Mean?

1055


what does check opcode do ?

1055


what are the different methods to access seu?

619


what are the different types of arrays available in rpg ?

954


how to pick up the changed records every time in a subfile after the first change made ?

998


what is a composite key?

998