ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum Index » Search

 Search found 4 matches
Author Message
  Topic: Insert Error in ESQL with single quotes
ubbii

Replies: 13
Views: 21764
 PostForum: WebSphere Message Broker (ACE) Support   Posted: Wed May 24, 2006 3:19 am   Subject: Insert Error in ESQL with single quotes
Could he fix the problem passing the fields as parameters to the SQL or if using a SQL passthrough ?

Normally this stuff only happens if you are passing the char field as value and not as paramete ...
  Topic: Insert Error in ESQL with single quotes
ubbii

Replies: 13
Views: 21764
 PostForum: WebSphere Message Broker (ACE) Support   Posted: Wed May 24, 2006 3:15 am   Subject: Insert Error in ESQL with single quotes
Hi ubbii,

I think you will simply have to talk to the sender of the data about which possible fields could have this type of bottlenecks...I would expect fields like "Description" to have special c ...
  Topic: Insert Error in ESQL with single quotes
ubbii

Replies: 13
Views: 21764
 PostForum: WebSphere Message Broker (ACE) Support   Posted: Wed May 24, 2006 2:22 am   Subject: Insert Error in ESQL with single quotes
Thanks for your reply. However, there're lot of places that we are using such INSERT function and each function has a lot of parameters. Is there any way that I can fix this problem without adding som ...
  Topic: Insert Error in ESQL with single quotes
ubbii

Replies: 13
Views: 21764
 PostForum: WebSphere Message Broker (ACE) Support   Posted: Tue May 23, 2006 11:42 pm   Subject: Insert Error in ESQL with single quotes
We have such ESQL code in our project:
CREATE FUNCTION Main() RETURNS BOOLEAN
BEGIN
CALL CopyMessageHeaders();
-- CALL CopyEntireMessage();
DECLARE SEQ_NO INTEGER;
DECLARE MSG_NAME CHA ...
Page 1 of 1

Jump to:  
Protected by Anti-Spam ACP
  
 


Theme by Dustin Baccetti
Powered by phpBB © 2001, 2002 phpBB Group

Copyright © MQSeries.net. All rights reserved.