WHERE DO WE USE COMIT KEYWORD IN AN RPG PROGRAM?
YOU MADE SOME CHANGES TO DATABASE BUT YOU DON'T WANT TO
SAVE THOSE CHANGES NOW? HOW DO YOU HANDLE THIS ONE?
- 2 Answers
- 12674 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / shobhit
Commitment Control is a function that allows processing a
group of changes in the file as a single operation.
If you want all the changes in file use COMMIT keyword else
use ROLLBACK.
Define COMMIT keyword in continuation line of F Spec(IPFK
spec) and COMMIT opcode in C spec.
| Is This Answer Correct ? | 7 Yes | 1 No |
Answer / mansi walia
Scenario:
Suppose we have written a new record in a database file but
we want to check if the employee phone number has is not
entered then roll back the changes else comit.
Example:
Move SEmpName EmpName
Move SEmpAdd EmpAdd
Move SEmpPh EmpPh
Write EmpRec
If EmpPh <> *Zeros
COMIT
else
RollBack
EndIf
| Is This Answer Correct ? | 1 Yes | 1 No |
What will be the value of STRING after line 0106 is executed in the code below? 0101 E* Fromfiletofile..tabnameprnentlenpdatabnamlenpda 0102 E ARR 8 1 0103 ISTRING DS 0104 I 1 8 ARR 0105 C MOVE *BLANK STRING 0106 C MOVEA'ABC' ARR A) 'AAAAAAAA' B) 'BBBBBBBB' C) 'CCCCCCCC' D) 'ABC ' E) ' ABC'
what do you mean by an input subfile, what are the keywords required?
list down and describe the sub systems vailable
Can we journel logical file and access path? Can we use commitment control for non-join L.F?
Anybody know the difference of primary file and full procedural file
Can anybody tell me, does CL/400 handle LEVEL check while running the CL program....? plz share your experience...
I want to add 10 days in current date. how it is possible in CL program...?
Difference between RESET and CLEAR
Assume 2 users are using the same file and first user updates some record in the file. Will the 2nd user will be able to see the updated record or not?
Why Rpg/400 is Famous?
explain sflclr, sflend, sfldlt, and sflcsrrrn?
HI,1: What is the function of 'SETON LR' AND '*INLR=*ON ? 2:Can we used "seton lr" OR "*INLR = *ON" in between the program code ? 3:if yes then according to there function the code which is written acter seton lr/ *inlr should not be execute . Can any one tell me why those code get executed ?
RPG400 
