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
- 7074 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 does check opcode is used?
how to convert date format from one format to another i think in CL/400 its CVTDAT,Please tell in RPG/400 sir not in RPGILE
what are the necessary keywords for the join logical file?
what are the basic features of seu?
what is logical file?
Q.Hi All friends, I have one Question, I have three fields in display file SUP LOT, ISSUED to Prod and Line Grp. Field SUP LOT is mentioned in one field reference file WRSLT and key field as a key field LP.Fields ISSUED to PROD,Line GRP are mentioned in the another Field reference file WMDTF. So I want to read SUP LOT on the basis of key field LP from the first file WFSLTand then i want ot read another two fields ISSUED to DATE and LINE GRP from second file on the basis of SUP LOT, which i got from first file.Now i want to display these fields in the display file DSPWMMS. but Condition is that 'Supplier Lot,ISSUED to Prod and Line Grp will not be shown if their respective fields are blanks/Zero. Please Let me Know coding part of this senerio and what would be coding for display file to now shown fields if fields are blanks/zero. My mob. no. is 9836300345. Please reply me asap.
what does vldcmdkey means?
Q1. How to use signature in service program and ILE.? Q2.what is use of signature and binder language and what is the relation between them?
Hi friends i have i question please reply me asap. what would be coding in DDS and programing part for this condition suppose that i have three fields in the display file(subfile)which has 7 record format. Condition is ''The supplier LOT, ISSUED TO PROD and LINE GRP fields in display file(Subfile) will not be shown if their respective fields are blank/zero in the record formats WIM311FM and Record format WIM311FM. I want coding part in DDS and Programing. Please reply me as soon as posible.
what is the use of UNIQUEUE KEY WORD? what is the difference between PFILE AND REF?
what is the purpose of indicators in rpg?
define data structure?
RPG400 
