[prev in list] [next in list] [prev in thread] [next in thread] 

List:       sapdb-general
Subject:    RE: (2) How is exactly is this query too complicated?
From:       Kevin Wilson <Kevin.Wilson () comtrol ! com>
Date:       2005-12-15 15:53:32
Message-ID: DD5056872F0E6A4EB8555318C3F8BCB00B5C61 () exchange-2 ! comtrol ! com
[Download RAW message or body]

Is there any way I can activate these new values without taking the db
offline?

maxdb v7.5.0.23-x64

-----Original Message-----
From: Kevin Wilson 
Sent: Thursday, December 15, 2005 09:47
To: Maxdb (E-mail)
Subject: RE: (2) How is exactly is this query too complicated?


I increased workdata and workstack support parms to their maximums ...
should that do the trick?

-----Original Message-----
From: Kevin Wilson 
Sent: Thursday, December 15, 2005 09:44
To: Maxdb (E-mail)
Subject: (2) How is exactly is this query too complicated?


Found Holgers email about the workdatasize, I'll give that a try and see
what happens.

any other parms like this that we should increase while I am in there to
prevent taking db offline again?

-----Original Message-----
From: Kevin Wilson 
Sent: Thursday, December 15, 2005 09:35
To: Maxdb (E-mail)
Subject: How is exactly is this query too complicated?
Importance: High


SELECT RMA.RMA_ID,RMA.SUMMARY,RMA.NOTE FROM RMA WHERE (UPPER(RMA.NOTE) like
'%RUSTIC%' or UPPER(RMA.NOTE) like '%DRAM%' or UPPER(RMA.NOTE) like '%RAM%')

3 OR statements on a varchar(5000) field should not cause this error, is
there a workaround I can use to fetch my report?

thanks

-- 
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:
http://lists.mysql.com/maxdb?unsub=kevin.wilson@comtrol.com

-- 
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:
http://lists.mysql.com/maxdb?unsub=kevin.wilson@comtrol.com

-- 
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:
http://lists.mysql.com/maxdb?unsub=kevin.wilson@comtrol.com

-- 
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/maxdb?unsub=sapdb-general@progressive-comp.com

[prev in list] [next in list] [prev in thread] [next in thread]