 | | | MaxDB | | CREATE DBPROC hotels_of_town (IN zip CHAR(5))
RETURNS CURSOR AS
$CURSOR 'HOTEL_CURSOR '
VAR new_variable INT
DECLARE $CURSOR CURSOR FOR
SELECT * FROM mona.hotel WHERE zip zip
FETCH INTO new_vHi Uli
this error is corrected with version 7.6.00.24 which is not published
yet AFAIK.
I could offer to provide you with a loader of that version to get over
this
problem. Let me know if this is accHi
this morning we upgraded our extranet production system from SAP DB
7.4.03.32 to MaxDB 7.6.00.16. Everything seemed to work fine until some
of our users reported problems when updating news itemsI have a fairly large table and queries are running pretty slow. I am
trying to run "Update Statistics MyTable ". I the following error.
---- Error I am trying to run update statistics on a table and get the following error.
Does anyone have any ideas what could be causing this? My queries are
running very slowly and as I understand it this may -----BEGIN PGP SIGNED MESSAGE-----
Hash SHA1
Hey all
I 'm going to patch the syncmangui code to support native mysql bi-di.
But before I do that I figure I should get maxdb to build. To that
end Hello list
I 'm trying to load data with loadercli my max-db version is 7.6.00.16
under SLES9.
I 'm using the SEQNO-clause for the field "GE_ID " running loadercli leads to an "Memory fault ".
OmittiHi
we tried to get DIAGNOSE ANALYZE to log SQL statements issued via
JDBC. So far we have been able to log only statement and session id
but none of the performance characteristics (records returneHi
I have this SP
CREATE DBPROC insert_error_recipient(
IN a_event_id FIXED(12)
IN a_recipient VARCHAR(64) )
AS
VAR
l_userid FIXED(9)
BEGIN
CALL get_or_create_user_id( l_userHello
I try to start my DB 's and only get the following error message
-24994 ERR_RTE runtime environment error
1 Cannot create ipc db directories for DB
I found a previous link (http //www.mysqltHi
i have a problem with dbmcli and xuser.
I created a new xuser
xuser -d PAC -U c -n sffha001 -u pacadm pacadm
XUSER Entry 4
Hello
we want to compile php 5.1.2 with the maxdb extension but several errors occured.
Is there any bugfix?
Hello
I guess that there is a bug that causes the above exception (error
message "[-3102] Invalid subtrans structure ") when a row containing a
column of type LONG is updated. But it seems that thHello List
we encountered the following problem
When we try to recover an Linux-Backup into a Windows-Instance we get the following message
- 24988 sql error [backup_restore_config full0] -90Hello all.
I 'm having a little trouble with the TABLESTATISTICS table in MaxDB
7.6.0.16. If I select * from TABLESTATISTICS I can see only tables whose
schema matches the connected user. Even iHi Folks
our MaxDB Instance ran quite well over the last weeks.
But on April 28th we encountered some problems
I recompiled php with the same sources and added the curl-functions.
Afterwards I I have a .Net service application that interfaces with our production
database (v7.6.0.12 on a separate server under Solaris 9) using the ODBC
data provider (System.Data.Odbc) in .Net framework v1.1.4Hi
can i activate the AutoLog without a inital backup?
Can i set a flag or table insert?
In this time we start a dummy backup to pipe with a cat to /dev/null.
But this need a lot of time. How canHi
I am a beginner in MaxDB issues.
My Problem is
I save data of requests from a server-system in one table. This table has
nearly 6 million rows. Now I want to aggregate this data. In this task I
Hello to the list.
We attempted to upgrade our SAP DB (ver 7.3.0.43)
instance to MAX DB (ver 7.5.0.23) and received the error listed below.
From what we have been able to tell this was an authorizHi
I have a customer that seems to believe that a MaxDB instance on a
Windows box is not properly shut down on system shutdown. He believes
that this causes excessive checking of data files on startI 'm running 7.4.3.32 and inconsistently get '-8000 SERVERDB must be
restarted ' usually when trying to update or insert with LONG VARCHAR or
LONG BYTE. Obviously the server db doesn 't need to be rest$ loadercli -v
Version 7.6.00.16
$ loadercli -d DB1 -u DBUSER1 *****
Loader protocol '/home/dba/.sdb/loader/log/loader.prt '
Loader packages '/home/dba/sdb/loader/packages '
Error connecting user DB <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN " >
<HTML > <HEAD >
<META http-equiv Content-Type content "text/html charset windows-1252 " >
<META content "MSHTML 6.00.2800.1106 " name GENERATOHello
we are actually migrating from Adabas D 11 to MaxDB 7.6.0.16 and are now
testing the PHP functions via ODBC on Linux (configured PHP 4.4.2 with
option "with-sapdb ... "). We are using the ODBC Help
When I execute DBM the backup of Log generates error to me -24925 it validates the parameters on
other systems that if they backup ok the Log. They can help me with this Thanks
Saludos
*Hi all
I have installed maxdb-scriptif-7.6.0.16-1 and
maxdb-python-linux-32bit-i386-7_6_00_16.tgz and SuSE Linux 9.2 and Python
2.4.3
I try to import the maxdb/sapdb modules via Python and get the Hi Folks
When I execute the following snap of code in python
c max.sql( "SELECT C.ID_STATUS_CHAMADA SE.ID_STATUS_CDR
R.ID_MOTIVO_REJEICAO COUNT(C.ID_CDR) FIXED(SUM(C.VR_CHAMADA) 18 5)
FROM CDRHi
we 're currently having strange performance problems with sapdb 7.3.0.48
on linux.
The amount of vserver processes is about 100 and this leads to
unacceptable response times to our application.
MaxDB 7.6.00.12
Delphi 7.1
ODBC 7.06.00
Hello
When I run my app but don 't use it for a while I get a "[MySQL
MaxDB][SQLOD32 DLL][MaxDB] Degree of derived table does not match column
list -1200 P |
|
|
