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

Hi Elke, >> I don't understand what you mean by " or >> how they are named in the environment you are using" ? >What are you using, precompiler, JDBC, ODBC or what else to talk to the >database server? I'm using jdbc and SQLStudio.What is the appropriate way to do this insert in those environme

Visual Query

Hi I often use Visual Query as a 'graphic tool' to print out table diagrams. I see that i can only add 16 tables. Is that the limit? Could u guys recommend another table diagram tool? Just to show my boss the tables and their relationships. thanks Nick

Re: MAX(), view, optimizator problem!

You must create a multi-column index, like this: create index test_index on test_table ( f2 asc, F1 asc) then, when you run the optimizer on this: EXPLAIN SELECT F2, MAX(F1) AS F1 FROM TEST_TABLE GROUP BY F2 or this EXPLAIN SELECT F1, MAX(F2) AS F2 FROM TEST_TABLE GROUP BY F1 it will show: T

Re: UPDATE and JOIN together?

Shouldn't it be possible to use a join between t1 and t2 as the SELECT? Then you're free to choose the existing values from t1 for some columns and values from t2 for the rest. OK, that's true. The problem is, that this method is very error-prone. (if forget a column the data is lost) -- MaxD

Re: backup sap db

Alejandro Elviretti wrote: Sorry but I am rocky with SAP DB and this mailing list, i 'd like to know if there are another backup solution for backing up online instead of using Database Manager?. Solution as Arcserve, Veritas, etc. see http://www.sapdb.org/7.4/htmhelp/43/e0f23ab6b4317de1000a114

backup sap db

Sorry but I am rocky with SAP DB and this mailing list, i 'd like to know if there are another backup solution for backing up online instead of using Database Manager?. Solution as Arcserve, Veritas, etc. Thanks ! Alejandro D. Elviretti Sistemas - MCSE Net. Admin. - Lab. Kampel Martian

Re: Some questions !

Kevin Wilson wrote: Dan, So in reference to your comment below, just how bad of an impact are we talking here? It adds a lot of I/O because every commit writes to disk. And connections are synchronizing on the log writer. Think about a chain gang. And if it is really bad then why would that b

RE: Some questions !

Dan, So in reference to your comment below, just how bad of an impact are we talking here? And if it is really bad then why would that be the default mode? (something to do with the jdbc spec I suppose) "> 2) I saw in DBMGui a number named "waits for logwritter", this number is > very high for

Re: Some questions !

Sap DB wrote: I'm writting an application NT service that query and update data from SapDB odbc source. 1) My application use only one connection to datasource but many request (statement) may be run in a same time (multiple threads). Does anybody know if I should use a connection per thread, or i

Re: MAXDB Fails to come up after system restart

Michael Slinn wrote: 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_

Re: run SQL-Script by JDBC

Joerg Lensing wrote: Hi list, I'm using SAPDB 7.4 / win2000 running local. When executing a single sql-statement, all runs well. But executing multiple statements causes this SQLException: snip SQLException: SQLState(42000) vendor code(-3014) SQL Error at line 2: com.sap.dbtech.jdbc.exceptio

Re: DBPROC and JDBC (CFMX)

Javier Gostling wrote: Hello, I have a stored procedure which returns a cursor, and am trying to call it from a CFMX page using cfstoredproc. CFMX is using the JDBC driver from SapDB. Every time I call the page I get an "[-3005]: Invalid SQL statement" error. According to the error page, the attep

Re: UPDATE and JOIN together?

