Help:Update row number
Jianglin Liu found a DBACCESS update of a table changed only 129 rows each time, even though the matching count was larger. Jonathan Leffler asked for engine, version and platform and speculated about an old SE lock limit. The poster said it was OnLine 7.1.3 on FTX, and other tables did not show the limit. Leffler warned OnLine 7.13 is not Y2K compliant, advised upgrading and asked for the error. Unresolved.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Hi, all:
I want to update some row of a certain table using DBACCESS.
At first, I use such a sql to get the count of rows:
select count(*) from tab1 where <condition>
But, when I use this sql
update tab1 set field='U' where <condition>Every time I execute it, it only update 129 rows.
I don't know why?
Thanks in advance.
Jianglin
Sent via Deja.com http://www.deja.com/
Before you buy.
liujianglin@21cn.com wrote:
> I want to update some row of a certain table using DBACCESS.
> At first, I use such a sql to get the count of rows:
> select count(*) from tab1 where <condition>
> But, when I use this sql
> update tab1 set field='U' where <condition>> Every time I execute it, it only update 129 rows.
> I don't know why?
Which database engine? Which version? On which platform?
Speculation: really old versions of SE using CREATLOCK locking would
run out of locks at 64 -- well, that's what I thought. Maybe it was
128, and
this corresponds to your 129, more or less... Not a good hypothesis,
but
without any data, as good as I can come up with before I sign off for
the night.
--
Jonathan Leffler (jleffler@informix.com, jleffler@earthlink.net)
Guardian of DBD::Informix v0.95 -- see http://www.perl.com/CPAN
#include <disclaimer.h>
In article <3883FFFB.838BF7FF@earthlink.net>,
Jonathan Leffler <jleffler@earthlink.net> wrote:
>
>
> liujianglin@21cn.com wrote:
>
> > I want to update some row of a certain table using DBACCESS.
> > At first, I use such a sql to get the count of rows:
> > select count(*) from tab1 where <condition>
> > But, when I use this sql
> > update tab1 set field='U' where <condition>> > Every time I execute it, it only update 129 rows.
> > I don't know why?
>
> Which database engine? Which version? On which platform?
>
> Speculation: really old versions of SE using CREATLOCK locking would
> run out of locks at 64 -- well, that's what I thought. Maybe it was
> 128, and
> this corresponds to your 129, more or less... Not a good hypothesis,
> but
> without any data, as good as I can come up with before I sign off for
> the night.
>
> --
> Jonathan Leffler (jleffler@informix.com, jleffler@earthlink.net)
> Guardian of DBD::Informix v0.95 -- see http://www.perl.com/CPAN
> #include <disclaimer.h>
>
>
Sorry.
My database engine is informix online 7.1.3 on FTX(Unix system V)
I have try to update other table in the same database, but don't have
this limitation.
Thx.
Sent via Deja.com http://www.deja.com/
Before you buy.
liujianglin@21cn.com wrote:
> Jonathan Leffler <jleffler@earthlink.net> wrote:
> > liujianglin@21cn.com wrote:
> > > I want to update some row of a certain table using DBACCESS.
> > > At first, I use such a sql to get the count of rows:
> > > select count(*) from tab1 where <condition>
> > > But, when I use this sql
> > > update tab1 set field='U' where <condition>> > > Every time I execute it, it only update 129 rows.
> > > I don't know why?
> >
> > Which database engine? Which version? On which platform?
> >
> > [...]
>
> Sorry.
> My database engine is informix online 7.1.3 on FTX(Unix system V)
>
> I have try to update other table in the same database, but don't have
> this limitation.
FTX? Pyramid PTX? Platform information includes maker, some
indication of which model, the operating system, and the o/s version.
My fault for not being clear.
OnLine 7.13 is not Y2K compliant. You are treading on thin ice using it.
Beware trying to do a restore from archives. Double check the Y2K page
at the Informix web site. Then upgrade!
What error do you get?
--
Jonathan Leffler (jleffler@informix.com, jleffler@earthlink.net)
Guardian of DBD::Informix v0.95 -- see http://www.perl.com/CPAN
#include <disclaimer.h>