wht are the restrictions for union ?
Answers were Sorted based on User's Feedback
What are the contents of a dclmgen?
Which catalog tables contain authorization information?
where will u check for sqlcode ?
What is meant by a unit of recovery?
What do the initials DDL and DML stand for and what is their meaning?
Where besides the DB2 catalog is database object information stored by DB2?
Hi Team, Please tell me, If i don't declare the cursor in the program and i have given open and fetch and close, then what error will get.
How to create backup table in db2?
in the CURSOR declare statement, if i am using an where clause and trying to compare the value with a host-varialble. EXEC SQL DECLARE C1 CURSOR FOR SELECT DEPTNO, DEPTNAME, MGRNO FROM DEPARTMENT WHERE ADMRDEPT = :ADM-DEPT Where would i need to provide value to this host-variable in the where clause. how could i pass value to this host-variable to check it.
What is a db2 table?
How to find schema of a table in db2?
What information is held in SYSIBM.SYSCOPY?