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

On which levels locks can be applied?

how many bytes timestamp token occupies?

What is a storage group (stogroup)?

What are types of indexes?

the dd name for ksds is dest1 and what is the dd name for alternate index of ksds ? a.dest b.dest1 c.dest1a d.dd1

Give the name of some fields form sqlca.

What is CHECK PENDING ?

What is a thread?

What's the difference between DB2 active log and archive log? Thanks a lot...

What is an instance database?

What is the difference between base table and view?

Can you tell me how can you find out the # of rows updated after an update statement?

For more DB2 Interview Questions Click Here