Re: maxdb python inserting lobs

Luca Calderano wrote: insert = req.session['cnn'].prepare("""INSERT INTO "GestionePratiche"."PrevisioniNote" VALUES ( DEFAULT , %s, ?, '%s', '%s', DEFAULT , DEFAULT , DEFAULT ) """ % (req.session['CL'], dataRif, dataReg)) insert.execute([str(note)]) return "Dati inviati al server" w

Re: Please help me with unicode problem

이민우 wrote: > I use python interface module, and I use that very well. > But I have a problem when I excute insert command. > There are some Korean in that query sentence. > After I excuted that command, the characters was not shown normaly. > I tried many times to find what's the problem. > I concl

Re: maxdb python inserting lobs

Luca Calderano wrote: Can someone explain me how to insert data into lob fields using the maxdb python interface? Use prepared statements (http://dev.mysql.com/doc/maxdb/en/20/512a7c5647e64a863683cc6333617b/frameset.htm) As the parameter passed to the execute method, you can use either - a

Updates to CVS server

is also available and updated daily: cvs -z9 -d :pserver:[EMAIL PROTECTED]:/cvsroots/sapdb c -P -d maxdb-dev Daniel Dittmar -- Daniel Dittmar SAP Labs Berlin [EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe:http

Re: Solaris/x86_64: loading system tables

s /misc/sapdb/python-py15/loadermodule.so. Things to check: $ x_python >>> import sys >>> sys.path Is /misc in the list that is printed? Does /misc/sapdb/__init__.py exist? If /pgm/python is of version 2.3, then it will search for the module in python-py23 and not in python-py15 (a link

Re: Performance in like queries

ve reached 'im' and you're done. If you're looking for all words *containing* 'in', you have no other choice but to start with the first word of the dictionary and to read every entry. Other kind of indexes are imaginable that keep track of substrings as well (fu

Re: BLOB's BLOB's and Blob's

, you have to implement the details yourself (setting HTTP headers like Content-Size and MIME type, serving only parts) - you could use a few tools that work only with filesystem like fulltext search or version control software Daniel Dittmar -- Daniel Dittmar SAP Labs Berlin [EMAIL PROTECTED] --

Re: Python interface for Linux on PowerPC

Uwe Hentzschel wrote: Are there any binaries to use on Linux ( PowerPC ) or how can i build the interface from source. Do you need them 32bit or 64bit? Daniel Dittmar -- Daniel Dittmar SAP Labs Berlin [EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com

Re: How do I get x rows after ordering and grouping?

ou to position to a specific record. And if you give a negative index to these methods, the position from the end of the result set is used. By positioning to row -20, you would read the last 20 rows. Daniel Dittmar -- Daniel Dittmar SAP Labs Berlin [EMAIL PROTECTED] -- MaxDB Discussion Mailing

Re: no nntp accsess

/gmane.comp.db.maxdb. But I'll notify the lists.mysql.com administrator. Daniel Dittmar -- Daniel Dittmar SAP Labs Berlin [EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: weirds problems after upgrade from 7.5.00.18 to 7.5.00.19

around this problem by issuing a resultset.first () before the first .next (). Daniel Dittmar -- Daniel Dittmar SAP Labs Berlin [EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Server Side Stored Procedures/Functions: Other language's?

ntroduce a beta version for Java Stored Procedures during the 7.6 releases, with Python and possibly other languages following. Daniel Dittmar -- Daniel Dittmar SAP Labs Berlin [EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscrib

Re: documentation for all maxdb_xxx functions for php ?

examples have to be transalted to MaxDB syntax, that's why the documentation hasn't been released yet. Daniel Dittmar -- Daniel Dittmar SAP Labs Berlin [EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe:http://lists.mysql.

Re: Remote acces to SAP DB

Bubak, Michal wrote: I have a question on remote access to SAP DB. Is it possible to restrict remote access to DB only with DB settings? Which system table should be use and how to do it? There are no such capabilities, you can restrict remote access only through a firewall. Daniel Dittmar

Re: Automatic DB start

gram xuser - use that key to call dbmcli -U , that way, the password doesn't appear. But the container for the xuser entries is user specific. So you have to find a way to store these entries for the SYSTEM user or you have to run the service with you own user. Daniel Dittmar -- Daniel Dittm

Re: Backup question

, but not the other way round. Daniel Dittmar -- Daniel Dittmar SAP Labs Berlin [EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MaxDB + Zope: MySQL/SAPDB-Database Adaptor

the features of 7.5.01. Daniel Dittmar -- Daniel Dittmar SAP Labs Berlin [EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Long data type and trigger OLD value

red out a way to work around this limitation? Do an INSERT INTO ANNOUNCEMENT_HISTORY SELECT ANNOUNCEMENT_GID, BODY FROM ANNOUNCEMENT WHERE ANNOUNCEMENT = :OLD.ANNOUNCEMENT_GID inside the trigger. That way, the trigger never sees a LONG value. Daniel Dittmar -- Daniel Dittmar SAP Labs Berlin

Re: MaxDB + Zope: MySQL/SAPDB-Database Adaptor

t MaxDB is now fully compatible with the MySQL call interface. Which of these 2 variants is the better one? What's the current status of the MySQL call interface of MaxDB? Both the MySQL proxy and the required MaxDB 7.5.01 are in alpha status. Daniel Dittmar -- Daniel Dittmar SAP Labs Berlin [

Re: Python 2.3 interface for MaxDB 7.5 ?

asn't changed, so there is nothing wrong with using the 7.4.03 driver. But yes, I should create the same package for 7.5. Daniel Dittmar -- Daniel Dittmar SAP Labs Berlin [EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscrib

Re: hibernate problem

dentifiers). Perhaps there is some field in the configuration file of Hibernate to force using these methods. Daniel Dittmar -- Daniel Dittmar SAP Labs Berlin [EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe:http://lists.mysql.

Re: CVS - has there been a change?

e entries for these files are missing), cvs would assume that it has to create these files locally and doesn't want to overwrite the existing ones. You could try to delete the whole directory src/in and update again. Daniel Dittmar -- Daniel Dittmar SAP Labs Berlin [EMAIL PROTECTED] -- M

Re: 7.5.0.8 leaves vserver running on shutdown?

independently. There's no harm done by simply 'forgetting' it on system shutdown. Databases on the other hand should be stopped cleanly by putting 'dbmcli ... db_offline' for each database into your shutdown scripts. Daniel Dittmar -- Daniel Dittmar SAP Labs Berlin [EMAIL PROTE

Re: SQL Studio: Newbie Question.... Multiple Statements in Sql Window...

ut what is the separator line??? Separator line means that // must be on it's own line. insert into // insert into ... Daniel Dittmar -- Daniel Dittmar SAP Labs Berlin [EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsub

Re: readline module for ireport

(ftp://ftp.sap.com/pub/sapdb/bin/linux/sapdb-python-linux-i386-7.4.03.33a.tgz). Daniel Dittmar -- Daniel Dittmar SAP Labs Berlin [EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: update...where current of with Python

sultSet through resultset.cursorName.__doc__. (setFetchSize() appears to be called in sapdb.dbapi within __handleResult()) True as well. You can replace innerCursor.setFetchSize (1) with cursor.fetchSize = 1 I'll add cursorName () and setFetchSize () to dbapi.py. Daniel Dittmar -- Daniel Dittmar SAP Labs Ber

Re: New User to MaxDB

disk, this could also block your PC as both swapping virtual memory or starting new programs also try to access the disk. Daniel Dittmar -- Daniel Dittmar SAP Labs Berlin [EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscrib

Re: JDBC and Struts

ows clause of a method. Daniel Dittmar -- Daniel Dittmar SAP Labs Berlin [EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Building MaxDB using the free MS C++ Toolkit.

programs. Daniel Dittmar -- Daniel Dittmar SAP Labs Berlin [EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: How do I use 'session number'?

e definition of sqlca and sqlda? There is a limit of eight connections (http://dev.mysql.com/doc/maxdb/en/e2/053c3d3a4b8c4ce1000a114084/frameset.htm) The Precompiler is not suited for multithreaded programs. Use ODBC or SQLDBC instead. Daniel Dittmar -- Daniel Dittmar SAP Labs Berlin [

Re: How to build binaries for Win32 - xserver

ted the change. The code for the patch to 7.5.00.8: http://www.IPCoast.com/xserver-dns-lookup-75008-patch.txt They've been integrated in 7.5.00 and up. They probably appear in 7.5.00.12 and later. Daniel Dittmar -- Daniel Dittmar SAP Labs Berlin [EMAIL PROTECTED] -- MaxDB Discussion Maili

Re: SunOS/x86 - MaxDB 7.5 - Patches

ou put some package on ftp.sap.com for creating installations (SDBINST etc.) Unfortunately they seem to have disappeared... Are they in the tree? I do not remember what it exactly was. They are in the directory sys/desc/install56 and sys/src/install56. Daniel Dittmar -- Daniel Dittmar SAP Labs

Re: Unix_TimeStamp

s not known. There is no function Unix_timestamp in MaxDB. Daniel Dittmar -- Daniel Dittmar SAP Labs Berlin [EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MaxDB and C#

://www.mysql.com/documentation/maxdb/a7/41ee17605911d3a98800a0c9449261/frameset.htm create dbproc MyNewData AS SELECT * FROM MyTable see http://www.mysql.com/documentation/maxdb/a7/41ee11605911d3a98800a0c9449261/frameset.htm about the details of creating stored procedures that return cursors. Daniel Dittmar

Re: dbmcli db_create executable program not accessible

e actual database kernel. Run $ /opt/sdb/programs/bin/dbmcli dbm_version and you'll see the that is picked by default, run $ /opt/sdb/programs/bin/dbmcli inst_enum to see all the local MaxDB installations. Daniel Dittmar -- Daniel Dittmar SAP Labs Berlin [EMAIL PROTECTED] -- MaxDB Di

Re: EXPLAIN output on 7.5.0.8 and ODBC connection pooling

DBC and the Python driver were too lazy to even look for a SELECT, so they expect the kernel to tell them the name of a possible result set in the return packet Daniel Dittmar -- Daniel Dittmar SAP Labs Berlin [EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.

Re: how can i connect to x_server usering SQL studio, when i changed sq16 port

version of SQLStudio be too old, then you could also change WINDIR\system32\drivers\etc\services. Daniel Dittmar -- Daniel Dittmar SAP Labs Berlin [EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: How to build binaries for Win32 - xserver

ronment going. I am also willing to put up a Wiki page for other Win32 hackers once I figure out how to get it going myself :) Just keep notes where something doesn't work as advertised and I update the documentation Daniel Dittmar -- Daniel Dittmar SAP Labs Berlin [EMAIL PROTECTED] -- MaxD

Re: SAP DB/MAX DB with Mono??

Marcin P wrote: I wonder I anyone have managed to connect to SAP DB from Mono framework?? There exists one project to support SAP DB / MAxDB from Mono: http://www.bytefx.com/Products.aspx I'm not sure what the state of the project is, tough. Daniel Dittmar -- Daniel Dittmar SAP Labs B

Re: varchar(n) question.

network In both cases, VARCHAR columns will often be padded to the defined size. This will have a negative impact on the performace of your aplications. Daniel Dittmar -- Daniel Dittmar SAP Labs Berlin [EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb

Re: MSI Installer

perl script that does anything that is necessary But we're currently developing a GUI installer for Windows and Unix/Linux. So if you only want a more user friendly interface to the installer, maybe you'll just have to wait a while. Daniel Dittmar -- Daniel Dittmar SAP Labs Berlin [

Re: unable to change state = online

; -, connection broken". A common error is to create too small a database. You should create a data volume of at least 20 MB. If this isn't the problem, please look into the knldiag for any error messages (http://sapdb.2scale.net/moin.cgi/knldiag). Daniel Dittmar -- Daniel

Re: Nested if statements in Stored Procedure

BEGIN END - use ; to separate stetments, not newlines http://www.mysql.com/documentation/maxdb/a7/41ee2c605911d3a98800a0c9449261/frameset.htm Daniel Dittmar -- Daniel Dittmar SAP Labs Berlin [EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To

Re: architecture and internal structure

/cvs.html, the documentation is in the subdirectory sys/doc of every release. Daniel Dittmar -- Daniel Dittmar SAP Labs Berlin [EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Sapdb commercial support

Dittmar -- Daniel Dittmar SAP Labs Berlin [EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: upgrading minor kernel versions

Ajit Aranha wrote: Hi, Can someone quickly give me info on updgrading my database kernel from 7.3.0.30 to 7.3.0.47. Just call SDBUPD instead of SDBINST and you'll get a menu of updatable databases. where is the kernel change log located?? http://www.sapdb.org/new_relinfo.txt Daniel Di

Re: [ MaxDB ] how do I delete the m750008 Services from Installation on Win 2000?

nager when they are needed. Daniel Dittmar -- Daniel Dittmar SAP Labs Berlin [EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MAXDB CURRVAL Question

/*code copied from another listing*/ CREATE TABLE TEST (k serial, s integer) INSERT INTO TEST SET s = 1 SELECT TEST.CURRVAL FROM DUAL is it guaranteed that it will return the id of the row that this chunk executed? CURRVAL will return the last value *generated in this session*. Daniel Dittmar -- Daniel

Re: Help! BIG Memoryleak in Pythondriver

} Thanks for tracking it down, I'll create new binaries. Daniel Dittmar -- Daniel Dittmar SAP Labs Berlin [EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Max db 7.0.1

Jean-Michel OLTRA wrote: No. We're slowly removing features to make it easier for MySQL to implement a replacment. A little bit more details ? Please don't make me elaborate on this joke too much. Daniel Dittmar -- Daniel Dittmar SAP Labs Berlin [EMAIL PROTECTED] -- MaxDB Discussi

Re: Kernel Shared Memory Segment not found

pplication fails at such a high level the log is never even started? That's a different kind of log. Daniel Dittmar -- Daniel Dittmar SAP Labs Berlin [EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe:http://lists.m

Re: Max db 7.0.1

a stable 7.5.01. Daniel Dittmar -- Daniel Dittmar SAP Labs Berlin [EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Kernel Shared Memory Segment not found

[EMAIL PROTECTED] wrote: I get this error when starting up the database. It says to look knldiag, but no file is written. There is the appldiag which states the same knldiag is described here: http://sapdb.2scale.net/moin.cgi/knldiag Daniel Dittmar -- Daniel Dittmar SAP Labs Berlin [EMAIL

Re: Update from tables?

José Rómulo Elías Contreras wrote: How can I do an update of a table usign values from different tables to set it? You can do a INSERT ... SELECT ... UPDATE DUPLICATES. Daniel Dittmar -- Daniel Dittmar SAP Labs Berlin [EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http

Re: cursors: behaviour questions

are the only way to 'fill a result set'. Daniel Dittmar -- Daniel Dittmar SAP Labs Berlin [EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Very Long connection Time...

ng tracert using the ip address. If the ping time is short, but the display of the host names takes a long time, then this could be the problem. Daniel Dittmar -- Daniel Dittmar SAP Labs Berlin [EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To u

Re: SapDB replication feature

Alexio Cassani wrote: Hi, I've found that SapDB doesn't provide any kind of replication feature (since 1997). Is this right? Yes. Such a feature is currently being implemented, but a release date hasn't been set. Daniel Dittmar -- Daniel Dittmar SAP Labs Berlin [EMAIL PROTEC

Re: SAP DB on Mac OS X, OpenBSD?

OS X port, the build tools would have to be ported first. And we're lacking in experts for autoconf to do this properly. Of course we are willing to help. Daniel Dittmar -- Daniel Dittmar SAP Labs Berlin [EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql

Re: JDBC problem (no suitable driver exception)

for a complete example. The jdbc:odbc: prefix would be required if you were using the JDBC-ODBC bridge (http://java.sun.com/j2se/1.3/docs/guide/jdbc/getstart/bridge.doc.html). You also don't have to install the MaxDB ODBC driver (odbc75.exe), sapdbc.jar is all that is required to connect usi

Re: Data type short LONG and long LONG

in one B* tree per table. Daniel Dittmar -- Daniel Dittmar SAP Labs Berlin [EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MaxDB and NPTL

releases supporting that platform. Daniel Dittmar -- Daniel Dittmar SAP Labs Berlin [EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MaxDB - DBMCLI + data loader on different platforms

.) I know there can be issues with backup/restore between platforms... so looking what else to expect. There is only the issue that it doesn't work, so using the Loader is the only possibility. Daniel Dittmar -- Daniel Dittmar SAP Labs Berlin [EMAIL PROTECTED] -- MaxDB Discussion Mailin

Re: MaxDB 7.5.0.8

last version I used but... If you have a Python compiled for 4byte unicode (like on RedHat 9), then using the Python module compiled for 1.5 is currently your only option. Daniel Dittmar -- Daniel Dittmar SAP Labs Berlin [EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list

Re: SAP::DBTech::loader => undefined symbol: Perl_safemalloc

misc/SAP/DBTech/loader.pm line 37 Compilation failed Try ftp://ftp.sap.com/pub/sapdb/bin/linux/sapdb-perl58-linux-i386-7.4.04.02a.tgz, this one is compiled for Perl 5.8. Daniel Dittmar -- Daniel Dittmar SAP Labs Berlin [EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list

Re: Removing Deletes

Patrick Lykins wrote: How do I force SapDB/MaxDB to purge all of the deleted items? This is not necessary. Space of deleted records is automatically recycled. Daniel Dittmar -- Daniel Dittmar SAP Labs Berlin [EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http

Re: sql error [sql_connect ...]; -901,Log full

: search for a file create_demo_db.sh or create_demo_db.cmd in your installation. This script contains these steps near the end, from medium_put to autosave_on. Daniel Dittmar -- Daniel Dittmar SAP Labs Berlin [EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http

Re: recovering database installation after relocating disks to another server.

starts, shredding of the original disks and other mishaps. Daniel Dittmar -- Daniel Dittmar SAP Labs Berlin [EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Update Query Error

61/frameset.htm), only a column_name is allowed, not a column_spec (http://www.mysql.com/documentation/maxdb/1b/2e97dbb42a11d2a97100a0c9449261/frameset.htm). Daniel Dittmar -- Daniel Dittmar SAP Labs Berlin [EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com

Re: MAXDB: SQLStudio multiple statements

oes not support multiple SQL statements. SQLStudio looks for // to break the buffer into multiple statements and sends them to the server. And as the last statement doesn't return a result set, SQLStudio says so. Daniel Dittmar -- Daniel Dittmar SAP Labs Berlin [EMAIL PROTECTED]

Re: tableload

William Chase wrote: Is there an example for loading a delimited file? I don't see what the SQL statement should be. Use the DATALOAD statement (http://www.mysql.com/documentation/maxdb/ec/d93fb9400d11d3aa27006094b92fad/frameset.htm) Daniel Dittmar -- Daniel Dittmar SAP Labs Berlin [

Re: MaxDB @ Fedora-Core-1 ERR-24994

died before reaching ADMIN state Look for error messages in knldiag: http://sapdb.2scale.net/moin.cgi/knldiag Daniel Dittmar -- Daniel Dittmar SAP Labs Berlin [EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe:http://lists.mysq

Re: MaxDB Problems with the Python SAP DB API

it might also be helpful to remove the comment signs in def wrapCall and send me the resulting trace (both from a working query and a faulty one). '# call, args' must be replaced by 'print call, args'You'll have to start Zope from the command line and redirect the out

Re: SDBINST vs. rpm

7;t the problem, please post the end of knldiag (http://sapdb.2scale.net/moin.cgi/knldiag). Daniel Dittmar -- Daniel Dittmar SAP Labs Berlin [EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Questions

roxy (http://www.mysql.com/downloads/maxdb-dev.html) - if you are already using the MaxDB proxy, please provide more information on which database you have installed and what connect parameters you're passing to the MySQL client Daniel Dittmar -- Daniel Dittmar SAP Labs Berlin [EMAIL PROTEC

Re: Announcement: New SAP DB CD-ROM

lems with Indian customs service in the past, so the SAP shop has removed this country (and a few others) from the list. If you send your me your address (including phone number), we'll try to get it to you anyhow. Daniel Dittmar -- Daniel Dittmar SAP Labs Berlin [EMAIL PROTECTED] -- Max

Re: SAP DB -24988 sql error

ose too small a data volume. 20 MB should be sufficient. If that isn't the reason, have a look at the knldiag (http://sapdb.2scale.net/moin.cgi/knldiag). Daniel Dittmar -- Daniel Dittmar SAP Labs Berlin [EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql

Re: MySQL or MaxDB or PostgreSQL or Interbase/Firebird or ?

MySQL ccommercial licence). Daniel Dittmar -- Daniel Dittmar SAP Labs Berlin [EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Build SAPDB-ODBC Driver for windows

.zip. This replaces two object files from the source archive, as tthe original files aren't compatible with VC 7 anymore. Daniel Dittmar -- Daniel Dittmar SAP DB, SAP Labs Berlin [EMAIL PROTECTED] http://www.sapdb.org -- MaxDB Discussion Mailing List For list archives: http://lists.mys

Re: ODBC-Problem with lowercase table names

talog functions or thrrough the table TABLES. Daniel Dittmar -- Daniel Dittmar SAP DB, SAP Labs Berlin [EMAIL PROTECTED] http://www.sapdb.org -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: cannot create reply fifo ( SAPDB 7.3.00.34)

knldiag could be also helpful, both when something unusual happens and when an instance won't come up. Daniel Dittmar -- Daniel Dittmar SAP DB, SAP Labs Berlin [EMAIL PROTECTED] http://www.sapdb.org -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsub

Re: Sapdb 7.5 Release

e've had the same kind of problems with 7.3 => 7.4. (which is an explanation, not an excuse :-) Daniel Dittmar -- Daniel Dittmar SAP Labs Berlin [EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Future official MaxDB FreeBSD port?

into our sources. This hopefully makes it easier to keep the port current as patches won't have to be updated when a new version comes out. And this will perhaps entice other BSD users to test and enhance the port. Daniel Dittmar -- Daniel Dittmar SAP DB, SAP Labs Berlin [EMAIL PROTECTED]

Re: different ALTER statements for modifying nullable?

.2scale.net/moin.cgi/VTrace). The trace probably won't be obvious, as SQL Studio will send lots of catalog queries, but if you search for ALTER and DROP, I hope you'll find it eventually. Daniel Dittmar -- Daniel Dittmar SAP DB, SAP Labs Berlin [EMAIL PROTECTED] http://www.sapdb.org

Shared SQL (was: SQL Injection risks...)

irements of the kernel should be less because of the sharing This is useful mostly for the scenario 'application server', where many sessions all execute the same application and therefor the same SQL. Daniel Dittmar -- Daniel Dittmar SAP DB, SAP Labs Berlin [EMAIL PROTECTED] http:/

Re: Inserting text larger than 8k into the sapdb 7,4

ore easily insert values with special characters 3. if you have multiple inserts, it is also way more efficient to prepare only once and execute many times with different parameters than to execute multiple odbc_do Daniel Dittmar -- Daniel Dittmar SAP Labs Berlin [EMAIL PROTECTED] -- MaxDB Di

Re: Can not connect 7.4.3.30thru JDBC

and start it (best, set also to Startup Type: Automatic) or (in a command window) net start XServer Daniel Dittmar -- Daniel Dittmar SAP DB, SAP Labs Berlin [EMAIL PROTECTED] http://www.sapdb.org -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscr

Re: AutoLog_option not set after reboot

That's described at http://www.faqts.com/knowledge_base/view.phtml/aid/19483/fid/1113 Daniel Dittmar -- Daniel Dittmar SAP DB, SAP Labs Berlin [EMAIL PROTECTED] http://www.sapdb.org -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe:

Re: Enhance DDL portability for SAPDB...

the LONG/LONG BYTE data type. I think that's already on some list, at least for SQL mode ORACLE (and someone suggested that we replace LONGs with Blobs entirely). But have you tried creating a domain? Daniel Dittmar -- Daniel Dittmar SAP DB, SAP Labs Berlin [EMAIL PROTECTED] http://www.sapd

Re: alter max row count...

tored and retreiveed, you can't use string functions or comparisons with them. Daniel Dittmar -- Daniel Dittmar SAP DB, SAP Labs Berlin [EMAIL PROTECTED] http://www.sapdb.org -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe:http://lists

Re: call dbproc within select statement

[EMAIL PROTECTED] wrote: Is it possible to call a dbproc within a select statement. 7.5 adds the possibility to define user defineed functions which can execute SQl, if that's what you need. Daniel Dittmar -- Daniel Dittmar SAP DB, SAP Labs Berlin [EMAIL PROTECTED] http://www.sapd

Re: Enhance DDL portability for SAPDB...

Kevin Wilson wrote: Actually, a better feature request would be a function(s) that allows you to search a long varchar field for text patterns. Adding a synonym for a type is a very minor change, but adding string functions to LONGs is a major effort. Daniel Dittmar -- Daniel Dittmar SAP DB

Re: searching long varchar fields

, it should be possible to create a full text index on these columns using some index library, but until then ... Daniel Dittmar -- Daniel Dittmar SAP DB, SAP Labs Berlin [EMAIL PROTECTED] http://www.sapdb.org -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb

Re: MAN/OPT vs. nullable=yes/no

ule by inserting the default value? Exactly. Daniel Dittmar -- Daniel Dittmar SAP DB, SAP Labs Berlin [EMAIL PROTECTED] http://www.sapdb.org -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: UPPER with DBCS

means 'for unicode code characters with first byte 0x00' Daniel Dittmar -- Daniel Dittmar SAP DB, SAP Labs Berlin [EMAIL PROTECTED] http://www.sapdb.org -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: sapdb-test-sources on SLES7

ke targets built alright. Please try with the next steps in tests.readme, namely "Listing available test sequences". If you see any tests there, then you can continue. I will try to build the tests on a clean machine so that I can remove these dependencies. Daniel Dittmar -- Daniel

Re: Uninstalling 7.3.0

Yusuf Gangat wrote: Can anyone tell me the steps for uninstalling SapDB 7.3.0 or can you point me to the documentation? I fyou're on Windows, see http://sapdb.2scale.net/moin.cgi/WindowsUninstall for details. Daniel Dittmar -- Daniel Dittmar SAP DB, SAP Labs Berlin [EMAIL PROTECTED]

Re: How to see all SQL comands running on an instance in SapDB7.3

Clóvis Wichoski wrote: How to see all SQL comands running on an instance in SapDB7.3, like in Oracle view V$SQLTEXT? http://listserv.sap.com/pipermail/sapdb.general/2003-March/013827.html has some hints. Daniel Dittmar -- Daniel Dittmar SAP DB, SAP Labs Berlin [EMAIL PROTECTED] http

Re: problem in database instance

e_f) - connection broken" pls.consult for the above problem Look into the database console knldiag (http://sapdb.2scale.net/moin.cgi/knldiag) for any error messages. It is a common mistake to chose a data volume that is too small, use at least 20 MB. A future version of the DB Manager will pr

Re: read only

/f0dac7225811d3a97d00a0c9449261/frameset.htm => priv_spec => privilege Daniel Dittmar -- Daniel Dittmar SAP DB, SAP Labs Berlin [EMAIL PROTECTED] http://www.sapdb.org -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: sapdb-test-sources on SLES7

ven't tried yet to run the tests with a binary installation. Daniel Dittmar -- Daniel Dittmar SAP DB, SAP Labs Berlin [EMAIL PROTECTED] http://www.sapdb.org -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

  1   2   >