BD Append Not allowed?

2005-04-01 Thread John Singleton
Hello All, I just ran into a rather weird problem in a SQL query. Basically, I created a view from a very large query. The query runs fine when executed as is, and the create view statement completes successfully as well. However, when I try to select from that view I get an error, "BD Append Not

RE: TIMESTAMP/DATE Format & INSERT

2005-04-01 Thread Kevin Wilson
The biggest problem I have is with the jdbc driver and how it (doesn't) handle implied date format conversions. For instance, if you use the Now() function in VB it spits out a timestamp value in the format of "MM/DD/ HH:MM AM/PM" and when assigned to a timestamp field the ODBC driver handles t

RE: other questions...

2005-04-01 Thread Heinrich, Tilo
Hello Grisel, 1. On UNIX MaxDB database instances can use raw devices for their data and log volumes. MaxDB uses its data and log volumes in parallel. 2. NetVault can be used to backup MaxDB via NetVaults's Backint for Oracle agent or with the help of NetVault's scripting and pipe backup abilitie

RE: MaxDB ODBC initial connect time approx. 30 seconds

2005-04-01 Thread Colby, Cyndi K.
> (re: post http://lists.mysql.com/maxdb/25024 ) > > In reference to the below problem, I would like to says a big 'THANK YOU' to > Henrik Hempelmann! Your answer was the correct solution for me! Thanks so > much, again! > > ---

MaxDB Admin Training in Berlin, 11-13. May

2005-04-01 Thread Patrik Backman
Hi MaxDB-users! We will be arranging MaxDB Administration Training in Berlin, 11-13.May. Please join this great opportunity for learning how to professionally administer a MaxDB installation. More information, and registration, is available here: http://www.mysql.com/training/courses/maxdb_admini

RE: AW: Why I can't get response

2005-04-01 Thread Becker, Holger
liu xiaotao wrote: > About answer to 2th question: > Where can I found this information? > Whether will Maxdb distribute some feature to display this > informaion? You > know,it is important to performance tuning. > > > >From: "Zabach, Elke" <[EMAIL PROTECTED]> > >To: "liu xiaotao" <[EMAIL PR

RE: AW: Why I can't get response

2005-04-01 Thread liu xiaotao
Thanks for your answer,I have repeat your suggesion.It's good. But I want to ask more question,can you give me some examples,which deadlock depth are correspond to DEADLOCK_DETECTION's value which is 1,2,3,4 or 5. From: "Zabach, Elke" <[EMAIL PROTECTED]> To: "liu xiaotao" <[EMAIL PROTECTED]>,

RE: AW: Why I can't get response

2005-04-01 Thread liu xiaotao
About answer to 1th question: Can you tell me why maxdb needn't reorganize index? Whether does Maxdb generate the disk fragment in data processing time? About answer to 2th question: Where can I found this information? Whether will Maxdb distribute some feature to display this informaion? You