wht are the restrictions for union ?

Question Posted / visu.kanchamreddy

2 Answers
6673 Views
CTS, I also Faced
E-Mail Answers

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 is error -818 in db2. where can you find the timestamp of the DBRM and the source code.( precompile puts the timestamp on dbrm and source code correct?)

2 Answers

what is the difference between join and union?

4 Answers IBM,

What is the difference between base table and view?

7 Answers

What does db2 stand for?

0 Answers

What is the difference between dbm cfg and db cfg file in db2 ?

0 Answers MCN Solutions,

What is database alias db2?

0 Answers

Usually, which is more important for DB2 system performance - CPU processing or I/O access?

1 Answers

Can we able to find all the Table names under a Particular Plan?

1 Answers CTS,

What is the function of the Data Manager?

2 Answers

cursor with hold explain ?

1 Answers Verizon,

What are column-name qualifiers used?

1 Answers

What is a synonym? How is it used?

2 Answers

For more DB2 Interview Questions Click Here