RE: 4GL merge

Posted in 2006

Everett Mills — Wed, 19 Jul 2006 17:29:18 -0500 — source: Usenet: comp.databases.informix

Claus- I was assuming he was using IDS, not XPS. I should have said so... --EEM > -----Original Message----- > From: Claus Samuelsen [mailto:csa@dk.ibm.com] > Sent: Wednesday, July 19, 2006 12:53 PM > To: informix-list@iiug.org > Subject: Re: 4GL merge > > Everett Mills wrote: > [snip] > > Merge is not a keyword that Informix recognizes. > > From the fine Informix manual: > > >>-MERGE INTO--+-------------------------------+--+-target_table---+--+-- > -------------+--> > | (1) | +-target_view----+ '- > +----+--alias-' > '-| Optimizer Directives |------' '-target_synonym-' > '-AS-' > > >--USING--+-source_table----+--+---------------+----------------> > +-source_view-----+ '-+----+--alias-' > '-source_subquery-' '-AS-' > > (2) > >--ON--| Condition |--------------------------------------------> > > (3) > >--WHEN MATCHED THEN UPDATE--| SET Clause |---------------------> > > .-,------. > V | (4) > >--WHEN NOT MATCHED THEN INSERT----column-+--| VALUES Clause |------>< > > > PS - only XPS :-) > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list