What is a result table?
Answer / s
Result table contains rows DB2 selects from one or more
base tables.
| Is This Answer Correct ? | 1 Yes | 0 No |
How to resolve -917 sql code in DB2?
How do you eliminate duplicate values in db2?
What is a clustering index?
what is static sql? what is dynamic sql? Give me details
What is REORG? When is it used?
What is auditing?
how can we find nth max salary from A table
How can we retrieve the total number of records in RPG & CLLE?
we can code COPY DCLGEN or INCLUDE DCLGEN, At which stage of the precompilation , dclgen get expanded if we write 1) copy 2) include one question about dclgen.. Is it mandatory to use declare table in dclgen.. I think no...but it will be used by the precompiler to validate the table name,column name etc.., can one clear my doubt ..is it necessary to include declare table or not?
What information is held in SYSIBM.SYSCOPY?
What is ACQUIRE/RELEASE in BIND?
a cursor normally gets closed once we provide a commit . If u try to close the same cursor with close cursor command later after providing the commit will there be any sql-error.