Re: Count function produce Wrong results

Alexei Novakov wrote: > --- Jey Razack <[EMAIL PROTECTED]> wrote: >> DB Version : 7.5.00.24 >> OS Redhat 2.4.22-1.2199 i686 athlon i386 GNU/Linux >> >> Immediately after data insert (COMMIT after each >> insert), the 'COUNT' function on a table (2.3 >> million records) >> generates wrong result

Re: Count function produce Wrong results

Hi Jey --- Jey Razack <[EMAIL PROTECTED]> wrote: > DB Version : 7.5.00.24 > OS Redhat 2.4.22-1.2199 i686 athlon i386 GNU/Linux > > Immediately after data insert (COMMIT after each > insert), the 'COUNT' function on a table (2.3 > million records) > generates wrong result (higher than the actua

Tablestatistics

Hello, I am looking for SQL Scripts or report components which can summarize the table and index statistics. I am looking especially for an overview on table and index size, but also some advisor-type warnings like large unused regions due to fragmentation. While running some queries on TABLESTAT

Alter Table on existing table containing data

Hi, I am trying to add a column to an existing table in a database. When I try to do this in SQL Studio, it give me a warning about "ALTER TABLE" being very slow when used on a table containing data and then it seems to hang. Is there a workaround for that? Thanks. Stefan Schmidt GiveMePowe

AW: Influence a Sequence

Christoph Weser wrote : > >Hello! > >Short question: Is it possible to increment a sequence manually? >Example: My sequence goes 1000, 1001, 1002, but after a >special event it >should go on with 2000, 2001, 2002,... > >Any other solution than dropping and recreating the sequence? > >Thanx a l

Re: Influence a Sequence

ALTER SEQUENCE... ? Or drop and recreate Or read all the values you don't need... robert > --- Ursprüngliche Nachricht --- > Von: Christoph Weser <[EMAIL PROTECTED]> > An: "maxdb (E-Mail)" > Betreff: Influence a Sequence > Datum: Wed, 1 Jun 2005 15:09:50 +0200 > > Hello! > > Short question:

Influence a Sequence

Hello! Short question: Is it possible to increment a sequence manually? Example: My sequence goes 1000, 1001, 1002, but after a special event it should go on with 2000, 2001, 2002,... Any other solution than dropping and recreating the sequence? Thanx a lot! Chris -- MaxDB Discussion Mail

Re: Commit in procedure

How do I run without this isolation level (3)? I don't configure nothing about level and just run a procedure. - Original Message - From: "Anhaus, Thomas" <[EMAIL PROTECTED]> To: "Flavio Silveira" <[EMAIL PROTECTED]>; Sent: Wednesday, June 01, 2005 4:48 AM Subject: AW: Commit in proce

RE: Count function produce Wrong results

Jey Razack wrote: > DB Version : 7.5.00.24 > OS Redhat 2.4.22-1.2199 i686 athlon i386 GNU/Linux > > Immediately after data insert (COMMIT after each insert), the > 'COUNT' function on a table (2.3 million records) > generates wrong result (higher than the actual). > > Select fld1,count(*)

RE: How to set/alter a default in SQL-Studio !

Hello Albert, SQL Studio does not handle the default values for date and a ' ' for char correctly. I will correct this in one of the next versions. http://www.sapdb.org/webpts?wptsdetail=yes&ErrorType=0&ErrorID=1135887 Thank you for the hints. Regards Wolfgang -Original Message- From:

Webdav, Server Crash

Good morning, Yet an another post about Webdav :-) We are trying to find url of files stored into a webdav server to give the user an human readable file path. We created that function to do it : CREATE FUNCTION SEARCHURL(MYCID CHAR(24) BYTE) RETURNS VARCHAR AS VAR URL VARCHAR(1000); NOM V

AW: Commit in procedure

Flavio Silveira wrote : > >When I write a procedure, I have to explicity COMMIT or the >procedure do this automaticaly? I have a problem: I have a >cursor and, for each fetch, i insert some values in a table. >But the table "lock" every time. If I explicity a COMMIT, the >table unlock? > >Than

AW: ONLY_FULL_GROUP_BY disable?

Ola Natvig wrote: > > Hello all > > In mysql you need specify ONLY_FULL_GROUP_BY if you want the database to > kill queries which are not 'fully grouped'. > > On my maxdb installation (7.6.00.09) this functionality is active, no > queries without full grouping are allowed. For all I know this ma

AW: mapchar seems to exceed the available field size

Michael P. wrote: > > Dear group, > > how can I solve the following MAPCHAR problem? > > CREATE TABLE prods > ( > id Integer NOT NULL DEFAULT SERIAL (1), > prod_code Char (10) ASCII, > PRIMARY KEY ("ID") > ) > > INSERT INTO prods SET id = 1, prod_code = 'ö12345678' > INSERT INTO p

AW: Lock in table

Flavio Silveira wrote: > > I'm executing a procedure that open a cursor and insert some values in a > table for each line of that cursor. But I have a problem: the procedure > "lock" the table and not unlock anymore. Is there any command to unlock > the > table? After each insert I have to commit

AW: Commit in procedure

Flavio Silveira : > > When I write a procedure, I have to explicity COMMIT or the procedure do > this automaticaly? I have a problem: I have a cursor and, for each fetch, > i insert some values in a table. But the table "lock" every time. If I > explicity a COMMIT, the table unlock? > No dbproc