Re: A non-existing function call doesn't generate any error

Hi Elke & Thomas, Thank you very much for your fast clarification. Now I know a little more ;-)) Thanks again, Marcin "Anhaus, Thomas" <[EMAIL PROTECTED]> napisal w wiadomosci news:[EMAIL PROTECTED] > Marcin wrote : > > >Hello, > >I just would like to let you know, that I've noticed > >SAP DB is

dbmcli and DROP DBPROC

bonjour, Having read the mail concerning named_select_statement, I decided to modify a dbproc: first drop it with: dbmcli -d DATABASE -uSQL jm,passwd -c "sql_execute drop dbproc dbprocname" dbmcli says 'OK' then tried to load the new dbproc: loadercli -d DATABASE -u jm,passwd -b dbproc.

RE: Universal Unique Identifier

[EMAIL PROTECTED] wrote: > > > Is there any function in MaxDB that operates similar to > MS-SQL's NEWID() > function? The NEWID() generates a globally unique identifier. To make clear what confuses me at the first moment: 'globally unique identifier' is not meant to create something like a name

RE: new

Molieri, Sergio wrote: > > > How does this forum work? > Have a look in the archives http://lists.mysql.com/list.php?list=maxdb#b to see questions and answers and discussions about topics around MaxDB sent back and force. Usually one starts a topic (asking for some help, giving some info about

Get stuck in recover_config then fail to build standby

Hi all, In following the documentation to set up a Homogenous System copy, I hit the following error and would like to get some help from the gurus. Prod instance = prod (running) Stand-by instance = stby Platform = Linux dbmcli -d prod -u dbm,dbm medium_put databasecopy /u01/prod_copy FILE DA

RE: MaxDB 7.5 - performance - Indexes, Joins and optimizer

Some more thoughts on this topic. Let's say I have a table: CREATE table1 primarykeyinteger INTEGER PRIMARY KEY, timestamp1 TIMESTAMP, payload1 VARCHAR(128), payload2 VARCHAR(128) CREATE INDEX myindex1 ON table1 (timestamp1) According to tests with EXPLAIN, I found that the number of

Re: MaxDB and Linux 2.6.x

i've problems running MaxDB on Linux kernel 2.6.x. It's not possible to get the database into ADMIN state. I've tried to create the database with commands: It not Linux 2.6, it's your glibc which has been compiled with NPTL support. glibc will use NPTL threads on Linux 2.6 and Linuxthreads on Lin

How to create a hot standby via dbmcli ?

Hi all, I've been using Oracle for long but a newbie to MySQL/MaxDB. I'd like to create a hot standby on Linux platform. I've been following the documentation but not getting very far before I get stuck (about mid-way through creating the homogenous copy). Would be very appreciate if someone

Re: MaxDB and Linux 2.6.x

On Tue, 2004-02-10 at 16:08, Martin Perina wrote: > Hello, > > i've problems running MaxDB on Linux kernel 2.6.x. It's not > possible to get the database into ADMIN state. I've tried > to create the database with commands: [EMAIL PROTECTED]:~$ LD_ASSUME_KERNEL=2.4.22 x_server -Y start 12902

Re: JDBC problem (no suitable driver exception)

George Pagomenos wrote: String driverName="com.sap.dbtech.jdbc.DriverSapDB"; Connection databaseConnection = null; String url = "jdbc:odbc:"; Use "jdbc:sapdb:" instead. See http://www.mysql.com/documentation/maxdb/fe/68e343cc68414da4426258d3e896ae/frameset.htm for a complete example. The jdbc:od

new

How does this forum work? BM__MailAutoSigSergio Molieri SAP Basis Admin. (256) 217-1266 [EMAIL PROTECTED]

JDBC problem (no suitable driver exception)

Hi all, I installed the latest version of MAXDB software at my PC (Win2000) and I create a "dummy" instance called TEST. Then with the sql studio I create a table named TEST_TABLE. My goal was to make a java program in order to execute sql queries to the DB, but I didn't manage to succeed. More

RE: A non-existing function call doesn't generate any error

Marcin wrote : >Hello, >I just would like to let you know, that I've noticed >SAP DB is acting really strange when non-existing function >is used in SELECT clause. >For example: >SELECT SILLY_NAME_OF_FUNCTION(MY_COLUMN) FROM MY_TABLE, >returns all rows from MY_TABLE for column MY_COLUMN. >IMHO som

RE: Getting "cannot load lib sdbrun.dll"-error when installing SA PDB 7.3.0.46

