Follow Our FB Page << >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

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 is the difference between plan and package in db2?

0 Answers  

What are the 2 sqlcodes that are returned?

0 Answers  

What is an alias?

3 Answers  

If we keep the DCLGEN structure for a table in a copybook and include it in the COBOL program using the COPY statement, will there be any impact during compilation or at any stage of program execution?

2 Answers  

What language is db2 written in?

0 Answers  

Mention the length of physical storage of the given data types of db2 – date, timestamp, time

0 Answers  

i have a db2 variable how do u declare tht into working storage section ?

1 Answers   TCS,

i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?

0 Answers   TATA,

pls explain the precompilation process of cobol-db2 pgm

3 Answers   HCL, IBM,

What is reorg in database?

0 Answers  

How does one remove entries from the SCT02 table?

1 Answers  

How to find the number of rows in db2 tables?

0 Answers