Mailing List
Home
Forum Home
MySQL General - General MySQL discussion
MySQL++ - Programming with the C++ API to MySQL
MaxDB - Everything about MaxDB, formerly known as SAP DB
ODBC - ODBC with the MySQL Connector/ODBC driver
MySQL on Win32 - Runing MySQL on Windows 9x/Me/NT/2000/XP
Java Help - Mostly related to the MySQL Connector/J driver
Perl - Perl support for MySQL with DBI and DBD::mysql
GUI - MySQL GUI Tools
Announcement
Subjects
Subject: mysql openssl Question
ERROR 1045: Access denied for user: 'root@localhost ' (Using
password: NO)
Update one field with more fields from another table
Subject: Getting Identity after INSERT
ERROR 2002: Can 't connect to local MySQL server through socket
mysql test 4 1 fails with the gis test
Subject: MySQL Cluster Software
Downgrade Mysql from 4 to 3 23
Mysql 4 0 Oracle Stored Procedure Trigger Conversion
Can 't access mysql after kernel upgrade
Executing MySQL Commands From Within C Program
Comparing and writing out BLOBS
Subject: Re: Preventing Duplicate Entries
FULLTEXT query format question
Strange behavior, Table Level Permission
Does the binary log enabling affect the MySQL performances?
mysql:it 's a db not a dbms how it 's possible?!
mysql have same function mthod as Oracle decode()
 
MaxDB
Page 115 of 129 Previous 100   Previous 10   111   112   113   114   115   116   117   118   119   120   Next 10  

How to check log devspace fill level

I have SAPDB 7.4.2.25 Since autolog backup to external backup tools (ADINT2 + TSM) does not exist I would like to implement my own via shell scripts. I would like to write a shell script that r

Ignore Trigger

We used ignore trigger for update triggers with SAPDB7.4. Now we use MAXDB and are not sure if this still works. And another generell question does a trigger wait for the end of a procedure call

Migration of dbmcli scripts from 7.3 to 7.4: sorry for doublette

sorry for sending it twice but I first received the following error >Sorry. Your message could not be delivered to > >MySQL List [Conference] (Mailbox or Conference is full.) R?dger --

Migration of dbmcli scripts from 7.3 to 7.4

Hello I 've got a lot of dbmcli scripts written for sapdb 7.3 and need to migrate them to 7.4. as some commands have changed. Does an overview of syntax changes exist or do I have to check it usi

Migrate dbmcli scripts from 7.3 to 7.4

Hello I 've got a lot of dbmcli scripts written for sapdb 7.3 and need to migrate them to 7.4. as some commands have changed. Does an overview of syntax changes exist or do I have to check it using

stuck with data export / restore

Hi! I just tried for some time to get my db from a SAPDB 7.4.3.30 to a new 7.5.0.1 Alpha 2. As I don 't have any more Ideas how to move my data any help would be appreciated When I create a Backu

Subject: dbproc privilege confusion

Hello The following situation confuses me Users A and B User A grant all privileges on all its tables to B - User B writes a select query on tables from user A - > result come back - Us

DB Error -2003 "Output columns too long " - Differences between Versions?

Hello Both statements below can be executed under Windows MaxDB 7.5 without problems. With Linux and SAP DB 7.4 a database exception occurs (-2003 "Output columns too long " JDBC). There se

DBMGUI error

Hi there I have installed version of DBMGUI 7.4.3.10. I am trying to register an instance of version 7.4.2.23 but get an error message "-4 communication error ". Please advise. Rgds Mark

dbm.py

