what is the use of UNIQUEUE KEY WORD?
what is the difference between PFILE AND REF?
Answers were Sorted based on User's Feedback
Answer / sj
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 |
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 |
what is the difference between sflclr and sflinz?
What is the purpose of FRCDTA (Force Data) keyword?
What is SDA used for?
Please give me the code for A=A+1 in cl program?
hi guys i am new for sqlrpgle, please suggest me good websites and theory and coding. plz plz its very urgent.
How to see active jobs of the system.
how to find whether a date format is valid or not in RPG400 not in RPGILE.Can you please write the coding for this sir,i'm new to AS400.Please help.
How to convert a spool file to PDF file in AS400?
what is sflinz and sflrna?
What is the necessary keyword used in a physical file to refer field definitions from the field reference file?
What are the types of Signature validation?
whare we can use IN AND OUT AND UNLCK opcodes?please can any body tell me in real time senario with example