Using updateRow() in select ... order by

From: Scorpio (_scorpio_at_libero.it)
Date: 01/27/04 

Date: Tue, 27 Jan 2004 20:44:46 GMT

Hi newsgroup,

I've encountered a problem with db2/as400.

I need do update rows in a resultset returned from a query "Select * from
table order by field", but it seems that db2/as400 does not support
updatable resultset from select with order by clause.

Did anybody else encounter this problem?
Any suggestions ?

Scorpio.

Relevant Pages

  • Re: MER - complicated join
    ... How do I set up a join so that my main table can get prices attached to it ... tells me to create a separate query and then include that query in the sql - ... So each record in ENCOUNTER has up to 4 codes populated. ...
    (microsoft.public.access.formscoding)
  • Re: Two Tables with Different Dates
    ... Do the Union query and, then, Join that query with the Patient table. ... One table is called the Encounter table and the other is ...
    (microsoft.public.access.queries)
  • Re: Query
    ... Another way to do this is to use an Exists clause. ... FROM Demographic as D INNER JOIN Encounter as E ... Save that and then use it in a summary query. ... > primary key, and the two tables are linked by this key. ...
    (microsoft.public.access.queries)
  • Re: Two Tables with Different Dates
    ... Jet will resolve using the aliases for the tables that have the same field ... > the final query, and that is the Patient Number. ... One table is called the Encounter table and the other is the ...
    (microsoft.public.access.queries)
  • Re: Two Address Fields from Two Tables in a Query
    ... >I have a query with several tables. ... Two of the tables are called Encounter ... >and Encounter History. ... So I want to either show one or the other address, depending on ...
    (microsoft.public.access.queries)