sequence question

Hi! If there is a system crash could sequences skip some number? For example: Before system crash the value of seq_main is 1000 and after the restart it is 1100. If it can happen, what is to do to avoid it? Thanks Norbert -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.

utf8

Hi all, I know that maxdb can use unicode but wich coding is used ucs2,utf8 or both? If utf8 is supported are there functions for charset conversion? Norbert -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe:http://lists.mysql.com/[EMAIL PROTECT

-24994 ERR_RTE, runtime environment error

Hi all, I can not create more database because when I start the db whith db_start it stops whith the errormessage -24994 ERR_RTE, runtime environment error The krnldiag's last message is create_sem: semget error, No space left on device. More over, I can not use the database-s which are online bec

Re: AW: dbproc, loop through a result table

Hi, Thanks for help. Now, it works. Norbert "Anhaus, Thomas" <[EMAIL PROTECTED]> írta: > Norbert Felde wrote : > > > >Hi, > > > >I tried to loop through the result of the cur_vpid cursor but > >it gives me > >only the first record. I am sure that there are more than only one > >record. What

dbproc, loop through a result table

Hi, I tried to loop through the result of the cur_vpid cursor but it gives me only the first record. I am sure that there are more than only one record. What do I wrong? Is there a different way to step through a result table? maxdb 7.5.00.05 winxp Thanks, Norbert The dbproc code snippet: T

dbproc + dynamic query result

Hi, I wanted to create a dbproc in which I use the result of a dynamic query. I thought the dbproc should work as follows ( just example ): CREATE DBPROC PREPTEST ( IN SZAM INTEGER, OUT RES VARCHAR ) AS VAR QI VARCHAR(100); SET QI = 'SELECT 5 FROM DBA.DUAL '; EXECUTE QI; FETCH INTO :

Re: php module environment

Hi, sadly not. Norbert John Singleton <[EMAIL PROTECTED]> írta: > Hi Felde, > > I too am having this problem. Have you solved it? > > JLS > > Felde Norbert wrote: > > >Hi, > > > >I tried to use the new php module. > >As I test it with p

php module environment

Hi, I tried to use the new php module. As I test it with php -m I receive no error message and it is loaded but it dous not work. I wanted to connect with maxdb_connect and I get the message: Initialization failed [No environment available]., I have not found what I should set additionaly. Have

recover ERR_SHUDOWN

Hi, I made a full data backup of my database. I try to recover on an another computer as follows: 1. I create a database with the same name but because of less storage capacity I can not make the same size data and log volumes. Could it be the problem? The created volumes are big enough to hold

Re: AW: AW: dbproc + dynamic sql

Thanks for the help, it works now. The version of my Maxdb is 7.5.00.05 Thanks, Norbert "Anhaus, Thomas" <[EMAIL PROTECTED]> írta: > Norbert Felde wrote : > > > >I verified my proc using sqlstudio and executed the following > >2 queries: > >call data_uj( '0410', 1, 1, '1' ) > >select * from da

Re: AW: dbproc + dynamic sql

I verified my proc using sqlstudio and executed the following 2 queries: call data_uj( '0410', 1, 1, '1' ) select * from data0410 The data0410 exists, I created it before. The attached trace was made when I executed this two queries. Thanks, Norbert "Anhaus, Thomas" <[EMAIL PROTECTED]> írta: >

dbproc + dynamic sql

Hello, I wrote the dbproc as follows. I can create it and call it without any error message, but it dous not insert any data into the table. Could you tell me what is wrong in the proc. thank you advance, Norbert the proc: CREATE DBPROC DATA_UJ ( IN TABLEIDX varchar(4),

odbc performance

Hallo, I have problems with the performance. I use maxdb through ODBC and inserts are very slow. It can do 2 inserts per second and the tables have 4-8 fields and only a primary key. The system is a winxp. Any idea? Thanks, Norbert -- MaxDB Discussion Mailing List For list archives: http://li