Answer Posted / kc
SELECT colName,TypeName FROM SYSCAT.COLUMNS WHERE TABSCHEMA = <database> AND TABNAME =<tablename>
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is difference between alias and synonym in db2?
How to execute stored procedures?
What is coalesce in db2?
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 ?...
Mention the definition of cobol in varchar field.
Why do we use cursor?
How do we specify index to include or not during bind process.
Explain about rct in db2?
How can record locking be achieved in those DB2 versions which do not support it?
what are bind concepts in db2 cobol?
What is the physical storage length of the data types date, time, and timestamp?
What is innodb buffer pool?
What is meant by union and union all?
Explain db2.
Which components manage deadlocks in db2?