UPDATE and JOIN together?

2003-10-01 Thread Sven Köhler
if i want a simple data transfer of one table into another i'd like to use something like UPDATE t1 LEFT JOIN t2 SET t1.c1 = t2.c2 but that is not allowed in SAPDB. Is there any workaround? -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe:htt

MAXDB Fails to come up after system restart

2003-10-01 Thread Michael Slinn
I'm running RedHat 9. A few months ago I *finally* got SAPDB LINUX 7.4.3 Build 027-121-048-452 to install and run the TST74 database. Today the machine had to be rebooted and the database would not come up. $ export LD_ASSUME_KERNEL=2.2.5 $ dbmcli -d TST74 -u dbm,dbm db_warm Error! Connection

Re: MAX(), view, optimizator problem!

2003-10-01 Thread Dmitry Melekhov
Hello! I can't beleive that nobody knows about this problem. I need any answer. Even if answer will be something like- SAP DB can't do it better now. Dmitry Melekhov wrote: Hello! Some time ago Valery Zhuchenko posted the same answer. But, because there is no replies I think that his message is n

Automatic Increase in the Sapdb size ...

2003-10-01 Thread Ripin Natani
Hi, Is it possible for the sapdb (7.4..0.27) to automatically increase in size if the data voulmes get full ? If yes how and where can I set the option for this behavior ? Thanks, -Ripin.

data retrieving problem

2003-10-01 Thread Gert Wohlgemuth
dear all, hopefully anybody here can help me, I had this huge problem, I import thousends of files into a sapdb database and sometimes if i want to retrieve the data with a simple select like: SELECT * FROM MY_TABLE i become something like this (all integers!) col_1 | c

Re: Automatic Data Drow

2003-10-01 Thread dhay
Hi Daniel, >> In some RDBMS, data file size can grow automatically. Does SAP DB has this feature? > This feature will be available in a future version. SAP installations > mostly use a dedicated server machine for the database, so playing nice > with others wasn't that important. But we're now t

RE: again: maybe bug in jdbc driver

2003-10-01 Thread Paskamp, Marco
Hi, the problem you have reported with the driver version 7.4.4 using the oracle mode is a bug. It was the x'th attempt to write a complex universal "SELECT" command for an internal view which can deal with all the different modes (oracle, internal, unicode ...). Hope the x+1'th attempt works. A

RE: Long varchar and date fields don't mix??!!

2003-10-01 Thread Zabach, Elke
Ajit Aranha wrote: > > Elke, > can you clarify what the : does in the following? > insert into test values (..., TO_DATE(...), :longvalue). > > Are u saying > insert into test values (347,TO_DATE('2003/09/30 10:53', '/MM/DD > HH24:MI'),:'asdsadsadas') > would work. > No, as usual for

RE: -24964,ERR_EXECUTE: error in program execution

2003-10-01 Thread Zabach, Elke
> -Original Message- > From: Manfred [mailto:[EMAIL PROTECTED] > Sent: Mittwoch, 1. Oktober 2003 09:20 > To: MaxDB Mailing List > Subject: -24964,ERR_EXECUTE: error in program execution > > > Hallo! > > I installed sapdb on windows xp and tried to create the > sample database > (on an

RE: websql.dll

2003-10-01 Thread Ugo_Romano
Hi, I have the same problem of others members: with win 2k websql doesn't function. Could U send me the right dll ? I tried to substitute websql.dll with an old version without success. Best regards, Ugo Romano [EMAIL PROTECTED] Prototipo S.p.A.Via Brodolini, 12 40026 IMOLA (BO) Via Brodol

Problem with GRANT

2003-10-01 Thread Ralf Schneider
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, I've encoutered a strange problem when creating a new table and granting access rights to this table to an existing role. After I create the table I execute the following command: GRANT INSERT, SELECT, UPDATE, DELETE ON faxvoice_calls, faxvoice_f

xsql and SUM

2003-10-01 Thread Philippe
Hello, I'm using xsql to get data from database with SELECT statement. it works rather well... But when I use a SUM function, I've only the title of the columns, but no more data... Any idea ? Thanks -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscr

Re: -11987,Parameter RUNDIRECTORY is missing!

2003-10-01 Thread Derek M. A. Lee-Wo
Turns out that my parameter file in /home/sapdb/independ_data/config was ZERO bytes. I saw another file with a ".01" ending. I copied that, and the database then started OK. I assume the ".01" file was a backup or old copy. How can I go about making a new copy (or do I simply copy the existing

unsubscribe saptrapp

2003-10-01 Thread Ingo Trapphagen
-- Ingo Trapphagen IOn AG Tel: 0211/92495-124 http://www.ion.ag -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

-11987,Parameter RUNDIRECTORY is missing!

2003-10-01 Thread Derek M. A. Lee-Wo
An AIX box we had running SAPDB got powered off while SAPDB was running. After bring it back it, when we try to start a database, we get the following: $ dbmcli -s -d VRViewer -u dbm,dbm db_start ERR -24994,ERR_RTE: runtime environment error -11987,Parameter RUNDIRECTORY is missing! How

-24964,ERR_EXECUTE: error in program execution

2003-10-01 Thread Manfred
Hallo! I installed sapdb on windows xp and tried to create the sample database (on an other system with the same configuration, everything works fine) - following errror occured. dbmcli on TST>ERR -24964,ERR_EXECUTE: error in program execution 3,""C:\PROGRAMME\SAPDB\DEPEND\bin\x_python" "C:\PROGR