> Problem is that > ftp://ftp.sap.com/pub/sapdb/ > doesn't allow to log as anynomous user. The FTP server is now open for anonymous users. Daniel Dittmar -- Daniel Dittmar SAP Labs Berlin [EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To uns

RE: A non-existing function call doesn't generate any error

news wrote: > > Hello, > I just would like to let you know, that I've noticed > SAP DB is acting really strange when non-existing function > is used in SELECT clause. > For example: > SELECT SILLY_NAME_OF_FUNCTION(MY_COLUMN) FROM MY_TABLE, > returns all rows from MY_TABLE for column MY_COLUMN. > I

Universal Unique Identifier

Is there any function in MaxDB that operates similar to MS-SQL's NEWID() function? The NEWID() generates a globally unique identifier. Thanks, Kevin -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

When the Ferrari turns into Mini (?????)

Hi ppl I've created a database in SAPDB v 7.4 After i create about 10 tables some with 100 records, some with 1 records... the sum is about 4 records. Then, I run the process again... The process drops the tables if they exist and reload data into tables. The first time i've done this pr

AW: AW: embedded SAP DB / unattended installation

Hi Mark, thank you very much for your feedback, this helps a lot. regards, Axel > -Ursprüngliche Nachricht- > Von: Mark Johnson [mailto:[EMAIL PROTECTED] > Gesendet: Dienstag, 10. Februar 2004 15:30 > An: [EMAIL PROTECTED] > Cc: 'Matthias Griem'; [EMAIL PROTECTED] > Betreff: Re: AW: e

MaxDB and Linux 2.6.x

Hello, i've problems running MaxDB on Linux kernel 2.6.x. It's not possible to get the database into ADMIN state. I've tried to create the database with commands: dbmcli db_create PORTAL dbm,XXX dbmcli -d PORTAL -u dbm,XXX -i portal-db.ini The portal-db.ini file contains: param_startsession par

A non-existing function call doesn't generate any error

Hello, I just would like to let you know, that I've noticed SAP DB is acting really strange when non-existing function is used in SELECT clause. For example: SELECT SILLY_NAME_OF_FUNCTION(MY_COLUMN) FROM MY_TABLE, returns all rows from MY_TABLE for column MY_COLUMN. IMHO some error that the given f

Problem with DBFunctions, resulting General error;-5014 POS(200) Missing definite column name:

Hi again, sorry for the mailing. It would be great, if someone could help me. Is it a bug of MaxDB? [EMAIL PROTECTED] wrote: Hi, I created the following db function and tried to use it in a couple of select statements and other db functions. I don't know what is wrong, but sometimes the resul

Re: AW: embedded SAP DB / unattended installation

Alex, We do a similar procedure in a Linux RPM, Solaris package, and a Windows InstallShield script using method "a" below. The problem with method "b" is getting all the registry setting and file setting correct and updates when a version changes (many of the settings change). You also need

RE: Getting "cannot load lib sdbrun.dll"-error when installing SA PDB 7.3.0.46

> Problem is that > ftp://ftp.sap.com/pub/sapdb/ > doesn't allow to log as anynomous user. We informed the sysadmin and hope that access to the FTP server will soon be available again. Daniel Dittmar -- Daniel Dittmar SAP Labs Berlin [EMAIL PROTECTED] -- MaxDB Discussion Mailing List For lis

Re: Getting "cannot load lib sdbrun.dll"-error when installing SAPDB 7.3.0.46

Problem is that ftp://ftp.sap.com/pub/sapdb/ doesn't allow to log as anynomous user. Have you changed the policy? Could you give us some id and password? Best regards, Marcin Uzytkownik "Schmoger, Daniel" <[EMAIL PROTECTED]> napisal w wiadomosci news:[EMAIL PROTECTED] hi, there is a bug in this d

RE: Getting "cannot load lib sdbrun.dll"-error when installing SA PDB 7.3.0.46

hi, there is a bug in this distribution package. it's fixed now here: ftp.sap.com/pub/sapdb/bin/win/sapdb-all-win-32bit-i386-7_3_0_46.zip or with this patch (copy dlls into sdbinst directory): ftp.sap.com/pub/sapdb/bin/patch/sdbinst-win32-patch-7.3.00.46.zip sorry, daniel > -Original Mess

sapdb installer from sapdb.org does not work

Hi, The sapdb 7.3.46 (latest) installer linked from the sapdb.org 7.3 page does not work. ftp://ftp.sap.com/pub/sapdb/bin/win/sapdb-all-win-32bit-i386-7_3_0_46.zi p The error is cannot load lib C:\sdbinst\sapdb-all-win-32bit-i386-7_3_0_46\..\install\sdbrun.dll There was a similar problem with

AW: embedded SAP DB / unattended installation

Hi Matthias, thank you for your comment. However, that was not what I wanted to know. Maybe my request was not clear enough. I would like to integrate the SAP DB _installation process_ within another installation routine for one of my software products that utilizes SAP DB. To accomplish this,

RE: Error -24988 seting Log Mode to Single/Off

> -Original Message- > From: news [mailto:[EMAIL PROTECTED] On Behalf Of Joao > Sent: Tuesday, February 10, 2004 1:08 PM > To: [EMAIL PROTECTED] > Subject: Error -24988 seting Log Mode to Single/Off > > > Hello > I'm getting this error when I try to set Log Mode to Single/Off > > Error

Error -24988 seting Log Mode to Single/Off

Hello I'm getting this error when I try to set Log Mode to Single/Off Error: -24988 sql error [util_execute SET LOG DEVSPACE OFF]; -3008,Message not available After that the database stays in ADMIN state... and when i force to put it online the log mode back to ON again. Note: SapDB 7.4 OS : AI

RE: Error in SQLStudio by execution of invalid dbprogs??

Auer, Wolfgang wrote: > > Hello Peter, > > for cursor names > 64 characters SQL Studio throws the error > -2014 POS(6) Identifier too long. > If the cursor name is between 32 and 64 characters the kernel > does not throw an error. > The webpts error is > http://www.sapdb.org/webpts?wptsdetail=

Re: embedded SAP DB / unattended installation

Am Dienstag, 10. Februar 2004 09:17 schrieb Axel Busch: > Hi, > > i would like to use SAP DB in a kind of embedded environment. > Does SAP DB provide a method of unattended/automatic installation? > > I checked the installation log for windows. Is copying the > files, setting the windows registry k

RE: RE: Problems with DATAUPDATE

Hi Steffen, I tried the following: -- File: fill_table.sql -- DATAUPDATE TABLE MyTable MyFirstPrimaryKey 1 MySecondPrimaryKey 2 SET MyLongTextField 3 INFILE '\path\to\my\file\MyFile.data' COMPRESSED LONGFILE MyLongTextField BI

RE: Error in SQLStudio by execution of invalid dbprogs??

Hello Peter, for cursor names > 64 characters SQL Studio throws the error -2014 POS(6) Identifier too long. If the cursor name is between 32 and 64 characters the kernel does not throw an error. The webpts error is http://www.sapdb.org/webpts?wptsdetail=yes&ErrorType=0&ErrorID=1127676. Regards

RE: RE: Problems with DBEXTRACT and DBLOAD

- Original Nachricht Von: "Schildberg, Steffen" <[EMAIL PROTECTED]> An: [EMAIL PROTECTED] Datum: 03.02.2004 16:31 Betreff: RE: Problems with DBEXTRACT and DBLOAD Hi Steffen, I tried out the workaround you explained below. It works as promised, i.e. only one file "data.out" i

loading binary data into table -- beginner

Hello, i'm new to maxdb and databases and trying to learn both at the same time. i have a table, as shown below and would like to load a couple of mp3 files in this table: CREATE TABLE "DBA"."BINARIES" ( "BINARYID" IntegerNOT NULL DEFAULT SERIAL (1), "BINARY

mailing list support

Hi, Saw the main page of sapdb.org. This says that support for 7.3 / 7.4 will be available only to sap customers after march 2004. Does this apply to questions on this mailing list too? Regards, Ajit -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe

RE: Problems with DATAUPDATE

Hi Christian, Christian Herrmann [mailto:[EMAIL PROTECTED] wrote: [snipped working DATAUPDATE example] > > In another table I've got a compound primary key and that > triad build up the > > SQL-statement as follows: > > --- > File: fill_table.sql > ---

embedded SAP DB / unattended installation

Hi, i would like to use SAP DB in a kind of embedded environment. Does SAP DB provide a method of unattended/automatic installation? I checked the installation log for windows. Is copying the files, setting the windows registry keys and adding the entries to the services file really enough? H

Re: Getting "cannot load lib sdbrun.dll"-error when installing SAPDB 7.3.0.46

Hi, this question was already asked two times, but no answers so far. I think the 7.3.X series is somewhat uncared-for. maybee because of the 7.5 aka maxdb. this seem only to happen on windows... regards Andre -- Andre Seidelt Softwareentwicklung EWS-18 BIOTRONIK GmbH & Co. Woermannkehre 1