AW: Create Index statement using UPPER( )

Kevin Wilson wrote : > >The following index hangs sql studio when executed in both internal and >Oracle modes. According to the doc ( >http://dev.mysql.com/doc/maxdb/en/6d/117c4dd14811d2a97400a0c944 >9261/content. >htm ) I should be able to do this if I am reading it correctly. > > >CREATE INDEX "I

RE: SAPDB 7.4.3 - HP Data Protector 5.1

> We are trying to configure the backup/restore utility backint > using HP Data Protector and we are getting an error related > to the pipe we have created. I don't know if HP DP does support backing up from pipes directly. I think you have to use backint to create files of a certain size and ba

SAPDB 7.4.3 - HP Data Protector 5.1

kint for SAP DB. Writing '\\.\pipe\INST1 #PIPE' to the input file. Prepare passed successfully.   2004-10-13 14:44:13 Starting database action for the backup. Requesting 'SAVE DATA QUICK TO '\\.\pipe\INST1' PIPE NO CHECKPOINT MEDIANAME 'BACK_INST1_SAPDB''

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: log file consistency check

>Sent: Wednesday, October 13, 2004 11:25 AM >> >To: [EMAIL PROTECTED] >> >Subject: log file consistency check >> > >> > >> >Hi, >> > >> >How can I check the consistency of an archived log file? >> >I get an error when issueing a recover_st

RE: log file consistency check

n I check the consistency of an archived log file? > >I get an error when issueing a recover_start arch log 091 > >ERR > >-24988,ERR_SQL: sql error > >-903,Host file I/O error > > > >So I performed a recover_check arch log 091 on that log file. > >The return > >

Alter table add column performance

Hi, with SQL server and Oracle some alter table statements will work very fast even on large tables (e.g. 'alter table add column' with no default values and allowing null values) while other alter table statements will effectively copy table contents to accomplish the schema change (e.g. 'alte

RE: log file consistency check

check the consistency of an archived log file? >I get an error when issueing a recover_start arch log 091 >ERR >-24988,ERR_SQL: sql error >-903,Host file I/O error > >So I performed a recover_check arch log 091 on that log file. >The return >is: > >

AW: bits and bytes

Die KuHShow wrote: > > Thanks for answering my questions. But now i have another problem. Is > it true, that maxdb could not calculate with bits ? So i can combine > to bits with "or","and" or "xor". Perhaps there is a possibility to do > so, but i have not found it yet :( > But without the abili

AW: AW: dbproc + dynamic sql

Norbert Felde wrote : > >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,

bug with foreign keys

Hi, i got a problem with foreign keys in 7.4.3-032 2 tables with 2 fks if i run ALTER TABLE TABLE1 ADD FOREIGN KEY FBTABLE1_1 ( REFCOL1 ) REFERENCES TABLE2 (ID) ON DELETE RESTRICT; ALTER TABLE TABLE1 ADD FOREIGN KEY FBTABLE1_2 ( REFCOL1 ) REFERENCES TABLE2 (ID)

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: >

RE: log file consistency check

> I get an error when issueing a recover_start arch log 091 ERR > -24988,ERR_SQL: sql error > -903,Host file I/O error IMHO you can't start with LOG recovery. Restore the DATA with recover_start ... data and then continue with recover_replace arch log Greetz, SIEGENIA-AUBI KG Informationsw

AW: dbproc + dynamic sql

Norbert Felde wrote : >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 ( > I

log file consistency check

20041013 Time00104818 Server masterdb DatabaseECCENTXD Kernel Version Kernel7.5.0Build 014-121-073-298 Pages Transferred 2152 Pages Left 0 Volumes 1 Medianame ARCH Location

kernal crash - please help !!!

Hi, I´ve just made an upgrade from 7.4.3.32 to 7.5.0.18. After upgrading all seems ok. When I start our J2EE-Application with the latest JDBC-Driver (7.6.0.0.3034) I get a kernel crash after a few minutes of operation. In fast mode there is no cause except 2004-10-13 08:28:14 0 12853 DBST