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?
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 |
How do you find out whether a record is present in the physical file without reading the file? for Example Employee No: 100 in an Employee master.How do we find out whther 100 is present in Employee master without reading the file?
11 Answers Bank Of America, CSC, IBM,
I need to generate outfile for object of all the user lib. in the sysmte using cmd DSPOBJD. But this cmd is correcpted in my server,Any body tell me is there any alternative...?
How to code Page up and Page down in RPG for Single page subfile without using ROLLUP/ROLLDOWN in DSPF ?
please help me answer to this question what is the difference between the binding and srvpgm in ilerpg?
what is EXCEPT command in rpg and use
What is the difference between ITER and DO ? I know both are used to execute set of statements repeatedly, but what is the main difference?
When it is desirable to describe files Internally?
Errors in Sql query will be in which state?
How do you proceed in case your active AS400 session has got disconnected suddenly, how can you get back to your session ? Is it possible??
how does the rpg element work?
If my rpg program has a date field, what extra care I have to take while compiling that rpg program? If the file is keyed and I have declared the file as well as key list properly in my program. Still am getting an error message like "chain/reade operation is not allowed" what may be the case?
How do you code file / field renames in ILE RPG?