Prev: Could someone please say something on my issue?
Next: user exit problem
From: Serge Rielau on 7 Oct 2006 06:00
Squeezing in MERGE won't work in the same way.
It's the "missing piece".
Much to my dismay SELECT FROM MERGE is not support at present, and WITH
can't precede MERGE.
You can consider using a dynamic compound statement or simply wrapping
the MERGE into an SQL Table function in combination to what Miro proposed.
That should work very well in a non DPF environment.
Make sure to check the db2exfmt.

On the topic of allowing stacked updates those who heard me IBM panel at
IDUG Europe Thursday know that I would like to reduce complexity of SQL
rather than add more to it.
The WITH clause allows for a clean way to semantically serialize these
constructs. Allowing for stacking and joins between updates get very
quickly very unreadable.
We prefer leaving the pipelining to the optimizer.

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

IOD Conference
http://www.ibm.com/software/data/ondemandbusiness/conf2006/
First  |  Prev  | 
Pages: 1 2
Prev: Could someone please say something on my issue?
Next: user exit problem