Why cant we use Union in embedded SQL

mohideen · New User Joined: 31 Mar 2004 Posts: 4

(1) which DB2 utility program used to make full image copy and incremental image copy?

(2) why cant we use Union in embedded SQL?

Thanks mohideen.

callkris_cit · New User Joined: 22 Apr 2006 Posts: 44

(1) which DB2 utility program used to make full image copy and incremental image copy?

DSNUTILB utility program is used to take a Image copy and Incremental copy.

(2) why cant we use Union in embedded SQL?

We can use Union in embedded SQL. But you should create a Cursor for Select statement.

mahsug · Posted: Fri Jun 02, 2006 5:08 pm

Hi ,

I have a small correction to what Krsi said , DSNUTILB is a program , which would be made use for most of the Db2 batch programs , its only the input / control card statements would make difference for the utility.

For the above query , the input program would DSNUTILB , and the Db2 utility is COPY
and the statement for full image copy would be like

COPY TABLESPACE <DBNAME >.<TSNAME> FULL YES

and the statement for Incremental image copy would be like

COPY TABLESPACE <DBNAME >.<TSNAME> FULL NO

Referring to the query no 2 regarding usage of union in embedded SQL ,.
we can certainly use the union withCURSORS , but the overhead on the memory will be too high (Assuming , your result sets are very huge ), which would degrade the application performance.

Let me know , if more questions

Mahesh