Re: Updates using subset of from clause
On Jun 1, 12:44 am, Krishna <calvinkri...@gmail.com> wrote:
> As per the documentation at;http://publib.boulder.ibm.com/infocenter/idshelp/v10/topic/com.ibm.sq...
>
> an update can be made using a subset of the from clause. But the issue
> I face, is that even the example given in that page does not work on
> my IDS instance.
>
> Using IDS 10.00.UC3R1. Is this a doc bug? Is this feature supported?
The relevant section of the manual to which you refer is:
Subset of FROM Clause In Extended Parallel Server, you can use a
join to determine which column values to
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
update by specifying a FROM clause. Columns from any table in the
FROM clause can appear in the WHERE
clause to provide values for the columns and rows to update. For
example, in the following UPDATE statement, a
FROM clause introduces tables to be joined in the WHERE clause:
UPDATE tab1 SET tab1.a = tab2.a FROM
tab1, tab2, tab3 WHERE tab1.b = tab2.b AND tab2.c =tab3.c
Note my annotation. This feature is ONLY available in the Extended
Parallel Server (XPS or Informix 8.xx) not in IDS 7/9/10/11.xx
Art S. Kagel
On Jun 1, 5:47 pm, art.ka...@gmail.com wrote:
> On Jun 1, 12:44 am, Krishna <calvinkri...@gmail.com> wrote:
>
> > As per the documentation at;http://publib.boulder.ibm.com/infocenter/idshelp/v10/topic/com.ibm.sq...
>
> > an update can be made using a subset of the from clause. But the issue
> > I face, is that even the example given in that page does not work on
> > my IDS instance.
>
> > Using IDS 10.00.UC3R1. Is this a doc bug? Is this feature supported?
>
> The relevant section of the manual to which you refer is:
>
> Subset of FROM Clause In Extended Parallel Server, you can use a
> join to determine which column values to
>
> ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Can you please point me to the section of the manual where this is
mentioned? The
link I mention above does not mention this!
> update by specifying a FROM clause. Columns from any table in the
> FROM clause can appear in the WHERE
> clause to provide values for the columns and rows to update. For
> example, in the following UPDATE statement, a
> FROM clause introduces tables to be joined in the WHERE clause:
> UPDATE tab1 SET tab1.a = tab2.a FROM
> tab1, tab2, tab3 WHERE tab1.b = tab2.b AND tab2.c =tab3.c>
> Note my annotation. This feature is ONLY available in the Extended
> Parallel Server (XPS or Informix 8.xx) not in IDS 7/9/10/11.xx
>
> Art S. Kagel