Re: Please help me with unicode problem

2007-02-12 Thread 이민우
Are there anyone who can answer me? - Original Message - From: 이민우 To: maxdb@lists.mysql.com Sent: Tuesday, February 06, 2007 12:18 PM Subject: Please help me with unicode problem Hello, I am Korean. My name is Lee Minwoo. I appreciate that you made good tools for max

RE: problem during installation DB instance on SAP ERP 2005

2007-02-12 Thread Döhr, Markus ICC-H
Hey Luca, > ERP installation is on italian university.We faced lots of > problem (above all financial problem) so we need to use a > open source solution (if it's possible). I see - ok... > I know that SLES and Red Hat are support officially form SAP, > but I know also that CentOS 4.0 is a cl

RE: problem during installation DB instance on SAP ERP 2005

2007-02-12 Thread Döhr, Markus ICC-H
> ERR > -24964,ERR_EXECUTE: error in program execution > 1,can not generate temporary file name CentOS is an (officially) unsupported distribution for ERP 2005. It can be difficult if not impossible to get the system up and running there because all the binaries are built using SuSE Linux Ente

problem during installation DB instance on SAP ERP 2005

2007-02-12 Thread Luca Sozio
Good evening, . I've tried the solutiuon suggested but without result. export TEMP=/tmp Same error during sap installation process. Subprocess starts at 20070210161611 Execute Command : /sapdb/programs/bin/dbmcli -n sapserver -d MDB -u CONTROL, load_syst ab -u SUPERDBA, -ud **

Fire more then one sql command via odbc

2007-02-12 Thread Beermann, Albert
Hello Everybody In my application i do TEXT TO l_cmd NOSHOW FLAGS 2 create table AAATEST (AAA char (20) ascii NOT NULL,BBB date NOT NULL) // create table AAABBBTEST (AAA char (20) ascii NOT NULL,BBB date NOT NULL) // commit endtext l_ok = sqlexecute(con_nr,l_cmd) the

RE: RE How to use a recursive query as subquery ???

2007-02-12 Thread Beermann, Albert
Hallo Elke Thank you for your help. This suggestion works from sql studio ! First select creates rname as resultset which can be used in a second select. >From my application (connecting via ODBC) the first select is ok. The second gives me an error "unknown table rname" ??? Is this an od

RE: How to use a recursive query as subquery ???

2007-02-12 Thread Zabach, Elke
Hallo, no, it is not possible to use recursive query as subselect. But as the result of the recursive query is a named resultset, you can use its name in another's select from-part like Select * from xyz join abc where xyz.rbobjekteid in (select rbobjekteid from rname) (or use it in the join i

Configuration changes crashed Database

2007-02-12 Thread Beermann, Albert
Hello Everbody ! I need more power for my production database. For testing I have a 7.6.00.34 database with default configuration on an suse linux system with 8 giga ram Now I changed some parameters Cache_size = 60 Cache_cat_supply = 6 Maxcpu = 2 Ok ! database is running ! Now

How to use a recursive query as subquery ???

2007-02-12 Thread Beermann, Albert
Hello Everybody I use a recursive query to get all rbobjektideid from structured data (bill of material with up to 99 levels, each rbobjekteid belongs to an oberobjektid) DECLARE RNAME CURSOR FOR WITH RECURSIVE TMPOBJ (LEVEL, rbobjekteid, oberobjektid) AS (SELECT 1, ro.rbobjekteid, ro.o