I have a main program (A) where we delete some rows in
table in a cursor, and we commit it in sub program(B).
What will happen - will we get an error or not?
Answers were Sorted based on User's Feedback
Answer / manikanta
Whenever control is going to sub program or control is coming back to main program - COMMIT takes place automatically by the system.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / ananth
I dont know about this question?
Please let me know if you gave answer
| Is This Answer Correct ? | 0 Yes | 2 No |
Explain the EXPLAIN statement?
what is commit & rollback? When and where is used while compiling a cobol-db2 program?
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
wht r the requirements for writing a cobol-db2 pgm ?
What are the prerogatives?
what is load and unload in db2
One program calling 5 subprograms, its a cobol db2 program, after precompilation how many plans and packages will created?
Is db2 a programming language?
which is the most efficient tablespace?? a.simple tablespace. b.partitioned tablespace. c.segmented tablespace. d.none of the above. please post answer with the reason.?
Could you please let me no the query for below I have table name xyx under this there is column name called employee name which starts from 100th column ends 120th column,now i want to replace only column from 101 to 104 which contains ABCS to replace with PQRS for all records which comes beetween 101 to 104 ..how to write query for this..
What is the maximum size of a char data type in db2?