How would you find out the total number of rows in a db2 table?
No Answer is Posted For this Question
Be the First to Post Answer
Could you please let me no the query for below I have table name xyx under this there is column name called employee name which starts from 100th column ends 120th column,now i want to replace only column from 101 to 104 which contains ABCS to replace with PQRS for all records which comes beetween 101 to 104 ..how to write query for this..
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
What is lock contention?
What do you mean by NOT NULL WITH DEFAULT? When will you use it?
Can you use max on a char column?
How many clustering indexes can be defined for a table?
Can we able to find all the Table names under a Particular Plan?
how to resolve -805. give clear explination for that
what is datacom db?
Is it possible to create an Instance in DB2 using DB2 Control Center ?
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'