What are the three lock types?
Answers were Sorted based on User's Feedback
What is deadlock?
What is sqlcode -922 ?
which SQL comment successfully removes uncommitted changes from a DB2 database A) rollback B) delete C) drop D) decommit
What do you need to do before you do EXPLAIN ?
How do I add a column to a table in db2?
Mention the location where the output received from explain statement is stored.
run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...
A Table feild is declared as Decimal(7,2). I want to insert the decimal in to this column thru cobol-db2 program. How should I declare my local input file variable or any suggestion?
what are the copybook changes generally we done?can anyone tell me......... Thanks in advance........
What is the difference between Primary key and unique index?
What is a composite index and how does it differ from a multiple index?
Why might full image copies be faster to implement than an incremental image copy?