Interested to Buy Any Domain ? << Click Here >> for more details...
i have one physical file which is having two logical files.
logical a have unique keyword and logical b doesnt have a
unique keyword. can i give duplicate values while updating
through physical file. if no why?
- 4 Answers
- 14538 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / syam
You cannot update Physical file or Logical File.
duplicate key
| Is This Answer Correct ? | 15 Yes | 1 No |
Answer / rajesh
While updating the Physical file, it looks for constraints
on all the all logicals defined over it.
| Is This Answer Correct ? | 14 Yes | 1 No |
Answer / sumit gupta
Whenever you update physical file, then it checks for all
file level keyword that specifies on logical file if any.
If no logical then simple update will perform.
In this, before updating your physical file temporary
program will get the UNIQUE specified as file level keyword
on 1 logical file.
And thus it through error, Duplicate key error in another
database member
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / ankur
no u can not give duplicate value while updating through
physical file. Because logical file based on physical file
and having accesspath that is base on physical file
accesspath.
| Is This Answer Correct ? | 1 Yes | 1 No |
what is RCLRSC?
when would you prefer logical file than opnqryf?
can you explain the difference between spacea,spaceb,skipa and skipb. I'm new to learning about as400 and printer files. can any one give me an example using source code showing the difference that occurs between using these 4 keywords. A-Physical file PF004 source UNIQUE R RR STUNAM 10 ROLLNU 5 0 MARKS 3 0 SEX 6 K ROLLNU 4 records present in PF004 are STUNAM ROLLNU MARKS SEX KAVYA 12,344 55 FEMALE MADHAVAN 14,579 60 MALE RAMYA 14,785 70 FEMALE KRISHNAN 14,988 72 MALE B-Printer File PRINT1 source A R HEADER A 10 3'STUNAM' A 10 20'ROLLNU' A 10 30'MARKS' A 10 40'SEX' A R DETAIL A SPACEB(1) A STUNAM 10 3 A ROLLNU 5 0 20 A MARKS 3 0 30 A SEX 6 40 A R FOOTER A SPACEB(1) A 20'END OF REPORT' C-RPG/400 Program PRTTPG source FPF004 I F E DISK FPRINT1 O E PRINTER C WRITE HEADER C READ PF004 60 C *IN60 DOWEQ *OFF C WRITE DETAIL C READ PF004 60 C ENDDO C WRITE FOOTER C SETON LR D-spooled file result set Display Spooled File File . . . . . : PRINT1 Page/Line 1/10 Control . . . . . Columns 1 - 130 Find . . . . . . *...+....1....+....2....+....3....+....4....+....5....+.... 6....+....7....+....8....+....9....+....0....+....1....+.... 2....+....3 STUNAM ROLLNU MARKS SEX KAVYA 12344 055 FEMALE MADHAVAN 14579 060 MALE RAMYA 14785 070 FEMALE KRISHNAN 14988 072 MALE END OF REPORT Bottom F3=Exit F12=Cancel F19=Left F20=Right F24=More keys I have changed from SPACEB to SPACEA now in my printer file source E-Changed PRINT1 Source A R HEADER A 10 3'STUNAM' A 10 20'ROLLNU' A 10 30'MARKS' A 10 40'SEX' A R DETAIL A SPACEA(1) A STUNAM 10 3 A ROLLNU 5 0 20 A MARKS 3 0 30 A SEX 6 40 A R FOOTER A SPACEA(1) A 20'END OF REPORT' F-Spooled file Result Set after keyword change Display Spooled File File . . . . . : PRINT1 Page/Line 1/10 Control . . . . . Columns 1 - 130 Find . . . . . . *...+....1....+....2....+....3....+....4....+....5....+.... 6....+....7....+....8....+....9....+....0....+....1....+.... 2....+....3 KAVYAM 12344U 055KS FEMALE MADHAVAN 14579 060 MALE RAMYA 14785 070 FEMALE KRISHNAN 14988 072 MALE END OF REPORT Bottom F3=Exit F12=Cancel F19=Left F20=Right F24=More keys Overprinting not displayed.
which type of object is used in db2/400?
what is message subfile?
what is the main use of OPNQRYF ?? in that query why we can use OVERDBF and in that OVERDBY why should we use SHARE(*YES)
how many maximum spaces could be given in o specs?
how to get the cursor position?
Define the purpose of the following code (If you know, how would this be written in RPG ILE) HI LO EQ C *IN66 DOUEQ *OFF C KEY1 CHAIN FILEA 90 66 C 66 CALL PGM1 PRM C ENDDO
How can we change the uppercase to Lowercase in RPG?
Hey, What is the difference between SCAN,CHECK,XLATE OPCODES? please give me the answeres with example in real time senario?
How can you identify End of file in CLP program?
RPG400 
