RE: failure building from source for target kernel

Hi ! Im sorry for this stupid mistake ! Of course irconf has to be in the PATH as i found out. Sorry for this. regards Hermann On Fri, 2004-02-20 at 19:56, Hermann Mundprecht wrote: > I do have another problem when building the target cpc: > > irconf.lnk fast > ../obj/SAPDB/RunTime/RTE_IniFileH

DBM GUI/SQL STUDIO Security

Hello all, Does anyone know if the connection between DBM GUI/SQL Studio/Installation Wizard and XServer is encrypted? At least during authentication? I'd imagine that the password is encrypted just before it's sent, but I have yet to find any sort of definitive answer on this. Is there a plat

Re: Update on kernel Problem

tried that, even raised the shared memory. Is the LD_ASSUME_KERNEL discussed in the docs? [EMAIL PROTECTED] bin]$ cat /proc/sys/kernel/shmmax 104857600 [EMAIL PROTECTED] bin]$ echo $LD_ASSUME_KERNEL 2.2.5 [EMAIL PROTECTED] bin]$ ./dbmstart -d MYMAXDB ERR -24994,ERR_RTE: runtime environment error

RE: failure building from source for target kernel

Hi Daniel ! Thanks for the patch. It works and i will add it to the ebuild. To successfully compile the other targest i had to add the following files to the sources which i took from the CVS tree: /usr/incl/WINDOWS.H /usr/incl/sql.h /usr/incl/sqlext.h /usr/incl/sqltypes.h /usr/incl/sqlucode.h I

before insert somehow?

Dear All, Is it possible to do a before insert trigger in SapDB? I need to assign a value to a table column *before* inserting the row. My SapDB version is 7.4.3.27. Regards, -- Ertan Küçükoğlu [EMAIL PROTECTED] Ozler Plastik San. ve Tic. A.S. Tel: +90.212.676.6767 Fax: +90.212.676.8012 -- MaxD

Re: Update on kernel Problem

./dbmcli on MYMAXDB>db_start ERR -24994,ERR_RTE: runtime environment error 1,Check knldiag! Kernel died before reaching ADMIN state This is usually the case, if your glibc has NPTL enabled. Use the common LD_ASSUME_KERNEL workaround or if you're using gentoo: recompile glibc without USE="nptl".

RE: Newlines

Ok, I now got some kernel traces: This is from the MaxDB 7.5 database running on the Windows machine when using the Windows ODBC driver: REQUEST: ascii, full_swap, 70500-ODB (1 segment, len: 152) (13.5186 page 13) parse SEGMENT 1 (1 part, len: 152) internal, user_cmd

RE: Column name of NEXVAL from a sequence

Hello Herrmann, if 'the most other database systems' consists of Oracle, it would be possible convenient, but if you would have looked at e.g. MS-SQL and DB2, you would have found out that even the SEQUENCENAME.NEXTVAL notation is far from being common, not even speaking of the name of the NEXTV

Update on kernel Problem

I posted a couple of days ago with this problem ./dbmcli on MYMAXDB>db_start ERR -24994,ERR_RTE: runtime environment error 1,Check knldiag! Kernel died before reaching ADMIN state --- ./dbmcli on MYMAXDB> I Know the DB exists ./dbmcli>db_enum OK TEST/opt/sdb/7500 7.5.0.8 fastoffline T

Column name of NEXVAL from a sequence

Hi ! I would have a sugestion for the implementation of sequences in maxdb. It would be convenient if the column alias of the value returned would be NEXTVAL. This is common in the most other db-systems that i know and helps if you are working with the DB with something like a java framework that

RE: Solution: loadercli - Windows XP to Solaris, use user

Hi Stephen, [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] wrote: > > Ahh, progress! > :-)) > = Windows XP output START > > C:\>loadercli -n 192.168.0.150 > Loader Server Protocol File:'c:\program > files\sdb\data\wrk\loader.prt' > > loadercli>USE USER test test SERVERDB TST

Re: Sum(amount) query

Hi, What is the 'amount' datatype ? Fixed or Float ? How many row returns you're query ? if it's float, you can try : select sum(round(amount, 9, 2)) ... or try: select * from transactionfile where amount = 6.04 ;-) Damien. Yusuf Gangat a écrit: Hi guys I am having a bit of a problem. I have t

RE: python/perl goes GPL

> The new extensions modules python perl/goes GPL in the new > alpha 7.5.01 > how to find the conditions and costs of the commercial versions. If you want to redistribute the modules, but not the database, then I think this post by Zak Greant of MySQL AB is relevant: http://lists.mysql.com/maxdb

RE: Newlines

