what is the use of UNIQUEUE KEY WORD?
what is the difference between PFILE AND REF?
- 2 Answers
- 5783 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
define what a data area is along with a brief example of what it may be used for?
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 subfiles that can be specified in a display file?
which indicator is used for read?
what is the difference between normal upddta to pf and updating using dfu program?
what are the three line types in rlu ?
how would you design the process for a nightly, high volume check producing process that needs to select only records that are flagged to be processed?
how does the runqry show the output?
What Is Ddm ?
can a indexed file be accessed in arrival sequence in rpg program?
What is file information data structure(infds) in as400?
how you get the relative record in a subfile in which cursor is located?
how can I automatically refresh a web page?
what is the purpose of indicators in rpg?
What is the as400 called now?
