wht are the restrictions for union ?

Question Posted / visu.kanchamreddy

2 Answers
6670 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

My cobol program(not having any sql statements) is calling another cobol program ( having sql statements), what is needed for compilation and run in jcls .

3 Answers Cap Gemini, RBS,

What are packages in db2?

0 Answers

what is the Foreign key? explain?

2 Answers

What is db2 bind?

0 Answers

Suppose the outcome of executing a query results in a row having null. Based on the answer how you use it? Its declaration and inclusion?

2 Answers Verizon,

How to select the duplicate rows from a table?

4 Answers

What is drop table?

0 Answers

How do you retrieve the data from a nullable column?

2 Answers

What is cursor stability?

1 Answers

I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?

2 Answers

What is the size of a data page?

2 Answers IBM,

What are the disadvantages of PAGE level lock?

3 Answers

For more DB2 Interview Questions Click Here