In a DB2-CICS program which is acts as co-ordinator and
which is participant?
What is db2 optimizer?
what is plan? is plan executable or package?
What is the SQL query to select, delete and get count of duplicate rows in DB2?
Give the name of some fields form sqlca.
What is database manager in db2?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
What is db2 command?
Where is the output of EXPLAIN stored?
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
What is the physical storage length of date data type?
Request to database but database is not available so what is was abend is raised?
which SQL comment successfully removes uncommitted changes from a DB2 database A) rollback B) delete C) drop D) decommit