wht are the restrictions for union ?

Question Posted / visu.kanchamreddy

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

More DB2 Interview Questions

How do I create a table MANAGER (EMP-NO, MANAGER) where MANAGER is a foreign key which references to EMP-NO in the same table? Give the exact DDL.

What is the maximum size of varchar data type in db2?

Which DB2 catalog tables are used to produce a list of table column by table for all tables in a database?

What is drop table?

What is the COBOL picture clause for a DB2 column defined as DECIMAL(11,2)?

Suppose if I need to update a column, how you do that using cursor?

What is cursor in dbms?

Discuss about db2 bind?

What is the format (internal layout) of ?TIMESTAMP??

How do run the JCL which has 25 steps by skipping the following steps 5, 10,15 and 25 without using COND statement

what is the certification that has a good value for a practioner in mainframes but not habving much knowledge on db2 related stuff?

What is a buffer pool?

For more DB2 Interview Questions Click Here