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/[EMAIL PROTECTED]

-- 
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]

-- 
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]

-- 
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to