Problems with TRUNC function

Hello, It seems I have a problem :(( I can't get TRUNC function to work expected. TRUNC only seems to work when the second parameter does not come from database (e.g. TRUNC(measurement, 2) works perfectly well). If it's comes from a table, then it returns the original parameter instead of truncat

RE: Urgent: Errors [-8] and [-3007] after restoring database

> [-8]: Execution failed, parse again. > or > [-3007]: Invalid sequence of DML and DDL statements. do you have any defect indices you should recreate? Greetz, SIEGENIA-AUBI KG Informationswesen i.A. Markus Döhr SAP-CC/BC, SAPDB-DBA Tel.:+49 6503 917-152 Fax: +49 6503 917-7152 E-Ma

Urgent: Errors [-8] and [-3007] after restoring database

Hello! I run SAP DB 7.4.3 on a Linux machine. After restoring a database instance from a backup file I get the following errors when processing data: [-8]: Execution failed, parse again. or [-3007]: Invalid sequence of DML and DDL statements. The errors occure in any case of data processing (inser

Locks, Isolations levels

Hi, I have one question about locks. I have following code: client1: begin tran insert into t1 values (1, 2, 3) client2: select * from t1 -- now this client2 is stopped until client1: commit/rollback I tried different isolation levels on client1, but in all cases it was the same. Isn't there any

RE: several log questions #2

> -Original Message- > From: Mischa Orlowski [mailto:[EMAIL PROTECTED] > Sent: Monday, January 05, 2004 1:48 PM > To: [EMAIL PROTECTED] > Subject: several log questions #2 > > > Hi there, > > unfortunately nobody answered my last question. I hope this > try is more successfull. Thank

RE: AutoBackup Tools

Hello Ali, after creating a suitable backup medium (e.g. "dbmcli -d TST -u dbm,dbm medium_put FileMedium d:\xxx FILE DATA"), open a Windows Explorer and go to Desktop->My Computer->Control Panel->Scheduled Tasks. As creating a new file in a normal folder, create a "New->Scheduled Task". Use the

RE: PACKET_SIZE and jdbc

Hallo Alexander, It works like a charme with only the jdbc driver of 7.4.3.30 over the 7.4.3.17 db engine. Anyways, I will do the update of the engine too, as you said me that's better to do it. Another comment: from the download page, it is not clear that the jdbc driver has been updated, as th

RE: Problems with MaxDBProxy

Andris, the development version of both database (7.5.00.08) and proxy (1.0 alphy) that you can find on "http://www.mysql.com/downloads/maxdb-dev.html"; are necessary. This is due to a change in authentification and therefore it will not be possible to connect the the proxy to any database bef

Re: Problems with MaxDBProxy

Hello Dirk, Happy New Year to You too! My question was more about versions (ie, if Alpha 7.05.00.08 MaxDB proxy would connect to Production 7.05.00.05 database). I tried, among a lot of other combinations, the command line parameters you suggested, but still mysql complained that "No database is s

RE: Problems with MaxDBProxy

Hello and a happy new year to everyone! There were several questions on this list regarding the MaxDBProxy. First of all if the proxy is started the database it should connect must be specified. E.g.: >MaxDBProxy --console --dbserver="p861971" --dbname="TestDB" TestDB is the MaxDB-Database, p8

AW: several log questions #2

Hello Mischa, [...] >Second question: >What is it good for having more than one "normal-not mirrored" logfile when >u use automatic backup? The automatic log backup starts to work if log_segment_size log pages were written to the log. In the default case this is after 1/3 used logsize and then o