How to view db2 table structure?
Define db2.
how to take the back up of the DB2 table.
What is error -818 in db2. where can you find the timestamp of the DBRM and the source code.( precompile puts the timestamp on dbrm and source code correct?)
What is check constraint in db2?
What is the SQL query to select, delete and get count of duplicate rows in DB2?
What is UNION,UNION ALL?
What is Declaration Generator(DCLGEN)?
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 do you resolve -805?
where will u check for sqlcode ?
Which DB2 catalog tables are used to produce a list of table column by table for all tables in a database?
What is dclgen in db2?