Sven Köhler wrote: UPDATE t1 LEFT JOIN t2 SET t1.c1 = t2.c2 but that is not allowed in SAPDB. Is there any workaround? You could try a INSERT ... SELECT ... UPDATE DUPLICATES Well, i cannot use that as long as SAPDB replaces the whole row instead of doing an update. (how about renaming that to

DBPROC and JDBC (CFMX)

Hello, I have a stored procedure which returns a cursor, and am trying to call it from a CFMX page using cfstoredproc. CFMX is using the JDBC driver from SapDB. Every time I call the page I get an "[-3005]: Invalid SQL statement" error. According to the error page, the attepted SQL is (param1) =

run SQL-Script by JDBC

Hi list, I'm using SAPDB 7.4 / win2000 running local. When executing a single sql-statement, all runs well. But executing multiple statements causes this SQLException: snip SQLException: SQLState(42000) vendor code(-3014) SQL Error at line 2: com.sap.dbtech.jdbc.exceptions.DatabaseException:

Re: UPDATE and JOIN together?

UPDATE t1 LEFT JOIN t2 SET t1.c1 = t2.c2 but that is not allowed in SAPDB. Is there any workaround? You could try a INSERT ... SELECT ... UPDATE DUPLICATES Well, i cannot use that as long as SAPDB replaces the whole row instead of doing an update. (how about renaming that to REPLACE DUPLICATES an

creating database instance-unknown host

hello everyone, I am using redhat linux 8.0 and sapdb 7.4 and when trying to create the database instance in last step load_systab I get the error unknown host. when I looked into /etc/hosts I can see the localhost set. I appreciate any help provided Thanks, *

unable to create the database instance

hello everyone, I am using redhat linux 8.0 and sapdb 7.4 and when trying to create the database instance in last step load_systab I get the error unknown host. when I looked into /etc/hosts I can see the localhost set. I appreciate any help provided Thanks, *

RE: UPDATE and JOIN together?

> >>UPDATE t1 LEFT JOIN t2 SET t1.c1 = t2.c2 > >>but that is not allowed in SAPDB. Is there any workaround? You could try a INSERT ... SELECT ... UPDATE DUPLICATES Daniel Dittmar -- Daniel Dittmar SAP DB, SAP Labs Berlin [EMAIL PROTECTED] http://www.sapdb.org/ -- MaxDB Discussion Mailing Li

Re: UPDATE and JOIN together?

UPDATE t1 LEFT JOIN t2 SET t1.c1 = t2.c2 but that is not allowed in SAPDB. Is there any workaround? Can't you use a sub query ? I don't think so. The grammer of the UPDATE statement says, that i'm only allowed to use a table-name. THe other problem is, that views with JOINs are not updatable eith

clustering

Hi, Is it possible to cluster sapdb 7.4 for ha/hat, like oracle? Or make selects over many databases as alternative loadbalancing? Cheers, Gert Gert Wohlgemuth Max Plack Institut für Molekulare Pflanzenphysiologie Am Mühlenberg 1 14424 Golm Fon: +49-331-5678320 e-mail: [EMAIL PROTECTED] --

MAXDB Fails to come up after system restart

I'm reposting this because I haven't got a response. 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

RE: Replica

> It's possible manage replica in sapdb? > thank you. No. I assume that you mean database replication, where one database gets automatically all the changes made to another database. > exsit differents beetwen maxdb and sapdb? No, except for the name and the licence. Daniel Dittmar -- Dani

RE: SAB DB PRICE

> I've read the pdf and in page 5 speak about change price for > new customer in > 2004. > but sapdb it's free or no?! This depends on you software, see http://www.mysql.com/products/licensing.html for details. This will apply to the upcoming version 7.5. Versions 7.3 and 7.4 will remain un

RE: MAX(), view, optimizator problem!

Dmitry Melekhov wrote: > Becker, Holger wrote: > > Hello! > > > You are true, this is a problem within SAP DB and some kind > of views. > > > > Your view uses a group by clause and is therefor handled as > a complex view > > which first will be matarialized at select time and then > the sele

How can i copy tables with long entrys? / performance problem

I had following problem, I must copy table one to table two and use a statement like this: INSERT INTO A SELECT field_a FROM B Ok it's runs fine, But sometimes i had the problem thats the blob (LONG(ASCII)) not 100% correct (ca all 5 - 10k poies) Why thats? I there an alternaive to copy tabl

Export to SQL doesn't work & Need Long Varchar search

Auer Wolfgang [EMAIL PROTECTED] stated in the list that sql studio has to be in internal mode then exports to excel would work, I have not found this to be the case. Any tips on how I can get a query result copied out to an excel file? Also, I (as well as many other peeps) need to search in Long V

Re: MAX(), view, optimizator problem!

Becker, Holger wrote: Hello! You are true, this is a problem within SAP DB and some kind of views. Your view uses a group by clause and is therefor handled as a complex view which first will be matarialized at select time and then the select works on this intermediate result. We already have t

Web tools don't start

Hello, I've just started installing SAP DB and the Web Tools. When I first started the web server with wahttp it worked. But when I tried to start it the next day it seems to connect to port 0 (I know not a real port). What could be the problem BTW: SuSE 8.2 and I built it from the 7.4.3.25 so

SAB DB PRICE

Hi all, I've read the pdf and in page 5 speak about change price for new customer in 2004. but sapdb it's free or no?! wich is the price? where I can ask in italy about sapdb licencing? thank you Massimo -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To

Replica

It's possible manage replica in sapdb? thank you. exsit differents beetwen maxdb and sapdb? max -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Automatic Increase in the Sapdb size ...

> 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 ? A first version o this feature is in 7.4.03.17 and later. See http://www.sapdb.org/webpts?wptsdetail=yes&ErrorType=1&E

RE: Automatic Data Drow

> Will this be in the new version with the new mysql license, > or can we get > it in the truly free version? A first version is in 7.4.03.17 and later. See http://www.sapdb.org/webpts?wptsdetail=yes&ErrorType=1&ErrorID=1121020. This still requires that you configure enough MAXDATADEVSPACES (ke

RE: MAX(), view, optimizator problem!

Dmitry Melekhov wrote: > 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 the

RE: Automatic Increase in the Sapdb size ...

Hi, SAP DB has no auto grow or auto shrink feature of data volumes. If the data area is full the db tasks will be suspended and a new data volume has to be added by the administrator. Regards, Torsten SAP DB, SAP Labs Berlin -Original Message- From: Ripin Natani [mailto:[EMAIL PROTECT

Re: UPDATE and JOIN together?

Le jeudi 02 octobre 2003, Sven Köhler a écrit... bonjour, > UPDATE t1 LEFT JOIN t2 SET t1.c1 = t2.c2 > but that is not allowed in SAPDB. Is there any workaround? Can't you use a sub query ? -- jean-michel -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb