RE: how to modify LONG column in DB procedure

Andre Sudhoff wrote : >Hi, >I want to concatenate the content of several LONG columns of different tables and >store it in a LONG column of another table. How can I do it within a DB procedure ? >Thank you in advanced Sorry, but access to LONG columns inside DB procedures is not possible. Best

RE: loader (loadercli) with .sql file

Hi Niraj, ".sql" file contains SQL statements? If so, use sqlcli. After going into sqlcli, use \i to specify your input SQL file. Hope this helps. Regards, Andy -Original Message- From: Shah, Niraj [mailto:[EMAIL PROTECTED] Sent: 2004?3?24? 2:42 To: MaxDB (E-mail) Subject: loader (lo

RE: Question About Locks?

Hi Jose, >From my test on MaxDB 7.5.0.8, your desired behavior can be "partially" achieved by >using isolation level 15. I mean "partial" because when T1 attempts DML (Insert, Update, Delete) later - to the "locked" row or other rows, to the same table or other tables - there is an automatic l

MySQL Users Conference: New mailing list for those interested in the event

Greetings All! We have setting up a mailing list for people who are interested in the MySQL Users Conference (http://mysql.com/events/uc2004/) If you are attending, planning to attend or want to know more about the event, we urge you to join this list by visiting http://lists.mysql.com/list.ph

Question About Locks?

Hi: I have two connections with isolation level = 0. In the two connection I will update the same table row. The first connection with Transaction T1 update the table row and after of execute the update statement assign an EXCLUSIVE lock to this row. The second connection with Transaction

MySQL Proxy for MaxDB

Has anyone installed and tried using the MaxDB alpha version 7.5.01? We want to begin to use the interoperability feature for MySQL and MaxDB, but have been unable to find any documentation on how to configure it. Can anyone help with this? Thanks, __

loader (loadercli) with .sql file

Hi All; I am new to MaxDB. Is it possible to use loadercli.exe to load .sql file? If so what can someone provide me an example? Thanks Niraj -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

General advise to deal with "-904 table space exhausted...."

Hello All: Is there any document/URL available providing tips to avoid the "Table space exhausted..." error in SAPDB 7.4? I have searched thru this list and google, and can't find a clear answer to this problem. So far all I got is this: 1.- There is a problem with the JOIN algorithm used by SAPD

Read .sql file

Hi; How do we read .sql file into MaxDB? Can we use DB Manager or SQL Studio to generate Database? I am working on Windows 2000. Thanks in advance Niraj -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Segmentation fault error with libsqlod.so

Hi Zavier > -Original Message- > From: Zavier Sheran [mailto:[EMAIL PROTECTED] > Sent: Dienstag, 23. März 2004 12:19 > To: maxdb > Subject: Segmentation fault error with libsqlod.so > > > I can connect with isql to the database but as soon as I run > a query I get a segmentation fault e

AW: restore problem

> -Ursprüngliche Nachricht- > Von: Stephan Rusch [mailto:[EMAIL PROTECTED] > Gesendet: Dienstag, 23. März 2004 13:25 > An: [EMAIL PROTECTED] > Betreff: restore problem > > > Hello, > i have MaxDB 7.5 installed on a Sun Solaris 9 - system > and SapDB 7.3 installed on a Suse Linux 8.1 - sy

restore problem

Hello, i have MaxDB 7.5 installed on a Sun Solaris 9 - system and SapDB 7.3 installed on a Suse Linux 8.1 - system. Now when i´m trying to restore a db-instance of the SapDB-system to the MaxDB i get the following error-message: recover_start completeF DATA ERR -24988,ERR_SQL: sql error -9030,Sys

Re: Segmentation fault error with libsqlod.so

Le mardi 23 mars 2004, Zavier Sheran a écrit... bonjour, bonjour, > Any ideas? I saw others having similar problems, but none of the > solutions in the archives worked for me... isql is part of unixodbc, isn't it ? Have you tried the latest (compiled from source) driver

RE: Date insertion

Paul W. Reilly wrote: > > MaxDB Community Member, > > I have been trolling through all the post and documentations > and am not > having much luck with finding the proper way to handle date insertion. > > When I do this: insert into temp_x (date_) values ('2004-10-04') > it works fine, but I wo

Segmentation fault error with libsqlod.so

I can connect with isql to the database but as soon as I run a query I get a segmentation fault error in isql. When using Apache with php_mod I also get a segmentation fault error (using Redhat 9): [Mon Mar 22 22:19:47 2004] [notice] child pid 23458 exit signal Segmentation fault (11) [Mon Mar

how to modify LONG column in DB procedure

Hi, I want to concatenate the content of several LONG columns of different tables and store it in a LONG column of another table. How can I do it within a DB procedure ? Thank you in advanced -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe:ht

Re: Date insertion

Le lundi 22 mars 2004, Paul W. Reilly a écrit... bonjour, > Does anyone have the answer I can't find? Is there something I missed in > the docs? special database parameter DATE_TIME_FORMAT as ISO ? -- jm -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/max

RE: Waiting for Transactions to finish

In fact this behaviour changed during the builds of 7.4. For current builds and releases >=7.4* is valid that db_offline causes a last savepoint with reason "shutdown" (protocolled in knldiag) which of course can contain open transactions. When the savepoint is finished the kernel is stopped. The r

RE: MaxDB JDBC & inner queries

This one turned out to be a kernel bug present in MaxDB 7.5.0.5 and should be fixed in 7.5.0.6 I just updated the MaxDB version to 7.5.0.8 and everything works fine now. Regards, Andreas Schroeder -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: