[7.6] SDBUPD for 7.5 instances

2005-02-11 Thread Florian Schmitz
hi there, is an migration of instances (from 7.5.00.23) with the beta possible? (New User-Concept etc). I've played around a bit with our toying-instances and encountered some trouble while loading the systabs (wrong user/password-combination for dba though the correct passwords where stated). T

[7.6] cannot create DB

2005-02-11 Thread Sven Köhler
hi, when i create a database with the DBMGUI, i get an error and i'm told to look into the knldiag. I found the following errors: ... 2005-02-12 03:48:4518 12929 TASKING Task T1 started 2005-02-12 03:48:45 1 ERR 11797 TEST pthread_attr_setstacksize(13602816) failed:22 2005-02-12 03:

Re: Updated: New version 7.6 (beta) of MaxDB software available n ow

2005-02-11 Thread Sven Köhler
OH THANK GOD ! "Functions LENGTH and SUBSTR for LOBs" F**k Yeah! -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

¿ How to call a DBPROC from another DBPROC with OUT parameters ?

2005-02-11 Thread tmxluisjorge . castro
Hello, I sent this message but it was rejected because of it seems SPAM!!! I am trying to send it again... I hope that it won´t be rejected... The question: I have this DBPROC that returns an OUT parameter: CREATE DBPROC TBW_MONEDA ( IN MES FIXED(2.0) , IN ANIO FIXED(4,0), IN ID_PAIS FIXED(3,

¿ How to call a DBPROC from another DBPROC with OUT parameters ?

2005-02-11 Thread tmxluisjorge . castro
Hi! I have this DBPROC that returns an OUT parameter: CREATE DBPROC TBW_MONEDA ( IN MES FIXED(2.0) , IN ANIO FIXED(4,0), IN ID_PAIS FIXED(3,0), IN IMPORTE FIXED(14,2), OUT IMP_MXN FIXED(14,2) ) AS TRY SELECTNU_TIPOCAMBIOUS FROM ADMACI.TC_MONEDAS WHERE NU_MES = :MES AND NU_A

RE: Updated: New version 7.6 (beta) of MaxDB software available n ow

2005-02-11 Thread Kevin Wilson
OH THANK GOD ! "Functions LENGTH and SUBSTR for LOBs" -Original Message- From: Montag, Marina [mailto:[EMAIL PROTECTED] Sent: Friday, February 11, 2005 9:00 AM To: [EMAIL PROTECTED]; maxdb@lists.mysql.com Subject: Updated: New version 7.6 (beta) of MaxDB software available now Hell

Updated: New version 7.6 (beta) of MaxDB software available now

2005-02-11 Thread Montag, Marina
Hello, A first version (beta) of MaxDB 7.6 has been released. The following features are included: - the released version of the Installation Manager (GUI) - schemas replace the user/user-group feature - the database size can be reduced now - parameters can be changed in the ONLINE operational mo

Recall: New version 7.6 (beta) of MaxDB software available now

2005-02-11 Thread Montag, Marina
The sender would like to recall the message, "New version 7.6 (beta) of MaxDB software available now". -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

UnixODBC hangle in first use

2005-02-11 Thread Edson Carlos Ericksson Richter
Hi! I'm evaluating the possibility for developing some apps in C++ using unixODBC accessing MaxDB (7.5.0.23). During tests I've found a little bug. To make clear what I'm doing, I've created a class that connect to database during a "open(char*, char*, char*)" method, and close connection and fr

New version 7.6 (beta) of MaxDB software available now

2005-02-11 Thread Montag, Marina
Hello, A first version (beta) of MaxDB 7.6 has been released. The following features are included: - the released version of the Installation Manager (GUI) - schemas replace the user/user-group feature - the database size can be reduced now - parameters can be changed in the ONLINE operational mo

RE: upper/lower case on table and column names

2005-02-11 Thread Dittmar, Daniel
>When creating tables, I've realised that MaxDB has converted >all of my lower >case table and column names to upper case. > >I know that there is a way around this of doing "SELECT field1 >AS 'field1', >field2 AS 'field2' FROM mytable as 'mytable'", but this seems >rather clumsy >and I wondered

RE: Error while doing a backup

2005-02-11 Thread Döhr, Markus ICC-H
> 2005-02-11 09:49:20 17674 ERR 11000 d0_aopen Error during > fork, Interrupted system call > 2005-02-11 09:49:20 17678 ERR 52012 SAVE error occured, > basis_err 3700 > > > A few days ago I increased the database parameter > "DATA_CACHE" to a value of 30. Could this be the problem? Ye

AW: upper/lower case on table and column names

2005-02-11 Thread Zabach, Elke
phil benson wrote: > > OS: Redhat Linux 9.1 > MaxDB 7.5 > > When creating tables, I've realised that MaxDB has converted all of my > lower > case table and column names to upper case. > > I know that there is a way around this of doing "SELECT field1 AS > 'field1', > field2 AS 'field2' FROM myta

MaxDB Installation Manager Download?

2005-02-11 Thread Thomas Steinmaurer
Hi all, the download link on http://dev.mysql.com/doc/maxdb/instupgrade.html for the MaxDB Installation Manager doesn't work. Has it been removed? Thanks, Thomas -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe:http://lists.mysql.com/[EMAIL PROTE

upper/lower case on table and column names

2005-02-11 Thread phil benson
OS: Redhat Linux 9.1 MaxDB 7.5 When creating tables, I've realised that MaxDB has converted all of my lower case table and column names to upper case. I know that there is a way around this of doing "SELECT field1 AS 'field1', field2 AS 'field2' FROM mytable as 'mytable'", but this seems rather c

Stange problem with a query on MaxDb 7.5.0.23

2005-02-11 Thread Fabrice Bourdel
how can i sent the 2 bzip files (data for the tables) ? -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Stange problem with a query on MaxDb 7.5.0.23

2005-02-11 Thread Fabrice Bourdel
the files... -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Stange problem with a query on MaxDb 7.5.0.23

2005-02-11 Thread Fabrice Bourdel
Hello, I have a strange problem with a query. One version with "id fields" work well, but it was for testing and i need a text field of the id. When i change the query to retrieve the text field, MaxDb block with this message : "General error;-8 POS(1) Execution failed, parse again" ... but the

Error while doing a backup

2005-02-11 Thread Patrick Buchinger
Hello list, we are using sapdb 7.3.24 on linux on a 32 bit processor. Backups are written into the filesystem (so no tape is used). Today the following error occured during the daily backup of one of our databases: ERR -24988,ERR_SQL: sql error -903,Host file I/O error In the knldiag.err the

Re: AW: crash during log recovery

2005-02-11 Thread Raimund Jacob
Brunzema, Martin wrote: hello Martin! Could you please generate and send the kernel-trace with the dbmcli-command trace_prot abkx By this command the readable form of the trace is generated, which contains (sometimes) some more information about the error. The file is located in the rundire