And then of course it bounces so I have to wait until I get home to send it.
This whole spam thing is beginning to p*ss me off. Not only do I have to
wade through miles of spam and delete the obvious viruses, but it has
reached a point where half of the mail I send or half of the mail which is
sent to me winds up in a spam collection bucket somewhere - some of it never
to be seen again - because it is suspect or the person you are replying to
has chosen to protect themselves from spam harvesting like Arnaud here. We
need to go after the spammers. Castration is too good for them, perhaps
drawing and quartering might be better. They have ruined the internet.

===============================

Arnaud,

Replying from work, via webmail, so the reply doesn't work as well as my
normal mail reader. Look for "-" in front of where I wrote.

Sorry - should have been more careful. The rownum is, of course, not there
in Informix, but you could add a serial column to the table entitled
'rownum', and it will serve the same function.


Jack Parker" wrote
>
> Specific to your question - if state is a valid column, the same
methodology
> should work.

Well i was pretty sure it was possible, bt i don't figure out on how to code
this ....
The rownum need to be replace... but i don't know how to deal with.

Maybe with a "first" clause, but i cannot succeed in having correct code.


>But if you are trying to update a large table in Informix -
> why slow yourself down with Oracle-OLTP methodology? I suggest you read:
>
http://www-106.ibm.com/developerwork...502parker.html
>
Wow !
A must read...
(when i look at our performances... :-/ )

But in fact the problem is not only Database answer times based.
But processes too...
If i read to quickly the database (that contains data for query )
Ours processes are going to use 100% machine time for a while....

====
Quick description:
Our processes read a table and each rows contains data that permit to launch
an action (or many actions)

Then it can take for 1s to 5s working time (or more) with accessing or not
to the database.

So if i read 1000 at the same time:
it can take for 15 min to more than an hour to complete the Job.
====

- can you describe what the application does? Maybe I could offer a
suggestion if I understood it better.


> Although I've only advertised it about 1200 times on this group - OTOH, I
> wrote it so I wouldn't have to walk through it 1200 times.

sorry for that.... and thk you for taking time to post it once again ...and
maybe again and again and again ..... )

- I just meant that I've probably flooded the market - people are probably
tired of my mentioning the article.


Thk you for your answer, i will try to find how to write this query.
Must be easy , but at this point .... i do not know

Thk you once again for the article !

Arnaud


PS: Just a little request ...
Is there a lot of user of ESQLC ??

- At one time it was fairly popular, I don't see a lot of people using it
anymore.

Regards (a bientot),
Jack Parker



sending to informix-list


sending to informix-list