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
what is a logical file?
what is sflpag and sflsiz ?
I need to insert a record in a file using STRSQL containing the some field values same as an already existing record in that file.I know to smple insert mentioning those values one by one.But is there any another query can be prepared for the same .Please share the query if known to you. Thanks in advance.
what is the maximum number of subroutines allowed in rpg?
define the purpose of the *cat function?
which are the string manipulation opcodes?
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.
What is the as400 called now?
WHAT is STORED PROCEDURE CONCEPT IN AS400 WITH EXAMPLE?
Why we are not able to perform insert delete and update operation in Join logical file?
how do you use exceptional write in c specs?
what is elastic and non elastic subrile?
what is the maximum number of fields under a record format of physical file?
what is a keyed physical file?
how to write code for singlepage in sqlrpgle with update ?