I need to view the number of tables existing under one
particular Owner. Is it possible? If so, pl give the SQL
query for this?
why we go for SPUFI for creating tables or for sql queries?
What is scrollable cursor in db2?
Can any one tell me about Restart logic in DB2.
Can you search give an array in the WHERE clause of a db2 query?
What technique is used to retrieve data from more than one table in a single SQL statement?
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?
explain about index with examples
How to see the structure of db2 table??
How can you split a table in to exactly half?
How to design maps
How will you return the number of records in table?
pls explain the precompilation process of cobol-db2 pgm