What techniques are used to retrieve data from more than
one table in a single SQL statement?
Answer Posted / obu
JOIN Statement
Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What is a db2 collection?
What is a cursor in programming?
What do you mean by storage group (stogroup)?
Describe major components of db2?
What is cursor stability in db2?
What is the connection string to connect to the DB2 Database ?
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
What is meant by union and union all?
What is check constraint. Explain with example.
What is innodb buffer pool?
Is db2 free?
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
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 ?
Define check constraint.
Are view updateable?