what is the use of UNIQUEUE KEY WORD?
what is the difference between PFILE AND REF?
- 2 Answers
- 6296 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 |
How to reverse a string using RPG?
I am a fresher. I got project on AS 400. Can any body suggest the best book for learning of it.
Can we use OVRDBF command without using of OPNQRYF ? Or can we use OPNQRYF command without using of OVRDBF command ?
What is SFLSIZ ?
what are the various types of device files?
What is file access opcodes?
What is a message file?
What is %CHECK?
Hi Friends, I need immediately answer for this: Senario is that,I am selecting records from the display and window subfile on the basis of Reason Code and some more fields but spool file not showing the same records which i have selected by display and window subfile. Q.What could be the causes(resons)to not show records properly (just selected in the display file and Window subfile)according the selection criteria of the records. Q.What would be the solutions to show records properly in the spool file just as selected in in the display file and window subfile according to the selection criteria.
what is code for reading member in rpgle when wehave like extmbr(*all) so we have 3 members in *all then i want to read first record in 2member
what are the different methods to access seu?
How do you grant authority?
RPG400 
