InformixDBDictionary

Posted in 2010

André Luiz Rufino — Fri, 23 Apr 2010 13:39:01 — source: IIUG Forums & Mailing Lists

Hi folks. I need to execute a uupdate query using alias to refer table names. Like this update a set a.campo1 = b.campo1 from tabela1 a join tabela2 b on a.campo = b.campo where a.campo2 = balbalab To make it possible, I need to set allowAliasInBulkClause to false in InformixDBDictionary. Does anybody here know how to do it? Thanks, André Luiz _________________________________________________________________ Você sabia que seu navegador te ajuda a ficar longe de vírus? Leia mais sobre isso. http://www.microsoft.com/brasil/windows/internet-explorer/?WT.mc_id=1500

↪ replying to André Luiz Rufino

Art S. Kagel — Fri, 23 Apr 2010 16:38:57 — source: IIUG Forums & Mailing Lists

You cannot usa a table alias for the primary table in an update statement. Art=20 -----Original Message----- From: Andr=E9 Luiz Rufino <andre_rufino@msn.com> Sent: Friday, April 23, 2010 9:39 AM To: ids@iiug.org Subject: InformixDBDictionary [19820] Hi folks.=20 I need to execute a uupdate query using alias to refer table names. Like th= is=20 update=20 a=20 set=20 a.campo1 =3D b.campo1=20 from=20 tabela1 a=20 join tabela2 b=20 on a.campo =3D=20 b.campo=20 where=20 a.campo2 =3D balbalab=20 To make it possible, I need to set allowAliasInBulkClause to false in=20 InformixDBDictionary. Does anybody here know how to do it?=20 Thanks,=20 [The entire original message is not included]=