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 can we access Interactive job LDA in Batch Job?. and How we can access a file in interactive QTEMP lib in Batch job?.
1.Write code to read the records from a file and load an array of size 99? Make sure that you take care of all the error conditions?
how to retrieve particular field records from a physical file,say i have a physical file called 'employee' in it i have to retrieve the records of a field 'admin' present in pf 'employee' using rpg,but i should not use logical file or openquery file.
Need a sql query: retrieve all duplicate records in table?
Suppose we have one database file and it is used by 5 programs and in 3 program we have to add some records in datbase file s what is the impact on other program?
what was the robotech rpg?
what is kids-rpg?
Mr.Sidc sirfor my question{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} you have answered using MOVE opcode,can you illustrate me with a small example sir very kind of you.
A pgm subroutine calling child subroutine, that child subroutine again calling parent subroutine, u have 1000 lines of code, with out debugging , how can u find that error??? Is there any command to find errors in pgm???
1.what are the ARITHMETIC EXPRESSIONS IN CL PGM? 2.How to PASSING PARAMETER TO CL PGM?
How do you find whether a record is locked or not?
what is use of sflnxtchg and use of MDT(modify data tag).both r same r not and can we use these on dspf and subfile.