Can DB2 be accessed by TSO users? If yes, which command is
used to invoke DB2?
How can you quickly find out the # of rows updated after an update statement?
Is it possible to update a primary key value? If not, what is the error code given? If yes, can more than 1 primary key column be updated at a time?
What action db2 takes when a program aborts in the middle of a transaction?
What are the abend codes occour in ur latest PROJECT in DB2
What is meant by index cardinality?
how to u check the query is executing or not ?where will u check for sqlcode ?
What is sqlcode -811?
7 Answers Accenture, CTS, TCS,
what will be the output of the below given query, if no matching records are found : (a.) 0 (b.) null (c.) error select Avg(salary) from TableA where Deptno = 'insurance'
in db2, already 10 columns arie der, and i want to insert 11th column. what parameters u wil consider for insertion and how will u insert
What can the SET option of the Repair Utility accomplish?
what is cursor stability?
Is it Possible to read from PS file and write it to database by using dynamic sql(execute immediate)