INSERT .. UPDATE DUPLICATES - no trigger is fired

ID = 1, TXT = 'Text' UPDATE DUPLICATES // INSERT TB SET ID = 1, TXT = 'Text (updated)' UPDATE DUPLICATES // after 2nd insert there is only 1 row in the LOG table (with text insert). Thank you for support. Dusan -- Dusan Kolesar Helsinska 19 040 13 Kosice Sl

Re: Row too long (-2000)

Hello Elke, You're right, on 7.6.0.37 it works correctly. Thank you, Dusan -- Dusan Kolesar Helsinska 19 040 13 Kosice Slovakia e-mail primary : [EMAIL PROTECTED] e-mail alternative : [EMAIL PROTECTED] ICQ# : 160507424 On Tue, 24 Jul 2007 11:53:55 +0200, Zietlow, Elke <[EMAIL P

Row too long (-2000)

sg from logTb left join inTb on logTb.Id = inTb.LogTb_Id left join outTb on logTb.Id = outTb.LogTb_Id Length of Substr (Column, 1, n) is n but not Length of Column type. Is there any way how to restrict length of output columns ??? Thank you very much for support. Regards, Dusan -- Dusan Kol

Re: String to number conversion

Hello, thank you very much. It is working correctly. Nice solution. Dusan On Tue, 19 Jun 2007 20:03:06 +0200, Lukasz Misztal <[EMAIL PROTECTED]> wrote: Dusan, try to create own function, for basic example: CREATE FUNCTION GETASNUMERIC (s1 VARCHAR) RETURNS NUMERIC AS IF UPPER(s1) = LOWER(s1

String to number conversion

Hello, I want to convert Varchar ASCII column to Integer data type. When I'm using NUM () function and my string column contains characters that cannot be interpreted as a numeric value statement returns me an error. Is it possible to convert chracters to numbers, while entries that cannot be

Migration 7.6.00.16 to 7.6.00.37

ormat ? Thank you for support. Regards Dusan -- Dusan Kolesar Helsinska 19 040 13 Kosice Slovakia e-mail primary : [EMAIL PROTECTED] e-mail alternative : [EMAIL PROTECTED] ICQ# : 160507424 -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe:

Database hangs, deadlock detection

properly? Thank you for support Dusan -- Dusan Kolesar Helsinska 19 040 13 Kosice Slovakia e-mail primary : [EMAIL PROTECTED] e-mail alternative : [EMAIL PROTECTED] ICQ# : 160507424 -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe:http://li

Re: CHAR(a,t) AND LIMIT functions

r version 7.6.0.16 unfortunately (we are using mostly this version). Any idea about those problems ? Kind regards Xavier. -- Dusan Kolesar Helsinska 19 040 13 Kosice Slovakia e-mail primary : [EMAIL PROTECTED] e-mail alternative : [EMAIL PROTECTED] ICQ# : 160507424 -- MaxDB Discu

Re: Dinamic statement in trigger

On Mon, 15 Jan 2007 14:53:14 +0100, Anhaus, Thomas <[EMAIL PROTECTED]> wrote: Dusan Kolesar wrote : >> >> Hello, >> is it possible to access trigger variables in dinamic sql statement: >> >> CREATE TRIGGER EMPLOYEE_UPDATE FOR EMPLOYEE

Re: Dinamic statement in trigger

On Mon, 15 Jan 2007 08:27:22 +0100, Anhaus, Thomas <[EMAIL PROTECTED]> wrote: Dusan Kolesar wrote : Hello, is it possible to access trigger variables in dinamic sql statement: CREATE TRIGGER EMPLOYEE_UPDATE FOR EMPLOYEE AFTER UPDATE EXECUTE ( VAR EVENTTABLEID FI

Dinamic statement in trigger

every column of table "EMPLOYEE" but returns an error. Can I obtain such result in trigger code ? Thank you for your support, Dusan. -- Dusan Kolesar Helsinska 19 040 13 Kosice Slovakia e-mail primary : [EMAIL PROTECTED] e-mail alternative : [EMAIL PROTECTED] ICQ# : 160507424

Database migration 7.6.00.34 to 7.6.00.16

Hello, I'm using MaxDb 7.6.00.16 and 7.6.00.34 on WindowsXp HE SP2. I need to migrate database instance from 7.6.00.32 to 7.6.00.16 BackUp in 7.6.00.32 and restore database in 7.6.00.16 doesn't work. Any suggestions ? Thanks Dusan -- Dusan Kolesar Helsinska 19 040 13 Kosice Slova

Re: Conversion Varchar BYTE -> Varchar ASCII

On Fri, 11 Aug 2006 10:56:18 +0200, Zabach, Elke <[EMAIL PROTECTED]> wrote: My database parameters are: _UNICODE NO DEFAULT_CODE ASCII Dusan Kolesar wrote: Hello Elke, It is not working. When I do SET msgAscii = ASCII (msgByte); Error --- Int

Re: Conversion Varchar BYTE -> Varchar ASCII

On Fri, 11 Aug 2006 10:56:18 +0200, Zabach, Elke <[EMAIL PROTECTED]> wrote: My database parameters are: _UNICODE NO DEFAULT_CODE ASCII Dusan Kolesar wrote: Hello Elke, It is not working. When I do SET msgAscii = ASCII (msgByte); Error --- Int

Conversion Varchar BYTE -> Varchar ASCII

this ?? -- Dusan Kolesar Helsinska 19 040 13 Kosice Slovakia e-mail primary : [EMAIL PROTECTED] e-mail alternative : [EMAIL PROTECTED] ICQ# : 160507424 -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Conversion Varchar ASCII -> Varchar BYTE

Hello Elke, thank you very much, it works. Dusan On Fri, 09 Jun 2006 08:17:19 +0200, Zabach, Elke <[EMAIL PROTECTED]> wrote: Dusan Kolesar wrote: Hello, I'm using MaxDb 7.6.0.16 on WinXp HE + SP2. I need to convert Varchar ASCII variabl into Varchar BYTE inside stored pro

Conversion Varchar ASCII -> Varchar BYTE

Hello, I'm using MaxDb 7.6.0.16 on WinXp HE + SP2. I need to convert Varchar ASCII variabl into Varchar BYTE inside stored procedure. Can you advice how to do this ?? Thanks, Dusan -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe:http://list

Re: Recovery problem

ecover and initialize the DB. Greetz, -- Dusan Kolesar Helsinska 19 040 13 Kosice Slovakia e-mail primary : [EMAIL PROTECTED] e-mail alternative : [EMAIL PROTECTED] ICQ# : 160507424 -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe:

Recovery problem

In DbmGui I choose "Instance" -> "Recovery" -> "Recovery with initialization" Then I select my medium "Recovery" I have created it before and restore. Can you send me dbmcli script equivalent to DbmGui(Recovery with initialization) function ?? Th

Re: AW: Database freezing MaxDb7.6

ommit mode ? Transaction ends when select / insert statement ends, or when whole procedure / trigger ends ? Thannks for help -- Dusan Kolesar Helsinska 19 040 13 Kosice Slovakia e-mail primary : [EMAIL PROTECTED] e-mail alternative : [EMAIL PROTECTED] ICQ# : 160507424 On Mon, 20 Mar 2006 08:50:05

Re: AW: Database freezing MaxDb7.6

you for your support. Regards, Dusan Dusan Kolesar Helsinska 19 040 13 Kosice Slovakia e-mail primary : [EMAIL PROTECTED] e-mail alternative : [EMAIL PROTECTED] ICQ# : 160507424 On Wed, 15 Mar 2006 13:16:57 +0100, Zabach, Elke <[EMAIL PROTECTED]> wrote: Dusan Kolesar wrote: Hello Mar

Re: Database freezing MaxDb7.6

Hello Markus So, the database is waiting for a lock release. But what can cause this datatbase state ? Can you advice me some DB parameters to change ? Are there some parameters to unlock tables automaticly ? Or should I change something in my procedure and trigger code ? Dusan Kolesar Helsinska

Re: Data Volume Size

or criminal liability. -- Dusan Kolesar Helsinska 19 040 13 Kosice Slovakia e-mail primary : [EMAIL PROTECTED] e-mail alternative : [EMAIL PROTECTED] ICQ# : 160507424 -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Database freezing MaxDb7.6

different options to trace, so I'm confused what to trace. Or should I switch on all? The important think is, that before we have migrated from SapDb v7.4.6.32 on WinXp, no such freezing occured. -- Dusan Kolesar Helsinska 19 040 13 Kosice Slovakia e-mail primary : [EMAIL PROTECTED] e

How to define 2 FK into 1 table

Hello I want to define folowing DB structure: CREATE TABLE "SYSUSER" ( "ID" Integer NOT NULL DEFAULT SERIAL, "TSTAMP" Timestamp NOT NULL DEFAULT TIMESTAMP, "NAME" Varchar(30) ASCII NOT NULL, "PASSWORD" Varchar(30) ASCII NOT NULL, PRIMARY KEY (

How to define 2 FK into 1 table

REFERENCES "SYSUSER" ("ID") ON DELETE SET DEFAULT, FOREIGN KEY "SYSUSER_CHANGE_ID" ("CHANGE_USER_ID") REFERENCES "SYSUSER" ("ID") ON DELETE SET DEFAULT ) // SaxDb says: General error;-7040 POS(1) Referential constraint not allowed Table Ad

Trigger fireing

Hello list, I'm using MaxDb 7.6.00.16 on WinXP Home, SP2. I find that UPDATE trigger fires always when I call UPDATE, even though no value is changed. In version SapDb 7.4.3.32 (I heve used before) when UPDATE statement didn't change any value then no update trigger fired. Is it a new feature in

Re: AW: INFO_STATE table does not exist

NITOR_READ, MONITOR_TIME, MONITOR_SELECTIVITY, MONITOR_ROWNO parameters but none seems to be right Database Trace: Off SYSINFO.ACTIVECONFIGURATION (Parameter TRACE_*) - there are 79 such params Dusan On Thu, 05 Jan 2006 11:45:44 +0100, Zabach, Elke <[EMAIL PROTECTED]> wrote: Dus

Re: AW: INFO_STATE table does not exist

ON, "Autosave" AS AUTO_LOG, "Command Monitoring" AS CMND_MON, "Kernel Trace" AS KERNEL_TRACE FROM INFO_STATE Can you help me where to find them? Dusan On Thu, 05 Jan 2006 09:09:33 +0100, Zabach, Elke <[EMAIL PROTECTED]> wrote: Dusan Kolesar wr

INFO_STATE table does not exist

Hello list MaxDB: W32/INTEL 7.6.00 Build 016-123-109-428 OS: WinXP Home, SP2 Where is DOMAIN.INFO_STATE table? I have used version 7.4.3.32 before and there was such a table. Or is any other way how to read this informations using ODBC? Now the only way I have found to obtain these information

Re: SQL studio problem

TED]> wrote: Hi Dusan, are you sure your system tables are current in your database? Maybe reloading them might help (load_systab in dbmcli). Best wishes, Martin. -Original Message- From: Dusan Kolesar [mailto:[EMAIL PROTECTED] Sent: Mittwoch, 30. November 2005 10:45 To:

Re: SQL studio problem

On Wed, 30 Nov 2005 11:12:31 +0100, Koetter, Thomas Theodor <[EMAIL PROTECTED]> wrote: Hello Dusan -Original Message- From: Dusan Kolesar [mailto:[EMAIL PROTECTED] Sent: Mittwoch, 30. November 2005 10:45 To: SAP DB mailing list Subject: SQL studio problem Hello list, I'm

SQL studio problem

Hello list, I'm using MaxDb 7.6.0.16 on WinXP Home vith SP2. I have installed GUI SQL Studio (maxdb-sqlstudio-setup-7_6_00-106556.exe). Before I installed new version I uninstalled my old SQL studio 7.4 first. My installation was succesfull (no error occured). When I start SQL Studio and when I

Error -9205

very usefull, but my real DB schema is much more complicated. So I need such a chema: 2 tables with ref.integrity with triggers and stored procedure call. How to aviod this error? Is it some bug? Thank you, Dusan. -- Dusan Kolesar Helsinska 19 040 13 Kosice Slovakia e-mail : [EMAIL PROTECTED] ICQ# : 160507424 -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: AW: Concatenation in GROUP BY

On Mon, 31 Oct 2005 15:14:15 +0100, Zabach, Elke <[EMAIL PROTECTED]> wrote: Dusan Kolesar wrote: Hello list, Is it posible to do in SAP DB something like: SELECT CONCAT (column1 || ', ') FROM t1 GROUP BY column2 Manual says: The GROUP clause allows the functions SUM, AVG

Concatenation in GROUP BY

ps of rows within a result table. Or is there any other way how to obtain such a result? Thank you for your support. Dusan -- Dusan Kolesar Helsinska 19 040 13 Kosice Slovakia e-mail : [EMAIL PROTECTED] ICQ# : 160507424 -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.co

Change column order

Hello list, is it posible to change column order in the table ? I want to add some column into the table, but not to the end. Is it posible in SapDb, or I must drop table firs and recreate it with correct order? Thank you, Dusan -- Dusan Kolesar Helsinska 19 040 13 Kosice Slovakia e-mail

General error;-9205

, Dusan -- Dusan Kolesar Helsinska 19 040 13 Kosice Slovakia e-mail : [EMAIL PROTECTED] ICQ# : 160507424 -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Generate result in the range

, Desc1 Is it posible to generate numbers between some values? Thank you for your support. Dusan -- Dusan Kolesar Helsinska 19 040 13 Kosice Slovakia e-mail : [EMAIL PROTECTED] ICQ# : 160507424 -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe:http

Query sometimes works and sometimes not.

ement again with the same parameters, same conditions, same database schema everything runs OK. Can you help me please, what is reason for this error. Thank you very much. Dusan -- Dusan Kolesar Helsinska 19 040 13 Kosice Slovakia e-mail : [EMAIL PROTECTED] ICQ# : 160507424 -- MaxDB Discussion Mailing Lis

Re: show tables / describe table

]> wrote: Hi List, I am new to MAXDB and want to know is there any function in MAXDB like MySQL to show all tables in a database and describe table in a database. Mysql> show tables; Mysql> describe table. Thanks in Advance. MAXDB PHP -- Dusan Kolesar Helsinska 19 040 13 Kosice Slovaki

Recovery problem

start instance after restoring an error occurs. The restoring function works only when I create a new DB instance and in the Install Wizard (last installation step) I choose "install instance for recovery". What am I doing bad ?? Dusan -- Dusan Kolesar Helsinska 19 040 13 Kosice Slovakia

Asynchronous event

Hello, Is it possible to rise some event from one session to all other sesions connected into database instance? Maybe some error code or error exception? Thanks, Dusan -=x=- Skontrolované antivírovým programom NOD32 -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb T

Re: AW: Daylight Saving Time

g SQLMODE Internal and I don't plan to change it. My problem is, that my client program inserts into my table values directly from GPS device and this data includes UTC time. So I need to correct it into normal (kitchenclock) time. Even thought thank you for your response. Dusan Kolesar -- Dusan Kole

Re: AW: Daylight Saving Time

#x27;m using SQLMODE Internal and I don't plan to change it. My problem is, that my client program inserts into my table values directly from GPS device and this data includes UTC time. So I need to correct it into normal (kitchenclock) time. Even thought thank you for your response. Dusan Kolesar

Daylight Saving Time

October at 1:00 UTC. Is something implemented in the SapDb which helps me detect if the Timestamp is in Daylight saving zone or not? Thank you for all your support. -- Dusan Kolesar Helsinska 19 040 13 Kosice Slovakia e-mail : [EMAIL PROTECTED] ICQ# : 160507424 -=x=- Skontrolované antivírovým

Automatic DB start

name and password is visible for other users. Is any way to start DB witout publishing DB name and password and Autosave Log set ON? Thank you very much. Regards, Dusan -- Dusan Kolesar Helsinska 19 040 13 Kosice Slovakia e-mail : [EMAIL PROTECTED] ICQ# : 160507424 -=x=- Skontrolované antivír

Re: AW: Join performance

hint but I'm not sure if this would help. The syntax is select /*+ordered */ logfile.*, car.name from logfile outer join car on logfile.car_id = car.id Kind regards Holger -Ursprüngliche Nachricht----- Von: Dusan Kolesar [mailto:[EMAIL PROTECTED] Gesendet: Montag, 19. Juli 2004 16:

Join performance

Hello, I have two tables: CREATE TABLE "ADMIN"."CAR" ( "ID" IntegerNOT NULLDEFAULT SERIAL (1), "TSTAMP" TimestampDEFAULT TIMESTAMP, "PARENT_ID" IntegerDEFAULT -1, "IMAGE_ID" IntegerDEFAULT -1, "NAME"

Port configuration

Hello, I have one SAP DB 7.4.3 installation my computer. Is it posible to configure 2 (or more) DB instances, to listen on 2 (or more) TCP/IP ports? I'm using Windows OS and I'm connecting via ODBC. If there is no such possibility, how can I recognise which TCP/IP packet belongs to which DB in

Re: AW: Timestamp Trigger

Hello Tobias, Try this: CREATE TRIGGER TEST_TIMESTAMP FOR TEST AFTER UPDATE EXECUTE ( IF (OLD.DATUM <> NEW.DATUM) THEN RETURN; UPDATE USER.TEST SET DATUM=TIMESTAMP WHERE TEST.ID=:NEW.ID; ) and when you make UPDATE don't update tstamp coluumn. Regards, Dusan. On Tue, 13 Jul 2004 09:45:06 +02

Dynamic statemant and Fetch cursor

#x27; || eventTb || ' WHERE ROWNO <= 1'; EXECUTE stmt; FETCH INTO :id; INSERT TEST SET ID=:id; END; But I get an error : "Unknown result table" on the fetch command. Don't you know any solution for my problem ? Thank you for help. Regards

Trouble with calling dbproc in the trigger

ADMIN.TEST; SELECT NOW() FROM ADMIN.DUAL; /* some insert, update, delete, select statement */ ) and when I execute my insert again everything is OK. Is it bug, or am I doing something wrong? Thank for your help and support. Regards, Dusan -- Dusan Kolesar Helsinska 19 040 13 Kosice Slovakia

Re: Linux installation problem

Thank you very much, it works. Regards Dusan. On Mon, 21 Jun 2004 14:22:57 +0200, Timo Denis <[EMAIL PROTECTED]> wrote: Try export LD_ASSUME_KERNEL="2.2.5" and afterwards x_server start and dbmcli stuff! Regads, Timo Dusan Kolesar wrote: Hello, I'm running SapDb 7.4.3.3

Cursor and dynamic statement

not correct - SQL grammer does not allows them. Regards Dusan. -- Dusan Kolesar Helsinska 19 040 13 Kosice Slovakia e-mail : [EMAIL PROTECTED] ICQ# : 160507424 -=x=- Skontrolované antivírovým programom NOD32 -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Linux installation problem

Dusan -- Dusan Kolesar Helsinska 19 040 13 Kosice Slovakia e-mail : [EMAIL PROTECTED] ICQ# : 160507424 -=x=- Skontrolované antivírovým programom NOD32 -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Database link in Oracle

.3.1 Database Links -- Dusan Kolesar Helsinska 19 040 13 Kosice Slovakia e-mail : [EMAIL PROTECTED] ICQ# : 160507424 -=x=- Skontrolované antivírovým programom NOD32 -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: AW: AW: AW: AW: AW: AW: Combine cursors

and thank you. Regards, Dusan On Fri, 4 Jun 2004 09:23:02 +0200, Zabach, Elke <[EMAIL PROTECTED]> wrote: Dusan Kolesar wrote: Hello Elke, you are absolutly right. There is a endless loop. But I don't see eny reason for it. My result is OK into correct treelevel (I have nodes in leve

Re: AW: AW: AW: AW: AW: Combine cursors

PARENT_ID X Y can be found with even level-nos Y X can be found in the odd level-nos can be seen. One level will add 2 additional records, the other level will add 14. Therefore the check should be not too hard. Elke SAP Labs Berlin -Ursprüngliche Nachric

Re: AW: Combine cursors

On Thu, 27 May 2004 15:50:58 +0200, Zabach, Elke <[EMAIL PROTECTED]> wrote: Dusan Kolesar wrote: Hello Elke, When I try: DECLARE C1 CURSOR FOR SELECT * FROM ADDRESS FOR REUSE // DECLARE C2 CURSOR FOR WITH RECURSIVE PX2 (ID, PARENT_ID, NAME, FOLGE, TREELEVEL) AS ( SELECT ID, PAR

Re: Combine cursors

hank you. Dusan On Thu, 27 May 2004 09:30:52 +0200, Zabach, Elke <[EMAIL PROTECTED]> wrote: Dusan Kolesar wrote: Hello, I have two cursors. First is for select lines from 2 tables. This is my semi result. This result I want to sort also. DECLARE C1 CURSOR FOR WITH RECURSIVE PX (ID, PARENT

Combine cursors

Hello, I have two cursors. First is for select lines from 2 tables. This is my semi result. This result I want to sort also. DECLARE C1 CURSOR FOR WITH RECURSIVE PX (ID, PARENT_ID, NAME, TYPE) AS ( SELECT ID, PARENT_ID, NAME, 1 FROM ADMIN.CAR UNION ALL SELECT ADDRESS.ID, ADDRESS.PAR

Re: Sort tree data Preorder

Hello Elke, Thank you very much, for your advice. It is working very nice for me. Dusan On Fri, 21 May 2004 09:13:10 +0200, Zabach, Elke <[EMAIL PROTECTED]> wrote: Dusan Kolesar wrote: Hello, This is more SQL problem then SAP DB problem but may bee somebody can help me. Or sombody knows

Sort tree data Preorder

Hello, This is more SQL problem then SAP DB problem but may bee somebody can help me. Or sombody knows links where solved this problem. I have a table ADDRESS. Data represent tree structure. PARENT_ID points into record of the same table. CREATE TABLE "ADDRESS" ( "ID" Integer N

Re: Again ignore trigger after update

e trigger as normal If Flag = 1, no triggered action Transaction: If t1 = 40 update control_table set flag = 1 Else update control_table set flag = 0 End update dba.atab Inside your trigger: First get the flag value from control_table If flag = 0 then . trigger body... End if; ... so

Re: Again ignore trigger after update

Hello, I think that statement inside trigger tr_upd_atab_1 is incorrect: update dba.atab_2 set t2 = t2 + :val2, t3 = t3 + :val3 where t1 = 40 ignore trigger; I have searched for it in documentation but I didn't found "ignore trigger" statement. I think there is no way how to ignore trigger just

Re: [SPAM] - cant remove failed instance - Found word(s) remove list in the Text body.

AIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Dusan Kolesar Helsinska 19 040 13 Kosice Slovakia e-mail : [EMAIL PROTECTED] ICQ# : 160507424 -- MaxDB Discussion Mailing List For l

Re: Autostart MAXDB

Hello, When you set service STARTUP type = automatic, DB instance will be running on Windows startup, but Autolog feature will bee OFF. So my solution is: Using regedit.exe add following key into registry database: [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Run] "SapDb"="dbmcli

Re: Varchar BYTE concatenation problem

Thanks a lot, It works. Dusan On Thu, 15 Apr 2004 18:40:40 +0200, Zabach, Elke <[EMAIL PROTECTED]> wrote: Dusan Kolesar wrote: Hello, I have a problem with Varchar BYTE concatenation. CREATE TABLE "ADMIN"."TEST" ( "VC" Varchar (50) BYTE ) // CRE

Re: Varchar BYTE concatenation problem

m via a search condition, the values are equal. Best Regards, Thomas -Original Message- From: Dusan Kolesar [mailto:[EMAIL PROTECTED] Sent: Mittwoch, 14. April 2004 10:31 To: SAP DB mailing list Subject: Varchar BYTE concatenation problem Hello, I have a problem with Varchar BYTE concatenat

Varchar BYTE concatenation problem

Hello, I have a problem with Varchar BYTE concatenation. CREATE TABLE "ADMIN"."TEST" ( "VC" Varchar (50) BYTE ) // CREATE DBPROC TESTVC AS VAR msgVarchar(100) BYTE; byteDistLo Varchar(1) BYTE; byteDistHi Varchar(1) BYTE; BEGIN SET byteDistLo = x'00'; SET byteDistHi =

Convert to Varchar BYTE

Hello, I want to convert Integer (byte) value into Varchar BYTE variable. So, I created procedure to perform this task. CREATE DBPROC NUM2VARCHARBYTE (IN NUMBER INTEGER, OUT CHARBYTE VARCHAR (2) BYTE) AS BEGIN CASE NUMBER WHEN 0 THEN CHARBYTE = X'00'; WHEN 1 THEN CHARBYTE = X'01'; W

Re: Update columns with not NULL

Thank you wery much Elke, this is exactly what am I searching for. Regards, Dusan On Wed, 7 Apr 2004 10:34:27 +0200, Zabach, Elke <[EMAIL PROTECTED]> wrote: Dusan Kolesar wrote: Hello, Is it posible to make : update tab1 (col1, col2) values (:myvar1, :myvar2) where id=1; But I want to

Update columns with not NULL

Hello, Is it posible to make : update tab1 (col1, col2) values (:myvar1, :myvar2) where id=1; But I want to update only columns where myvarX is not NULL, when the value is NULL I want to let previous value of column. I know when I divide my query : if (myvar1 <> NULL) then update tab1 (col1) val

Problem with LONG BYTE

Hello, I'm using SapDB 7.4.3 BUILD 031-123-060-910 WinXp. I'm using LONG BYTE column for storing .jpg images in my database. But when I unload LONG values back into the file, the new file is sometimes different like original. When the file size is under about 132k my images are OK. Bu When it is m

Re: Trigger problem - database crash

he time to go back to 7.4.03.17. Best Regards Thomas -Original Message- From: Dusan Kolesar [mailto:[EMAIL PROTECTED] Sent: Mittwoch, 10. März 2004 14:03 To: Zabach, Elke Cc: SAP DB mailing list Subject: Re: Trigger problem - database crash On Wed, 10 Mar 2004 11:17:11 +0100, Zabach, Elke <

Re: Trigger problem - database crash

On Wed, 10 Mar 2004 11:17:11 +0100, Zabach, Elke <[EMAIL PROTECTED]> wrote: Dusan Kolesar wrote: Hello, I have one problematic trigger. When I insert into LEVEL table, all database instance crash down. When there is the same trigger but without 2 lines: line 16 and 31 is EXECUTE inse

Trigger problem - database crash

Hello, I have one problematic trigger. When I insert into LEVEL table, all database instance crash down. When there is the same trigger but without 2 lines: line 16 and 31 is EXECUTE insertstmt; everything is running and in the debug table TEST I can see all correct insert statemants. Trigger is

Re: Insert returns Id

On Mon, 08 Mar 2004 17:07:24 +0100, Uwe Schneider <[EMAIL PROTECTED]> wrote: Hi Dusan, Dusan Kolesar schrieb: Hello, I have one master table: CREATE TABLE "LOGFILE" ( "ID" IntegerNOT NULL DEFAULT SERIAL (1), "DESCR"

Insert returns Id

row into table LOGFILE. Inside this trigger I want to set collumn LOGFILE_ID into new inserted ID value of LOGFILE table. Is it posible, to find out new inserted ID? I think in MySql LAST_INSERT_ID () makes this. Thank you for advice. Regards, Dusan. -- Dusan Kolesar Helsinska 19 040 13 Kosic

Re: Memory leak on Serv.exe

On Thu, 26 Feb 2004 17:01:12 +0100, Koetter, Thomas Theodor <[EMAIL PROTECTED]> wrote: Hi Dusan, FYI, please install the latest ODBC driver. At least the previous ones had an memory leak by reusing connections after SQLDisconnect. However, the ODBC problem is not directly related to the memory us

Re: Phantom instance? How to remove?

.. and nothing is happen. When I run service.exe -r -s fleet service.exe -r -q fleet I have the same result. Dausn -- Dusan Kolesar Helsinska 19 040 13 Kosice Slovakia e-mail : [EMAIL PROTECTED] ICQ# : 160507424 -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb

Memory leak on Serv.exe

h ADO) together with Apache module and then SOAP connection, Used memory on process serv.exe (SAP DB - Communication server) is raising (aprox. 150KB/min (dependent on traffic)) Are there any parameters or configurations settings for Serv.exe ? Or where can be the problem ? regards, Dusan -- Dusan

Re: Insert into more tables

On Wed, 11 Feb 2004 14:06:28 +0100, Anhaus, Thomas <[EMAIL PROTECTED]> wrote: Dusan Kolesar wrote : Hello, I want to insert row into more then one table. List of tabels into which I want to insert is in the next table: CREATE TABLE "ADMIN"."EVENT_TABLES" ( "TB_

Insert into more tables

le at all, because in the manual is written: INSERT [INTO] ... ::= [.] There is nothing like table name can be a variabe. Thank you very much. Dusan -- Dusan Kolesar Helsinska 19 040 13 Kosice Slovakia e-mail : [EMAIL PROTECTED] ICQ# : 160507424 -- MaxDB Discussion Mailing List For list archiv

Re: Order by and RowNo

neric enough? regards, Rick van der Lans Thank you, this is very interesting and useful qeury. Dusan -- Dusan Kolesar Helsinska 19 040 13 Kosice Slovakia e-mail : [EMAIL PROTECTED] ICQ# : 160507424 -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscr

Re: Log

On Tue, 3 Feb 2004 10:40:21 +0100, Heinrich, Tilo <[EMAIL PROTECTED]> wrote: What database version and which administration tool are you using? Best Regards, Tilo Heinrich SAP Labs Berlin -Original Message- From: Dusan Kolesar [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 27,

Re: Order by and RowNo

e: Hi Dusan, Will this work for you: SELECT * FROM table WHERE = (select max() from table) If you use min, you will get the row with the lowest value. best regards, Rick van der Lans -- Dusan Kolesar Helsinska 19 040 13 Kosice Slovakia e-mail : [EMAIL PROTECTED] ICQ# : 160507424 -- MaxDB Disc

Order by and RowNo

lt;=1 but I obtained an error: Missing delimiter: )and there was "ORDER" highlighted. Thanks for any idea, Dusan -- Dusan Kolesar Helsinska 19 040 13 Kosice Slovakia e-mail : [EMAIL PROTECTED] ICQ# : 160507424 -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/m

Re: To Timestamp

On Tue, 27 Jan 2004 15:58:46 +0100, Dusan Kolesar <[EMAIL PROTECTED]> wrote: Hello, I have year, mounth, day, minutes, secundes as Integer. How can I make timestamp value from integers. I want to do it inside trigger. Thanks for your help. Dusan I have tryed : CREATE TRIGGER GSM_IN_INSE

To Timestamp

Hello, I have year, mounth, day, minutes, secundes as Integer. How can I make timestamp value from integers. I want to do it inside trigger. Thanks for your help. Dusan -- Dusan Kolesar Helsinska 19 040 13 Kosice Slovakia e-mail : [EMAIL PROTECTED] ICQ# : 160507424 -- MaxDB Discussion Mailing

Log

Hello, Is it posible turn off log? And how to delete existing log. Thank you Dusan -- Dusan Kolesar Helsinska 19 040 13 Kosice Slovakia e-mail : [EMAIL PROTECTED] ICQ# : 160507424 -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe:http

Trigger, decode

Hello I have two tables: CREATE TABLE "ADMIN"."HWMSG" ( "ID" IntegerNOT NULLDEFAULT SERIAL (1), "TSTAMP" Timestamp, "MSGLEN" Integer, "MSG" Varchar (1024) BYTE, "MSGTYPE" Integer,

Re: Insert in a LONG BYTE field, problems

___ MSN Extra Storage: piena libertà di esprimersi e comunicare http://join.msn.com/?pgmarket=it-it&page=hotmail/es2&xAPID=1983&DI=2049&ST=1 -- Dusan Kolesar Helsinska 19 040 13 Kosice Slovakia e-mail : [EMAIL PROTECTED] ICQ# : 160507424 -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Performance diference

directly into DB and make similar query everyting works quick. Even though, thank you very much for all your advices. Dusan On Tue, 13 Jan 2004 10:42:49 +0100, Koetter, Thomas Theodor <[EMAIL PROTECTED]> wrote: Hi Dusan -Original Message- From: Dusan Kolesar [mailto:[EMAIL PROTECTED

Re: Performance diference

erline. So the performance difference doesn't seem to be a result of comunication overhead because 36kB is lower than your monitored threshold. If the ODBC trace, requested by Thomas, doesn't give any hint, perhaps a kernel vtrace (http://sapdb.2scale.net/moin.cgi/VTrace) bring a littl

Re: Performance diference

I use Delphi7 with ODBC connection. On Mon, 12 Jan 2004 15:01:47 +0100, Schroeder, Alexander <[EMAIL PROTECTED]> wrote: How do you insert the image (I.e. what client you are using?) Alexander Schröder SAP DB, SAP Labs Berlin -Original Message- From: Dusan Kolesar [mailto:

Performance diference

"IMAGE"Long BYTE, "IMAGELEN" Integer, PRIMARY KEY ("ID") ) When I insert row with image bigger than 50kB it takes more than 1 minute. When I insert smaller image then it takes aprox. 1 second. What can be reason of this performance diference?

Re: AW: Calling stored procedere

to use: call poc (inparam1, inparam2, ?) At least it works for me. If you have [var]char as parameter don't forget to put them in ' '. Hope that helps Peter -Ursprüngliche Nachricht----- Von: Dusan Kolesar [mailto:[EMAIL PROTECTED] Gesendet: Freitag, 19. Dezember 2003 10:24 An

Calling stored procedere

Hello, when I try to call stored procedure which has no in/out parameters everithing works. call poc1 But how to call procedure whit in/out params? Dusan -- Dusan Kolesar Helsinska 19 040 13 Kosice Slovakia e-mail : [EMAIL PROTECTED] ICQ# : 160507424 -- MaxDB Discussion Mailing List For list

  1   2   >