Mention some fields that are a part of sqlca.
What is the difference between drop table and delete table?
What is load replace in db2?
How to rename a table in DB2 ?
What is bind plan?
Which components manage deadlocks in db2?
What is access path in db2?
What is role in db2?
What is sqlca?
How do you find the maximum value in a column in db2?
What is the use of reorg in db2?
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
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 ?...
What are union and union all?
How to find schema of a table in db2?