Interested to Buy Any Domain ? << Click Here >> for more details...
what is the use of UNIQUEUE KEY WORD?
what is the difference between PFILE AND REF?
- 2 Answers
- 6814 Views
- I also Faced
- E-Mail Answers
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 purpose of FRCDTA (Force Data) keyword?
How many types of jobs?what is difference between interactive and batch and submited jobs?
how to write code for singlepage in sqlrpgle with update ?
if &var='good++++' &var2='day' &var *cat &var2 &var1 *tcat &var2 what is output
What is the difference between Array and Table?
what do we can do with the embedded sql statements?
Pgm A is invoked through HTTP. It is in Activtion group QILE. Pgm A calls Pgm B and Pgm C. Pgm B is in activation group TEMPACTGRP. Pgm A ends in error. Pgm A is called again. But it gives an error that TEMPACTGRP still exists and files are present in QTEMP. What is the cause and how will u fix?
How to inner join more than 2 PFs in a CL program using OPNQRYF command?
What is the use of SDA ?
What is source physical file?
which of the cl command can be used to determine which logical files are dependent on a specific file?
how can you check for a records existence without causing and i/o (chain/read)?
RPG400 
