Mention some fields that are a part of sqlca.

1015

What is the difference between drop table and delete table?

1203

What is load replace in db2?

992

How to rename a table in DB2 ?

1086

What is bind plan?

1044

Which components manage deadlocks in db2?

1064

What is access path in db2?

982

What is role in db2?

1101

What is sqlca?

1065

How do you find the maximum value in a column in db2?

1101

What is the use of reorg in db2?

1080

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?

8278

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 ?...

4300

What are union and union all?

976

How to find schema of a table in db2?

1011