I already tried a SQL trace using the ODBC driver's tracing capabilities but all it seems to trace are UPDATE and SELECT statements, no INSERTs. I'm no waiting for DBM rights for the database. Thanks so far. Uli Stärk > -Original Message- > From: Dittmar, Daniel [mailto:[EMAIL PROTECTED

RE: dynamic temporary table names in a dbproc

Filip Sergeys wrote : >Hello, >I need to use temporary tables I my dbproc due to the need of updates >(updates on cursors are not possible) >Since the application that uses this dbproc uses connection pooling I >cannot be sure that after every execution the session is ended and >temporary table d

RE: Newlines

> But I'm wondering why the same thing works on a windows platform. Using http://sapdb.2scale.net/moin.cgi/ODBCTrace or http://sapdb.2scale.net/moin.cgi/VTrace, one could have a look at what actually does get sent to the kernel. Daniel Dittmar -- Daniel Dittmar SAP Labs Berlin [EMAIL PROTECT

Solution: loadercli - Windows XP to Solaris, use user

Steffen, Ahh, progress! = Windows XP output START C:\>loadercli -n 192.168.0.150 Loader Server Protocol File:'c:\program files\sdb\data\wrk\loader.prt' loadercli>USE USER test test SERVERDB TST ERR -25004 A connection to the database could not be established: 1 = database no

RE: Error when recovering logs

Thanks a lot! I've successfully get through the recover_replace within the same backup session. Just want to drill a bit further on the 2nd approach (which suits better my need). I've tried but get -71 on the second recover_start. dbmcli -d sdb2 -u dbm,dbm -uUTL -c recover_start archivelog LO

RE: Newlines

Thanks a lot Daniel, But I'm wondering why the same thing works on a windows platform. Uli Stärk > -Original Message- > From: Dittmar, Daniel [mailto:[EMAIL PROTECTED] > Sent: Friday, February 20, 2004 11:48 AM > To: 'Ulrich Stärk'; [EMAIL PROTECTED] > Subject: RE: Newlines > > > > We

RE: python/perl goes GPL

> licence say: > == licence begin GPL > Copyright (C) 2002-2003 SAP AG > > where is mysql in that all and why 2003 and not 2004, is that > mean that > sap not controlling license in 2004 as interfaces issued in 2004 The copyright of MaxDB stays with SAP. We just don't update the year stamp

RE: Newlines

> We run a PHP application which inserts freetext from a HTML > textarea field into an ASCII varchar field in our database. > The PHP application puts the content of that textarea field > in a query string and executes the query. MaxDB does not support newlines in CHAR literals. Use prepare/exec

RE: failure building from source for target kernel

> In file included from > /opt/install/maxdb/7.5.0/V75_00_08/MaxDB_ORG/sys/w\ > rk/incl/SAPDB/RunTime/RTE_Coroutine.h:86, > from RTE_Coroutine.cpp:34: > /opt/install/maxdb/7.5.0/V75_00_08/MaxDB_ORG/sys/wrk/incl/SAPD > B/RunTime\ > /RTE_SystemLinux.h:44: error: storage >class sp

RE: Occasional error message in ESQL/C application doing select,u pdate,select on a table row

Hi, normally the precompiler reparse the SQL command three times to solve the error -8. Please send me a precompiler trace from this situation. You can activate the Precompiler trace by setting the environment variable SQLOPT=-X or by using the irtrace tool. Regards Burkhard > -Original Messa

RE: Newlines

Hi Damien, I know that and it is not the problem here. It's newlines that aren't stored correctly not single quotes. Thanks anyway :) Uli > -Original Message- > From: GUITARD Damien [mailto:[EMAIL PROTECTED] > Sent: Friday, February 20, 2004 9:31 AM > To: Ulrich Stärk > Cc: [EMAIL PRO

RE: Newlines

Hi Wolfgang, I am not able to use SQL Studio to connect to the database on the Solaris server due to security reglementations within our company. Also the problem is not websql stripping \r\n but the ODBC driver (seemingly). I am not able to insert strings containing newlines from within our app

RE: loadercli - Windows XP to Solaris, use user

Hi Stephen, [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] wrote: > > > loadercli running on Windows XP talking to a Solaris 8 does > NOT behave the same as loadercli running native on Solaris! > > 1. Install MaxDB 7.5.0.8 on Windows XP, Install MaxDB 7.5.0.8 > on Solaris 8. > 2. create the demo

RE: Can't link tabled iin MS Access via ODBC to MaxDB 7.5.0.08 on Linux

Hi Derek, > -Original Message- > From: Derek Hinchliffe [mailto:[EMAIL PROTECTED] > Sent: Freitag, 20. Februar 2004 09:43 > To: [EMAIL PROTECTED] > Subject: Can't link tabled iin MS Access via ODBC to MaxDB 7.5.0.08 on > Linux > > > Hi all, > > I am trying to links tables in Access 2002

dynamic temporary table names in a dbproc

Hello, I need to use temporary tables I my dbproc due to the need of updates (updates on cursors are not possible) Since the application that uses this dbproc uses connection pooling I cannot be sure that after every execution the session is ended and temporary table deleted. It is also possible

AW: WebPTS

Hi, thanks for reporting the issue. Due to a migration of the server that unfortunately will consume a few more days of our attention the WebPTS is not in working order. We're sorry for the inconvenience. As soon as the migration is accomplished we send a short notice to the list. Cheers, Dani

Can't link tabled iin MS Access via ODBC to MaxDB 7.5.0.08 on Linux

Hi all, I am trying to links tables in Access 2002 using the MaxDB 7.5 ODBC driver (with a user DSN). If I set the SQL mode to INTERNAL, I can get a list of tables (and they look right, eg. DBUSER.TableName), but when I try and link it I get: ODBC--call failed [SAP AG][SQLOD32 DLL][MaxDB]Syntax e

RE: Newlines

Hi Uli, websql is removing \r\n from the sql command. It is a known bug (webpts error 1125984). It will be fixed in one of the next releases. Maybe for test purposes you could use SQL Studio. It does not remove \r\n. Regards Wolfgang -Original Message- From: Ulrich Stärk [mailto:[EMAIL

Re: Newlines

Hi, You must use PHP "addslashes" PHP function before insertion if the text contain single quote ( convert ' to \' ), use "stripslashes" PHP function after retrieve data statement ( convert \' to ' ), and use "nl2br" PHP function after retrieve data statement ( convert new line to html ) Dam