The result of more than 1 query to be written in one output



IBM's flagship relational database management system

The result of more than 1 query to be written in one output

Postby Shyamala » Thu Oct 11, 2012 2:52 pm

Hi,

We can use more than one query in BMC Unload and specify that many number of output files usually.
But if we need the output of two queries to be written in the same output file, how can we achieve it?
Thanks.
Shyamala
 
Posts: 2
Joined: Thu Oct 11, 2012 2:46 pm
Has thanked: 0 time
Been thanked: 0 time

Re: The result of more than 1 query to be written in one output

 

Re: The result of more than 1 query to be written in one out

Postby Shyamala » Thu Oct 11, 2012 5:03 pm

Using UNION is one way..Is there any other way to achieve this?
Thanks.
Shyamala
 
Posts: 2
Joined: Thu Oct 11, 2012 2:46 pm
Has thanked: 0 time
Been thanked: 0 time


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post