RE: Prepared sentences

2004-04-27 Thread Anhaus, Thomas
Jonathan Sarabia wrote : >Hi, >I am development a report and I need a Stored Procedure for that. The thing is, I >need that SP to be dynamic, I >mean, I need to use prepared sentences. I looked for that kind of sentence and I did >what it is specified in the >SAPDB documents, however, when I

SAPDB 7.4 and SuSE 9.1

2004-04-27 Thread Ralf Schneider
Hi, I've installed the brand new SuSE 9.1 (Kernel 2.6.4) and the SAPDB 7.4.0.31 that comes with it. When I try to create a new database instance with a script that worked fine for SAPDB 7.4.0.29 on SuSE 8.1 I get an error when starting the instance. Here is the beginning of the script which was

RE: Migration from MySQL

2004-04-27 Thread Schroeder, Alexander
Hello Robson, There is the 'Max DB Proxy' (see http://dev.mysql.com/downloads/maxdb/7.5.01.html), which allows you to connect with your MySQL application to a Max DB Server. You can use this to import a MySQL dump, and to run your existing application. However, this is beta software, and works

Prepared sentences

2004-04-27 Thread Jonathan Sarabia
Hi, I am development a report and I need a Stored Procedure for that. The thing is, I need that SP to be dynamic, I mean, I need to use prepared sentences. I looked for that kind of sentence and I did what it is specified in the SAPDB documents, however, when I tried to compile mi SP the follo

Migration from MySQL

2004-04-27 Thread Robson Paniago
Hi, Is there some tool to automate the migration from a MySQL database to MaxDB 7.5.00? Regards, Robson

RE: stopping unexpectedly

2004-04-27 Thread Zabach, Elke
Davide Sanna wrote: > > Hi there, > > I downloaded MaxDB and I installed all packages. > I installed maxdb-all-win-32bit-i386-7_5_0_8. > > My system is W2k SP3. > > Services installed after installation: > > SAPDB: .M750008 - C:\PROGRAMMI\SDB\7500\pgm\kernel.exe > SAPDB: .M750008 (omststknl

stopping unexpectedly

2004-04-27 Thread Davide Sanna
Hi there, I downloaded MaxDB and I installed all packages. I installed maxdb-all-win-32bit-i386-7_5_0_8. My system is W2k SP3. Services installed after installation: SAPDB: .M750008 - C:\PROGRAMMI\SDB\7500\pgm\kernel.exe SAPDB: .M750008 (omststknl.exe) - C:\PROGRAMMI\SDB\7500\pgm\omststknl.ex

RE: Creating unicode data base

2004-04-27 Thread Matthias Gärtner
Hello. See /opt/sdb/7500/misc/create_demo_db.sh (or wherever you've installed MAXDB). Basically, you need to specify two parameters param_put _UNICODE YES param_put DEFAULT_CODE UNICODE in the dbmcli call below. export SID=MTSCMS3 export HOME=/var/opt/sdb export INSTROOT=/opt/sdb/7500 export

RE: Howto set / reduce the Kernel Memory size of the SAPDB

2004-04-27 Thread Dittmar, Daniel
> I want to reduce the amount of memory(Ram) used by the Sapdb > 7.4, since the DB is getting to slow, http://lists.mysql.com/maxdb/6350 You should check if your system is paging a lot of virtual memory. If this isn't the case, then reducing the memory requirements of SAP DB will slow things do

Re: [SPAM] - cant remove failed instance - Found word(s) remove list in the Text body.

2004-04-27 Thread Dusan Kolesar
Hello Teguh first try: dbmcli -d -u ,< password> db_drop if it is unsuccessful (or you don't remember your password) try this: Stop the database if it is still running. "Start" -> "Control Panel" -> "Administrative Tools" -> "Services" In the list select service with name "SAP DB: ". If the proce

(Another) Outer join / OR problem.

2004-04-27 Thread AF
Found this bug through some automatically generated code: create table things ( id int, name varchar(20) ); create table categories ( thing_id int, category varchar(20) ); insert into things values(1, 'one'); insert into things values(2, 'two'); insert into things v

RE: [SPAM] - cant remove failed instance - Found word(s) remove list in the Text body.

2004-04-27 Thread Edo Bezemer
You have performed the second statements as well: dbmcli -d $SID -u dbm,dbm db_offline dbmcli -s -d $SID -u dbm,dbm db_drop Otherwise try, again. Or use the free Windows utility Srvinstw.exe to drop Windows Services. Cheers Edo > -Original Message- > From: Teguh Prihatmono [mail

cant remove failed instance

2004-04-27 Thread Teguh Prihatmono
Dear all, I'd tried to create db instance using dbmgui, but unfortunately its becom not responding and had to stop it. Then I try again and finally I am successfully create an instance. My problem is..I cant remove the previous (the failed one) database instance. I still have a services on the f