what's the equivalent Cobol Data type for Decimal(x,y) in
DB2? what does the current SQLID register contain?
Answers were Sorted based on User's Feedback
Answer / arun
cobol equivalent data type would be PIC s9(x-y)V9(y) comp3
Is This Answer Correct ? | 14 Yes | 0 No |
Answer / marekj
SQLID - current SQL authorization ID, and qualifier for
dynamic SQL if DYNAMICRULES(run) was set during BIND process.
Is This Answer Correct ? | 2 Yes | 1 No |
How is a typical db2 batch pgm executed?
In terms of DB2 indexing, what is the root page?
How can you compare table column after update and before update?
If I have a view which is a join of two or more tables, can this view be updatable?
how can you save the query in QMF?IS IT POSSIBLE OR NOT.IF POSSIBLW HOW?
1) I have 3 programs : PGMA, PGMB, PGMC. PGMA calls PGMB and PGMB calls PGMC. I have to do inserts, updates in all the 3 pgms. 2) Say PGMC has done its work successfully and returned to PGMB 3) PGMB had an SQL error while doing some update 4) PGMA has already done some updates before calling PGMB all are running under the same CICS region. What will happen if I issue SYNCPOINT ROLLBACK in PGMB when it abends ? Does all the changes in PGMA,B,C rollback ? (because all the pgms belong to same task).
What parameters are used to control the free space in DB2?
Explain about rct in db2?
How would you move a tablespace (using STOGROUP) to a different DASD volume allocated to that tablespace?
How do I add a column to a table in db2?
what is cursor stability?
When do you specify the isolation level?