What is difference between *omit and *nopass?
Why might full image copies be faster to implement than an incremental image copy?
What are the contents of a DCLGEN?
What is coalesce in db2?
What's the maximum number of volumes that can be added to a STOGROUP?
What are db2 objects?
Is DECLARE TABLE in DCLGEN necessary? Why it used?
What action db2 takes when a program aborts in the middle of a transaction?
what is commit & rollback? When and where is used while compiling a cobol-db2 program?
What is DYNSLT keyword? How do you perform selection using DYNSLT
This was related to -811 sqlcode, In a COBOL DB2 program which accesses employee table and selects rows for employee 'A', it should perform a paragraph s001-x if employee 'A' is present. In this case it gets -811 sqlcode, but still it process the paragraph s001-x. What could be wrong in my code.
Suppose we have a query for update update table1 set col1 = 'val1' where col2=(select .... from ...) suppose the subquery does not return any record, what will happen to update?
how many partitions are possible in partitioned tablespace? dont say 1-64. a)240 b)256 c)512 d)none