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

an access path may be in which sequence?

899


which of the following operations does not zero the field flda defined as 4,0?

941


what does the ovrdbf command do?

862


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

1055


What is file access opcodes?

1039


define subsystem?

1307


In AS/400 projects in Companies whats the meaning of production support team.what production support involves.also what work does development,maintenance involve what are the other teams or processes that are available for as400 project.

8803


define a output queue?

1179


How we will get issues on AS/400 technology ? I mean which issue/Defect Tracking tool is using in all companies when any issue comes? Can anybody explain about the work flow of AS/400 project ? plzzz

1382


can a join logical file be updated?

783


what is the purpose of putovr (put with explicit override) keyword?

1272


how to write *pssr ?

842


can error messages as a result of a comp, range or values keyword be overridden?

1481


what is the difference between sflclr and sflinz?

1373


when is a tag statement used in rpg?

1817