RE: How Update?
Posted in 2009
Topics: SQL Development & Query Writing, Server Administration
The latest IDS 11.50 release 11.50.xC5 supports Merge statement which can be used for such update joins. For example, MERGE INTO tab2 USING tab1 ON tab1.A = tab2.A WHEN MATCHED THEN UPDATE SET tab2.B = tab1.B; Please refer to http://publib.boulder.ibm.com/infocenter/idshelp/v115/index.jsp?topic=/com.ibm.sqls.doc/ids_sqs_2030.htm for more information on this functionality. thanx Prasad From: "Jack Parker" <jack.parker4@verizon.net> To: <informix-list@iiug.org> Date: 08/01/2009 12:56 PM Subject: RE: How Update? Sent by: informix-list-bounces@iiug.org Update tab2 set d=(select b from tab1 where tab2.a=tab1.a) where 1=1; This assumes you are dealing with less than millions of rows. If the datasets are very large, then I wrote up some techniques to deal with them some time back. See http://www.ibm.com/developerworks/data/zones/informix/library/techarticle/pa rker/0502parker.html Example 2 - DSS Updates, perhaps not practical in your situation, but it may give you ideas. cheers j. (back from vaca) Sane ego te vocavi. Forsitan capedictum tuum desit. -----Original Message----- From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org]On Behalf Of Ralf Hackmann Sent: Saturday, August 01, 2009 3:40 PM To: informix-list@iiug.org Subject: How Update? Hello, I have have two tables Tab1 A, B, C Tab2 A, D,E The Tables are 1:1 related with edenticale field A (Articlenumber) Now I must copy the values of D in B How should I create my UPDATE statement in dbacces? Greating Ralf _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list