RE: Row locking problem.

Hi,(re-sent to put on mailing list) Thanks for getting back, ok. There are no deletes in this instance, and also no inserts. Under normal circumstances, I would do an insert if the last "select" returned no rows, but that was in effect resetting an existing property with this problem. The

Re: sum is rounding values when subquerying

Hi, Alexander. Could you confirm this? It could be fixed in the future? Thanks, Edson Richter Edson Carlos Ericksson Richter escreveu: In my tests, occur for either correlated and non-correlated queries. As always, putting a 1.0* in front of subquery (before parentesis) expresion works as workaro

A couple PHP questions

First one is why does maxdb_num_rows always return -1? If it's a bug in the api any ideas when it will be fixed? Second one is about the functionality of maxdb_query and MaxDB's stored procs. If a stored proc is called and returns out vars can we not just have mysql_query return an array (or objec

Weak performance of "group by" Statement?

Title: Weak performance of "group by" Statement? Hi! I'm experiencing a terrible bad performance for a simple group by statement and am now wondering whats going wrong (including me). I compared the results to a comparable DB2_UDB installation. There is an index on column X (Char(4)),

possible bug in maxdb_stmt_num_rows???

Hi, when I test the example shown in the php-maxdb-documentation (see below) I get the following warning: Warning: maxdb_stmt_num_rows() expects exactly 2 parameters, 1 given in C:\... on line 20 Number of rows: 0. In the documentation this function has only one parameter. Where is the mistak

RE: UTF8 and UCS2

Hi Gu Lei > -Original Message- > From: Gu Lei [mailto:[EMAIL PROTECTED] > Sent: Mittwoch, 19. Januar 2005 04:22 > To: maxdb@lists.mysql.com > Subject: UTF8 and UCS2 > > > Can MAXDB ODBC driver transfrom string data between UTF8 and UCS2? No, there is no such transformation. > > I stor

AW: Errors when no rows are updated

Hermann Himmelbauer wrote: > > Hi, > We are currently migrating our application from ADABAS-D 11 to MaxDB > (current > release). As MaxDB depends partially on ADABAS-D, this seems to be quite > simple. We access the database with Unix/Windows clients via ODBC. > > Now we have a problem with upda

Errors when no rows are updated

Hi, We are currently migrating our application from ADABAS-D 11 to MaxDB (current release). As MaxDB depends partially on ADABAS-D, this seems to be quite simple. We access the database with Unix/Windows clients via ODBC. Now we have a problem with update statements. On ADABAS-D update statement

Re: Can?t set Database ONLINE

bonjour, Le mercredi 19 janvier 2005, Mario Huetten a écrit... > I have a problem starting my database today. Yesterday evening the database > was shutdowned normal (i think so). I can set the database to state ADMIN > but cannot set the state to ONLINE. > Any Tips or Ideas ? I had this

RE: Can´t set Database ONLINE

There is a lot of log which is read and redone until the error occurs. This is very unusual for a normal restart after a shutdown. Please send me the following files dbm.utl, dbm.prt, knldiag.err, knltrace. Kind regards, Uwe >-Original Message- >From: [EMAIL PROTECTED] [mailto:[EMAIL PROTE

Re: [BUG] DBD::MaxDB with Windows linefeeds

thank you for reporting this. The newest Package available at cpan at http://search.cpan.org/~maxdb/DBD-MaxDB-7.5.00.24a should fix this problem. Is it always the way, that the newest module is awailable at CPAN instead of the MySQL-Download-Section? -- MaxDB Discussion Mailing List For list arc

Can´t set Database ONLINE

Hello, I have a problem starting my database today. Yesterday evening the database was shutdowned normal (i think so). I can set the database to state ADMIN but cannot set the state to ONLINE. Any Tips or Ideas ? Thanks in advance, Mario Huetten Here is my knldiag Message file: -

RAW devicenames under HP-UX

We're trying to setup a Test-/Benchmark system under HP-UX 11.23 to compare performance between HP-UX and SLES 9. To be as comparable as possible we'd like to use RAW devices under HP-UX as well, however, the installation routine does not accept the raw device names according to the Vertias documen

RE: Bad datapage

[...] 2005-01-19 01:59:15 28235 ERR 53021 B*TREE BAD FILE: 108 (ROOT) [...] Gives a hint where to look for. select * from roots where root = 108 You should use CHECK DATA to see if there are more bad pages in the system and you should check and perhaps exchange your hardware. There is no easy w

Bad datapage

Hi, today a "Bad datapage" caused an emergency shutdown right after the optimizer run this night. Do you have an idea how to solve this? Can I check to which table the bad datapage belongs to? Is it possible to repair it. bye Daniel 2005-01-19 01:59:09 28235 ERR 4 Data Checksum misma