Comments (2)
  • Add a Comment
  • Edit
  • More Actions v
  • Quarantine this Entry

1 LennartJonsson commented Permalink

Nice article Serge, I use these constructions on a regular basis and find them very valuable. Two questions, any plans for MERGE in this respekt, and did transition tables make it into SQL2011 (don't have the docs at hand)

 
/Lennart

2 SergeRielau commented Permalink

lennart,

 
DB2 for zOS has a flavor SELECT FROM MERGE.
I am hoping to add this in the future, but so far I'm lacking a business requirement.
The power of it is obvious however,
 
As for SQL2011. I do not k ow but will inquire.