How to find the number of rows in db2 tables?
No Answer is Posted For this Question
Be the First to Post Answer
What is the meaning of -805 SQL return code?
How to take backup of table in db2?
In a DB2-CICS program which is acts as co-ordinator and which is participant?
What is the syntax for FETCH in DB2 ?
Give the name of some fields form sqlca.
What is the difference between nvl and coalesce?
OUTER JOINS USED TO GET MATCHING AND NONMATCHING ROWS FORM 2 OR MORE TABLES BASED ON COLUMNS. SIMPLE JOINS ALSO DO THE SAME THEN WHAT IS THE USE OF OUTER JOINS.
I have a table name Table1 which contain columns Cust_no, car_model, country, salesamt. The records are 101, Fiat, India, 12345 2nd record is 102, Tata, USA, 98743 3rd record is 101, indica, India, 65342 4th record is 103, Toyota, UK, 64522 5th record is 103, Maruti, USA, 98632 and so on..... Now my question is write sql query which will give me detail about the sum of sales amount in perticular country
What does a deadlock mean in DB2?
What technique is used to retrieve data from more than one table in a single SQL statement?
What happens to a tablespace when its recovery infromation has been removed and a full recovery is no longer possible?
Mention the way of highlighting as well as putting a cursor to use in a cobol program.