Interested to Buy Any Domain ? << Click Here >> for more details...
What technique is used to retrieve data from more than one
table in a single SQL statement?
- 9 Answers
- 15487 Views
- CTS, IBM, TCS, I also Faced
- E-Mail Answers
Answer Posted / ravi
We can do this by using JOINS as well as Sub Queries
| Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
How many types of page locks can be held in db2?
What are types of indexes?
What is multi row fetch in db2?
Are view updateable?
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
Can you tell me how can you find out the # of rows updated after an update statement?
What is the usage of open cursor command?
What is syscat in db2?
What is the syntax for FETCH in DB2 ?
What are the different types of base tables?
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
What is scrollable cursor in db2?
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