bonjour I found a little bug in anydbm python 2.3 module. Called from apt-listchanges this module try to import some *dbm modules from this list _names [ 'dbhash ' 'gdbm ' 'dbm ' 'dumbd

Subject: EXPLAIN dies with an error

Dear MaxDB list The query "EXPLAIN SELECT l.* m.measurement m.date_taken FROM dbc_measurements m dbc_lakes l WHERE m.date_taken (SELECT MAX(date_taken) FROM dbc_measurements m2 WHERE m2.l

DBMGUI: Run-time error '340 ' with SAPDB / MAXDB

I 'm having a problem with the DB manager for SAPDB / MAXDB 7.5 after installing the ABAP stack of WebAS 6.40 running on Windows 2000 server. The SAP system itself is running fine. When I 'm trying to

JDBC and Struts

Hi I 'm trying to setup Struts 1.1 with a database connection using DBCP 1.1 to connect to a SAP DB 7.4 database. Unfortunately I get the following error during startup of Tomcat (5.0.19) S

Building MaxDB using the free MS C++ Toolkit.

Microsoft has made the command line tools of their C++ compiler available as a free download. It is currently not possible to build MaxDB with this compiler (see http //sapdb.2scale.net/moin.cgi

query optimizer bug

Hi This is a bug 7.3.0.46. Posting it incase it still exists in future versions. The query is in ORACLE mode Select * from some_table where pk_column some_sequence.currval This uses a

AW: discrepancy between backup history and db_restartinfo

Hi Filip during the recovery are savepoints written. Savepoints are bound to a specific position in the log resp. logbackup. For continuing the logrecovery it is necessary to continue at the pos

discrepancy between backup history and db_restartinfo

Hello I previously import all my available log backups with recover_start ARCH LOG 300 (for the first one) and recover_replace ARCH /var/maxdb/logs/arch 301 to 312 for the consequent ones. All w

Subject: moving dba responsibility

Hi to all we have a couple of dba 's (each resonsible for a set of applications). Each DBA administers a couple of - standard/resource users - some roles for privileges on application data

SAPDB reorganization

Hello There is a question about the Database reorganization after a large amount of data is deleted with SAPDB. When data is deleted does SAPDB execute the reorganization of the database a

Subject: Strange database erros

Hello I 'm running MaxDB 7.5.0.8 in a Windows XP after upgrading from MaxDB 7.5.0.5. After the upgrade process I did a database structure check and I 'm getting these erros in knldiagerr 2004

Error creating MaxDB instance and setting Params for existing MaxDB instance

Hello I 'm running the latest version of MaxDB 7.5.0 on a WinXP laptop. I 'm trying to setup a DB thru the DB Admin GUI and the another DB thru the command prompt interface. I 'm having issues wit

Shared SQL

Hi all Quick question Does Shared SQL ... 1) Perform caching by storing the compiled SQL Statement? Would this be similar to the way that using stored procedures speed things up? 2) Or Does

ireport.py shortcuts

bonjour I added some lines to ireport.py to get uppercases shortcuts because I 'm used to uppercase sql typing (and uppercase objects names). Good hack bad hack ? I don 't know just an ide

Trgiggers, Procedures and Transactions

Hi everyone! I am user of SAP-DB 7.4 and I will ask a few questions 1. I tried to use SUBTRANS BEGIN and SUBTRANS END in TRIGGERS and SQLStudio error checker reports an error where it ca

SYSDBA

Can someone please tell me specifically how to set the SYSDBA password? I did not find this in the archives or the documentation. Mitchell S. McKenzie Programmer Learning Environment & Interne

One last thing

Forgot to include that we are running MAXDB on RedHat Advanced Server 3 Mitchell S. McKenzie Programmer Learning Environment & Internet Services University of Nebraska Medical Center Phone 4

Autostart MAXDB

I have maxdb installed plus the webtools. How do I start the database engine on reboot? Thanks. Mitchell S. McKenzie Programmer Learning Environment & Internet Services University of Nebra

New to MAXDB

Hello We are currently using the current version of MYSQL as our production level database server for various applications. I have a few initial questions about MAXDB 1. Are there many or

Unit of "cache limit " JDBC driver parameter?

Hello list th documentation for the SAP DB JDBC driver (http //www.sapdb.org/7.4/jdbcSapdbcEng.html) lists among others the parameters "cache limit ". What unit is this paramter in - KB number

Subject: Building packages - ftp 'ing?

I 'm trying to build SDBINST packages out of the tree. I copied over the perl modules and installed XML Expat. Now the createPackage target does the following [...] 16-04-04 15 57 16 end o
Page 115 of 129 Previous 100   Previous 10   111   112   113   114   115   116   117   118   119   120   Next 10