Comments regarding installation routine or how to loose much time

2005-07-03 Thread Uwe Haussmann
during or after the upgrade process. The third, minor problem: When someone wants to create a new database, it would be very nice if he could see the choice of Unicode or non Unicode without searching the extended parameters.. But otherwise: WHAT A PROGESS ! -- mit freundlichen Grüßen Uwe H

Substr on Long columns

2005-07-03 Thread Uwe Haussmann
sehr geehrter%'' but here also the same error. How can I get my results ? Help would be very much appreciated. -- mit freundlichen Grüßen Uwe Haussmann mailto: [EMAIL PROTECTED] PGP/GNUPG Public Key: http://www.somdet.net/pgp/uhaussmann.txt -- MaxDB Discussion Mailing List For l

SUBSTR ON LONG FIELDS

2005-06-25 Thread Uwe Haussmann
Hello, I am just trying the long awaited new search possibilities on LONG fields. The following filter condition returns me an error because of the length(content) which i defined because I want to search the whole column and do not know about its length. SELECT CONTENT, FR

Timestamp

2005-06-09 Thread Uwe Haussmann
full timestamp. Converting to datetime gives me only the date, converting to string gives me the full date time string, but I cannot get the milliseconds which I need later for concurrency checks I include a screenshot showing the problem. Can someone help me ? -- mit freundlichen Grüßen Uwe

Upgrade Problem

2005-04-25 Thread Uwe Haussmann
this ? Thank you UH mit freundlichen Grüßen, Uwe Haussmann mailto:[EMAIL PROTECTED] PGP Public Key at http://www.somdet.net/pgp/uhaussmann.txt -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe:http://lists.mysql.com/[

Domainuser

2005-04-25 Thread Uwe Haussmann
I remember that there was a Domain user when I used ADABAS D, but with MaxDB I don't see one, at least with my Windows version mit freundlichen Grüßen, Uwe Haussmann mailto:[EMAIL PROTECTED] PGP Public Key at http://www.somdet.net/pgp/uhaussmann.txt --

Upgrade to 7.6.9

2005-04-24 Thread Uwe Haussmann
state to ONLINE loading system tables... loading system tables failed load_systab ERR -24909,ERR_DBAUNKNOWN: SYSDBA unknown How can I solve this ? mit freundlichen Grüßen, Uwe Haussmann mailto:[EMAIL PROTECTED] PGP Public Key at http://www.somdet.net/pgp/uhaussmann.txt

Long(Varchar) Columns

2005-04-14 Thread Uwe Haussmann
The use of LONG datatype is extremely restricted in MaxDB. Not only that one cannot use stored procedures when a table contains columns of this datatype, but also one cannot search on the content of such fields. Is this planned to be ameliorated in the near future ? Or otherwise, which possibl

Visual Studio crashing

2005-04-12 Thread Uwe Haussmann
Hello when trying to retrieve data from any of the tables listed in dbexplorer of visual studio, VS crashes immediately. Besides that, I am wondering why, for a database user which has only rights on selecting tables and procs from one DBA, the tree shows all kinds of system tables. I add a sqltrac

DEFAULT SERIAL

2005-04-11 Thread Uwe Haussmann
it should work. did you try with other tables ? I had the same problem with one table among 15 - 14 worked, one not. I had deleted and recreated the default value several times - maybe this was the reason. Finally I recreated the table without default, inserted the records and then added the d

DEFAULT SERIAL

2005-04-11 Thread Uwe Haussmann
One can easily change the serial start value by altering the default serial(xx) to the desired start value: ALTER TABLE ownername.tablename COLUMN "columnname" DROP DEFAULT // ALTER TABLE ownername.tablename COLUMN "columnname" ADD DEFAULT SERIAL(220) // Replace 220 with your record count + 1 G

Using the scheduler for automated backups?

2005-04-07 Thread Uwe Haussmann
Hello, I would like to use the scheduler for making backups. I use the following command: scheduler_create_job 18:00:00 backup_start HMDB2_COM but nothing happens. As I have activated the job and started the scheduler and listed all jobs, I have no explanation