Joined: 01 Jul 2003 Posts: 15 Location: Phoenix , AZ
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.