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 service program?

816


what is full form for dds?

991


What is the difference between iter and do? We know both are used to execute set of statements repeatedly, but what is the main difference?

802


where can you specify an indicator in lokup operation?

1516


how do you use exceptional write in c specs?

1551


why is the declare cursor statement is used for?

844


what are all the contents of subfile?

1329


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

1489


what the purpose of ovrdta, ovrata keywords?

1602


which are the relational operators in rpg?

918


how to develop some simple graphs (bar charts) using just html?

877


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

1409


what is message file?

839


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

1363


how do you know that records are locked?

1597