----- Original Message ----- From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, October 16, 2002 5:43 PM Subject: sapdb.general digest, Vol 1 #539 - 17 msgs
> Send sapdb.general mailing list submissions to > [EMAIL PROTECTED] > > To subscribe or unsubscribe via the World Wide Web, visit > http://listserv.sap.com/mailman/listinfo/sapdb.general > or, via email, send a message with subject or body 'help' to > [EMAIL PROTECTED] > > You can reach the person managing the list at > [EMAIL PROTECTED] > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of sapdb.general digest..." > > > Today's Topics: > > 1. RE: SQL statement generates a rowcount --ON select and using exec > uteQuery!!!! -And a JDBC bug(?)(was SQL statement generates a rowcount -- > ON select and using executeUpdate!!!! -And a JDBC bug(?)) (Paskamp, Marco) > 2. AW: SAPDB course development (Schnitker, Michael) > 3. RE: Error using replication manager (Schildberg, Steffen) > 4. Re: Possible bug in insert - empty string not allowed on coloumns with default? (Ralf Liebenow) > 5. Re: Delphi and SAPDB - ODBC only? (Gabriele Boccone) > 6. SAP on Linux/Debian (Gabriele Boccone) > 7. RE: SAPDB course development (=?iso-8859-1?Q?Peter_S=F6nnergren?=) > 8. Re: SAP on Linux/Debian (Laszlo Hornyak) > 9. Re: SAP on Linux/Debian (Richard Barrington) > 10. Re: Adding multi-schema support to SAPDB (Eric Jain) > 11. Re: SAP on Linux/Debian (Richard Barrington) > 12. RE: SAP on Linux/Debian (Stausberg, Markus) > 13. Oracle Trigger in Oracle Mode, Error -5015 (Rupsch, Alexander ECG) > 14. RE:Oracle Trigger in Oracle Mode, Error -5015 (Anhaus, Thomas) > 15. Re: SAP on Linux/Debian (Gabriele Boccone) > > --__--__-- > > Message: 1 > From: "Paskamp, Marco" <[EMAIL PROTECTED]> > To: "'ajit_cus'" <[EMAIL PROTECTED]>, [EMAIL PROTECTED] > Subject: RE: SQL statement generates a rowcount --ON select and using exec > uteQuery!!!! -And a JDBC bug(?)(was SQL statement generates a rowcount -- > ON select and using executeUpdate!!!! -And a JDBC bug(?)) > Date: Wed, 16 Oct 2002 12:00:49 +0200 > > Hi, > it's a known bug and already fixed. A new driver containing this fix is now available at: > source: ftp://ftp.sap.com/pub/sapdb/7.3/sapdb-jdbc-source-7.3.00.29a.jar > bin: ftp://ftp.sap.com/pub/sapdb/bin/java/sapdb-jdbc-bin-7.3.00.29a.jar > > Regards, > Marco > > > -----Original Message----- > > From: ajit_cus [mailto:[EMAIL PROTECTED]] > > Sent: Mittwoch, 16. Oktober 2002 08:04 > > To: [EMAIL PROTECTED] > > Subject: RE: SQL statement generates a rowcount --ON select and using > > executeQuery!!!! -And a JDBC bug(?)(was SQL statement generates a > > rowcount --ON select and using executeUpdate!!!! -And a JDBC bug(?)) > > > > > > Hi, > > Quick update. Tracked the problem to StatementSapDB.java > > -->method-->Private boolean cmdIsQuery(String sql) (an > > internal method used by executeQuery). For some reason if the > > query starts with a space it fails. (However this does not > > happen for all code paths.)Where in the driver is white space > > trimming supposed to occur? It seems I am somehow jumping > > over this section in my application code.(The white space > > trimming algo in the above mentioned method doesn't seem to > > be working) > > -Ajit > > _______________________________________________ > > sapdb.general mailing list > > [EMAIL PROTECTED] > > http://listserv.sap.com/mailman/listinfo/sapdb.general > > > > --__--__-- > > Message: 2 > From: "Schnitker, Michael" <[EMAIL PROTECTED]> > To: "'van Rooyen'" <[EMAIL PROTECTED]>, [EMAIL PROTECTED] > Subject: AW: SAPDB course development > Date: Wed, 16 Oct 2002 12:01:29 +0200 > > Hi, > > there will be a book in German at www.cul.de > > Regards > Michael > > -----Urspr�ngliche Nachricht----- > Von: van Rooyen [mailto:[EMAIL PROTECTED]] > Gesendet am: Mittwoch, 16. Oktober 2002 10:17 > An: [EMAIL PROTECTED] > Betreff: SAPDB course development > > Hi all > > I currently teach the subject Internet Databases which focuses on open > source databases. Up to now I have only taught MySQL and PostgreSQL, but > a friend introduced me to SAPdb about a month back. > > My question is: is there any training available for SAPdb? Good books > you could recommend on the subject? > > I don't see why I should bother with PostgreSQL if I could rather > instruct them on how to use a much more powerful database system. > > Thanks in advance > > > > _______________________________________________ > sapdb.general mailing list > [EMAIL PROTECTED] > http://listserv.sap.com/mailman/listinfo/sapdb.general > > > ********************************************************************** > This email and any files transmitted with it are confidential and > intended solely for the use of the individual or entity to whom they > are addressed. If you have received this email in error please notify > the system manager. > Email: [EMAIL PROTECTED] Tel: +49-89-74491-191 > > This footnote also confirms that this email message has been swept by > serveral anti-virus tools for the presence of computer viruses. > > www.ifcosystems.de > ********************************************************************* > > > --__--__-- > > Message: 3 > From: "Schildberg, Steffen" <[EMAIL PROTECTED]> > To: SAPDB Mailing List <[EMAIL PROTECTED]> > Subject: RE: Error using replication manager > Date: Wed, 16 Oct 2002 12:22:13 +0200 > > Hi Florian, > > [Florian K�rner wrote] > > > Subject: Error using replication manager > > > > I use the command repmcli to fill an existing table with rows > > from another > > table with an identical schema. I use the command TABLELOAD > > in my script > > with a file that was successfully created with TABLEEXTRACT. > > I get an error and logfile "repserver.log" says: > > > > TABLELOAD TABLE tab_tislot_role INFILE > > '/opt/sapdb/tislot_replication_files/tab_tislot_role.rep' OUTFILE > > '/opt/sapdb/tislot_replication_files/loadlog.rep' > > > > / * > > / E -25011: Error executing internal SQL statement 'DELETE > > "TAB_TISLOT_ROLE"': 'SQL error -115 = Table is read only > > (error position: 1) > > '. > > / E -25801: Internal error [28_1, 2119, -9014]; contact > > technical support > > / E -25801: Internal error [28_1, 1444, -25801]; contact > > technical support > > / M Releasing user connection (USER: 'TISYS'). > > / * > > > > > > I can't figure out what's wrong, and why is the rep manager doing the > > DELETE? > > > Ooops, the docs miss an important feature: > The table must be empty to run TABLELOAD successfully. > To ensure this RepMan tries to delete all rows if the table is filled > instead of issuing an error message and stopping processing (we'll change > that with one of the next versions to 'issue an error'). > That's why it tries to delete. > The state 'read only' is set if you either > loaded the table already using FASTLOAD or another TABLELOAD. To reset > the state you need to backup the db. > HTH > Steffen > -- > Steffen Schildberg > SAP DB Team > SAP Labs Berlin > > --__--__-- > > Message: 4 > Date: Wed, 16 Oct 2002 12:28:46 +0200 > From: Ralf Liebenow <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Subject: Re: Possible bug in insert - empty string not allowed on coloumns with default? > Reply-To: [EMAIL PROTECTED] > Organization: theCo.de AG > > Hi :-) > > Because many DBM'ses accept something that does not mean that it is > valid SQL. That is not standard behaviour. If you do not want to set > a value, just don't give it: (I also don't give user, password, > maxrows,siteurl,options, so they will be set to their default values) > > INSERT INTO PNCVS_headlines > (pn_id,pn_sitename,pn_rssurl) VALUES > (2,'PostNuke','http://postnuke.com/backend.php') > > You will see this is much shorter and it _will_ work with any SQL DB. > > Ralf > > > In article > > <[EMAIL PROTECTED]>, IML- > > [EMAIL PROTECTED] says... > > > I'm by no means an expert on SQL, so just an observation... > > > > > > You seem to be treating integers with quotes... I've never done that with my > > > SQL. To me '0' would make sense for VARCHAR, but not int. > > > > I agree - this code is from existing SW - PostNuke - and it works with several > > RDBMS's. It's not necessary, but definitely should not cause an error. > > > > > Trying to insert '' into a INT field? To me, only allowable would be > > > integer numbers or NULL. An _empty string_ is neither a number or null. > > > > So how would you say, "assign the default value to this numeric field" ? > > > > If ...,'',... is invalid, and ...,,... is invalid? > > > > > To me, the error is that SAPDB doesn't error on the '0' too :) > > > > Why? Just tried on Informix, DB/2, MySQL and PostgreSQL - all accepted it. I > > agree that it is not necessary, but why make it an error ? > > > > Thanks, > > > > -- > > Yours, Andrej Falout, http://www.falout.com/disclaimer.html > > Visit the OpenSource alternative, Aubit 4gl: http://aubit4gl.sourceforge.net > > PLEASE NOTE: All HTML email sent to me WILL BE DELETED AUTOMATICALLY WITHOUT > > READING. > > > > > > _______________________________________________ > > sapdb.general mailing list > > [EMAIL PROTECTED] > > http://listserv.sap.com/mailman/listinfo/sapdb.general > > > > -- > theCo.de AG > Oranienstr. 10-11, 10997 Berlin > fon +49 30 617 897-0 fax -10 > [EMAIL PROTECTED] http://www.theCo.de > > --__--__-- > > Message: 5 > To: [EMAIL PROTECTED] > From: "Gabriele Boccone" <[EMAIL PROTECTED]> > Subject: Re: Delphi and SAPDB - ODBC only? > Date: Wed, 16 Oct 2002 13:17:01 +0200 > > Mentre attraversavo 5448CF533B4CD511A0EE0002A52C226AC80306@dewdfx11">news:5448CF533B4CD511A0EE0002A52C226AC80306@dewdfx11, > un giorno senza sole, > vidi Koetter, Thomas Theodor <[EMAIL PROTECTED]> pianger > d'amore: > > > Hi Gabriele > > > >> I thought Microsoft > >> was dropping ODBC support, and so we are looking for > >> different solutions, > >> like Borland dbexpress, or ADO support. Is it just too > >> platform-specific? > > > > Microsoft offers an OLE DB data provider for ODBC and a .NET data > > provider for ODBC. Both are already used by some participants of the > > list. Check the archive. This is the way to use SAP DB with ADO, .NET > > etc. > > > > > > With kind regards Thomas > > > > Thank you, I'm going to try it. > > > > > > --__--__-- > > Message: 6 > To: [EMAIL PROTECTED] > From: "Gabriele Boccone" <[EMAIL PROTECTED]> > Subject: SAP on Linux/Debian > Date: Wed, 16 Oct 2002 13:25:55 +0200 > > Second question: our test on Windows 2000 is complete, but we have some > problem testing it on Linux. > > Our platform is Linux Debian 3.0, the tgz package doesn't install, and the > converted RPM can be installed but do not work. > > Did anybody test it? We are NOT going to change our distribution to install > SAP, at least not in the near future. Anyway we'll use it on our Win2000 > machines. > > > > > > --__--__-- > > Message: 7 > From: =?iso-8859-1?Q?Peter_S=F6nnergren?= <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Subject: RE: SAPDB course development > Date: Wed, 16 Oct 2002 13:20:51 +0200 > > i was looking for the same thing, i found some courses on the sap.com > website, don't know if you have the money to spend though, the only > course in english takes place in singapore. > > https://pgwshop.sap-ag.de/scripts/wgate/yhwbus/!?user=SPUBLIC&land=SE/DK > /FI/NO&typeshort=V%C4LJ%20S%D6KKRITERIUM > > > )) Peter S�nnergren > (( Software Engineer > C|~~| tel: +46 707 491228 > `--' IBFS Development AB > JAVA http://www.interbizzfs.com > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]] On Behalf Of van Rooyen > Sent: den 16 oktober 2002 10:17 > To: [EMAIL PROTECTED] > Subject: SAPDB course development > > > Hi all > > I currently teach the subject Internet Databases which focuses on open > source databases. Up to now I have only taught MySQL and PostgreSQL, but > > a friend introduced me to SAPdb about a month back. > > My question is: is there any training available for SAPdb? Good books > you could recommend on the subject? > > I don't see why I should bother with PostgreSQL if I could rather > instruct them on how to use a much more powerful database system. > > Thanks in advance > > > > _______________________________________________ > sapdb.general mailing list > [EMAIL PROTECTED] > http://listserv.sap.com/mailman/listinfo/sapdb.general > > > --__--__-- > > Message: 8 > Date: Wed, 16 Oct 2002 13:25:21 -0700 > From: Laszlo Hornyak <[EMAIL PROTECTED]> > To: Gabriele Boccone <[EMAIL PROTECTED]> > CC: [EMAIL PROTECTED] > Subject: Re: SAP on Linux/Debian > > > Yes, I tested with Woody, and it runs fine. (it was SAP DB from the free CD) > The test db install script didn`t work, but it is not a problem. > > Gabriele Boccone �rta: > > >Second question: our test on Windows 2000 is complete, but we have some > >problem testing it on Linux. > > > >Our platform is Linux Debian 3.0, the tgz package doesn't install, and the > >converted RPM can be installed but do not work. > > > >Did anybody test it? We are NOT going to change our distribution to install > >SAP, at least not in the near future. Anyway we'll use it on our Win2000 > > > > No, it won`t be better, belive me ;)) > > Laszlo Hornyak > > >machines. > > > > > > > > > >_______________________________________________ > >sapdb.general mailing list > >[EMAIL PROTECTED] > >http://listserv.sap.com/mailman/listinfo/sapdb.general > > > > > >. > > > > > > > > > > > --__--__-- > > Message: 9 > Date: Thu, 17 Oct 2002 00:37:38 +1300 > From: Richard Barrington <[EMAIL PROTECTED]> > Subject: Re: SAP on Linux/Debian > To: Gabriele Boccone <[EMAIL PROTECTED]> > Cc: SAPDB mailing list <[EMAIL PROTECTED]> > > Perhaps you could be more specific about what isn't working (and what > you mean by "doesn't install")? > > I also have previously had it running on Woody. > > On Thu, 2002-10-17 at 00:25, Gabriele Boccone wrote: > > Second question: our test on Windows 2000 is complete, but we have some > > problem testing it on Linux. > > > > Our platform is Linux Debian 3.0, the tgz package doesn't install, and the > > converted RPM can be installed but do not work. > > > > Did anybody test it? We are NOT going to change our distribution to install > > SAP, at least not in the near future. Anyway we'll use it on our Win2000 > > machines. > > > --__--__-- > > Message: 10 > From: "Eric Jain" <[EMAIL PROTECTED]> > To: "sapdb-general" <[EMAIL PROTECTED]> > Cc: "David N. Heydon" <[EMAIL PROTECTED]> > Subject: Re: Adding multi-schema support to SAPDB > Date: Wed, 16 Oct 2002 13:40:06 +0200 > Organization: Swiss Institute of Bioinformatics > > > but then all users would have to connect to > > that 'database' as the same dummy user > > I assume you are aware that you can > > GRANT x ON t TO y > > ? > > > -- > Eric Jain > > > --__--__-- > > Message: 11 > Date: Thu, 17 Oct 2002 00:40:08 +1300 > From: Richard Barrington <[EMAIL PROTECTED]> > Subject: Re: SAP on Linux/Debian > To: Gabriele Boccone <[EMAIL PROTECTED]> > Cc: SAPDB mailing list <[EMAIL PROTECTED]> > > Check here for Debian .deb contact details: > > http://sapdb.2scale.net/moin.cgi/PortingProjects > > On Thu, 2002-10-17 at 00:25, Gabriele Boccone wrote: > > Our platform is Linux Debian 3.0, the tgz package doesn't install, and the > > converted RPM can be installed but do not work. > > > --__--__-- > > Message: 12 > From: "Stausberg, Markus" <[EMAIL PROTECTED]> > To: "'Gabriele Boccone'" <[EMAIL PROTECTED]>, > "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]> > Subject: RE: SAP on Linux/Debian > Date: Wed, 16 Oct 2002 13:50:15 +0200 > > you wrote : > > Our platform is Linux Debian 3.0, the tgz package doesn't > > install, and the > > converted RPM can be installed but do not work. > > > > Did anybody test it? We are NOT going to change our > > distribution to install > > SAP, at least not in the near future. Anyway we'll use it on > > our Win2000 > > machines. > > >>(replies from several others ...) > > also have a look at > > http://www.mybytes.de/sapdb/ > > hth > > Markus Stausberg > SAP Labs Berlin > > > > > --__--__-- > > Message: 13 > From: "Rupsch, Alexander ECG" <[EMAIL PROTECTED]> > To: "SAPDB Mailinglist (E-Mail)" <[EMAIL PROTECTED]> > Subject: Oracle Trigger in Oracle Mode, Error -5015 > Date: Wed, 16 Oct 2002 13:54:09 +0200 > > Hi, > > I want to migrate a schema from oracle to sapdb. the schema is changing from > time to time, so i want to > import original schema with minimal changes. that's why I'm trying to import > it in oracle mode (via repmcli). > > it does well for tables and sequences but not for triggers. > > Here a simple version for what i want to do: > > // The table, runs well.. > CREATE TABLE "TEST"."MYTEST" > ( > "ID" Number (20,0) DEFAULT 0, > "NAME" Varchar(20) ASCII > ) > > // the sequnece, runs as well > CREATE SEQUENCE "ID_GEN" INCREMENT BY 1 MINVALUE 0 NOMAXVALUE NOCYCLE CACHE > 100 ORDER > > > // the trigger, makes trouble! > CREATE OR REPLACE TRIGGER "MYTRIGGER" AFTER ON "MYTEST" > BEGIN > UPDATE "TEST"."MYTEST" > SET id = (SELECT ID_GEN.NextVal FROM DUAL) > WHERE id = 0 > END > > > The Problem for the moment is the creation of the trigger (yes, the update > clause may not do what i expect, but that's for later). > When I try to run the statement thru SQLStudio I get the following error: > > --> Syntax error or access violation;-5015 POS(20) Missing > keyword:VIEW,PACKAGE. > > By removing the "OR REPLACE" I get: > > --> Syntax error or access violation;-3014 POS(29) Invalid end of SQL > statement. > > I played around with quotation marks which changes nothing... > > Hope someone can help, thanks..... > > --__--__-- > > Message: 14 > From: "Anhaus, Thomas" <[EMAIL PROTECTED]> > To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]> > Cc: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]> > Subject: RE:Oracle Trigger in Oracle Mode, Error -5015 > Date: Wed, 16 Oct 2002 14:14:35 +0200 > > Alexander Rupsch wrote : > > >I want to migrate a schema from oracle to sapdb. the schema is changing from > >time to time, so i want to > >import original schema with minimal changes. that's why I'm trying to import > >it in oracle mode (via repmcli). > > >it does well for tables and sequences but not for triggers. > > >Here a simple version for what i want to do: > > >// The table, runs well.. > >CREATE TABLE "TEST"."MYTEST" > >( > > "ID" Number (20,0) DEFAULT 0, > > "NAME" Varchar(20) ASCII > >) > > >// the sequnece, runs as well > >CREATE SEQUENCE "ID_GEN" INCREMENT BY 1 MINVALUE 0 NOMAXVALUE NOCYCLE CACHE > <100 ORDER > > > >// the trigger, makes trouble! > >CREATE OR REPLACE TRIGGER "MYTRIGGER" AFTER ON "MYTEST" > <BEGIN > > UPDATE "TEST"."MYTEST" > > SET id = (SELECT ID_GEN.NextVal FROM DUAL) > < WHERE id = 0 > >END > > > >The Problem for the moment is the creation of the trigger (yes, the update > >clause may not do what i expect, but that's for later). > >When I try to run the statement thru SQLStudio I get the following error: > > >--> Syntax error or access violation;-5015 POS(20) Missing > >keyword:VIEW,PACKAGE. > > >By removing the "OR REPLACE" I get: > > >--> Syntax error or access violation;-3014 POS(29) Invalid end of SQL > >statement. > > >I played around with quotation marks which changes nothing... > > >Hope someone can help, thanks..... > > The Syntax of your create trigger statement is wrong. Please try > > CREATE TRIGGER "MYTRIGGER" FOR MYTEST AFTER INSERT EXECUTE ( > UPDATE "TEST"."MYTEST" > SET id = (SELECT ID_GEN.NextVal FROM DUAL) > WHERE id = 0; > ) > > Please note, that you don't need the select expression in the update statement > and that you should check the return code : > > CREATE TRIGGER "MYTRIGGER" FOR MYTEST AFTER INSERT EXECUTE ( > UPDATE "TEST"."MYTEST" > SET id = ID_GEN.NextVal > WHERE id = 0; > IF $RC <> 0 THEN STOP($RC); > ) > > Regards, > Thomas > > -- > Thomas Anhaus > SAP DB, SAP Labs Berlin > [EMAIL PROTECTED] > http://www.sapdb.org/ > _______________________________________________ > sapdb.general mailing list > [EMAIL PROTECTED] > http://listserv.sap.com/mailman/listinfo/sapdb.general > > > > --__--__-- > > Message: 15 > To: [EMAIL PROTECTED] > From: "Gabriele Boccone" <[EMAIL PROTECTED]> > Subject: Re: SAP on Linux/Debian > Date: Wed, 16 Oct 2002 14:31:24 +0200 > > Mentre attraversavo [EMAIL PROTECTED]">news:[EMAIL PROTECTED], > un giorno senza sole, > vidi Laszlo Hornyak <[EMAIL PROTECTED]> pianger d'amore: > > > Yes, I tested with Woody, and it runs fine. (it was SAP DB from the > > free CD) The test db install script didn`t work, but it is not a > > problem. > > Ok. I upgraded my libc6 to 2.2.5-15 and it worked, thanks everybody. > > I still can't understand why the converted RPMs didn't work, anyway this is > not a problem. > > Wow, that was fast. :-) I still wonder how can people say that "linux has no > support"... I bet Bill Gates himself can't get Windows problems solved that > fast. :-) > > > > > > > --__--__-- > > _______________________________________________ > sapdb.general mailing list > [EMAIL PROTECTED] > http://listserv.sap.com/mailman/listinfo/sapdb.general > > > End of sapdb.general Digest > _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
