wht are the restrictions for union ?

Answers were Sorted based on User's Feedback



wht are the restrictions for union ?..

Answer / rockys

Can be used ONLY with cursor

Is This Answer Correct ?    7 Yes 0 No

wht are the restrictions for union ?..

Answer / sunil

there should be no duplicates in the tables.

Is This Answer Correct ?    1 Yes 2 No

Post New Answer

More DB2 Interview Questions

What are the contents of a dclmgen?

0 Answers  


Which catalog tables contain authorization information?

1 Answers  


where will u check for sqlcode ?

2 Answers   TCS,


What is meant by a unit of recovery?

1 Answers  


What do the initials DDL and DML stand for and what is their meaning?

2 Answers  






Where besides the DB2 catalog is database object information stored by DB2?

1 Answers  


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.

6 Answers   IBM,


How to create backup table in db2?

0 Answers  


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.

2 Answers   iGate,


What is a db2 table?

0 Answers  


How to find schema of a table in db2?

0 Answers  


What information is held in SYSIBM.SYSCOPY?

1 Answers  


Categories