What techniques are used to retrieve data from more than
one table in a single SQL statement?
Answer Posted / ezaz
joing
| Is This Answer Correct ? | 0 Yes | 4 No |
Post New Answer View All Answers
What is innodb buffer pool?
How to access db2 tables in mainframe?
Give the name of some fields form sqlca.
Where do you specify them?
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
What is copy pending status in db2?
How do I start db2 in windows?
How can you quickly find out the # of rows updated after an update statement?
Explain in detail about buffer manager and its functionalities?
What is a db2 tablespace?
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
What are the full forms of spufi and dclgen and why are they used?
How is the value function used?
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?