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
- 6964 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 many PARM statement can we use in a CL program?
any one have give AS400 study material? pls pass it to gopalsai789@gmail.com
which cl command is used to trap error messages during program execution?
What is difference between fully procedural file and primary file?
What is the difference between production library and test library ?
PGM QSH CMD('/QOpenSys/bin/sftp -b/home/test/myfile.txt serverUserID@server') ENDPGM Can u plz tell me what the above code do exactly?
describe the difference between the dowxx and douxx operations?
What Is The Purpose Of The "n" In The Following Calculation Specification?
What are the valid user defined data area types?
what is elastic and non elastic subrile?
What is the symbol used for copying & moving new field in SDA?
can u plz tell me is there any difference between SHELL SCRIPT & SFTP SCRIPT? I want to run LS & GET(automatically) command from CL program....which script can be used?
RPG400 
