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 8 matches
Author Message
  Topic: ESQL - EVAL Problem
HemavathyRG

Replies: 15
Views: 12289

PostForum: WebSphere Message Broker (ACE) Support   Posted: Tue May 02, 2017 10:07 pm   Subject: ESQL - EVAL Problem
who ever knows, please update me on this.
  Topic: ESQL - EVAL Problem
HemavathyRG

Replies: 15
Views: 12289

PostForum: WebSphere Message Broker (ACE) Support   Posted: Tue May 02, 2017 6:41 am   Subject: ESQL - EVAL Problem
Any updates....!!!!
  Topic: ESQL - EVAL Problem
HemavathyRG

Replies: 15
Views: 12289

PostForum: WebSphere Message Broker (ACE) Support   Posted: Tue May 02, 2017 4:36 am   Subject: ESQL - EVAL Problem
Did you get it done only by using PASSTHRU statement.
I need help on the same.
I have a select query and input varies depends on the requirement.
How Do I alter my select query just based on the in ...
  Topic: PASSING
HemavathyRG

Replies: 12
Views: 9935

PostForum: WebSphere Message Broker (ACE) Support   Posted: Mon Apr 25, 2016 4:13 am   Subject: Re: need to pass array to the stored procedure


Datasource name is mentioned in the ESQL node properties.

does broker know about the datasource?

Yes.
its configured at broker level as well.

In the call statement if I remove in DATABSE ...
  Topic: PASSING
HemavathyRG

Replies: 12
Views: 9935

PostForum: WebSphere Message Broker (ACE) Support   Posted: Fri Apr 22, 2016 5:28 am   Subject: Re: need to pass array to the stored procedure


Datasource name is mentioned in the ESQL node properties.

does broker know about the datasource?

Yes.
its configured at broker level as well.

In the call statement if I remove in DATABSE ...
  Topic: how to send array to th estored procedure using ESQL.
HemavathyRG

Replies: 5
Views: 2897

PostForum: WebSphere Message Broker (ACE) Support   Posted: Fri Apr 22, 2016 5:26 am   Subject: how to send array to th estored procedure using ESQL.
If you search this site you will find many similar posts.
Have you read any of them?

Seard for something like

stored procedure array

I have searched and got some results in the below link.
...
  Topic: how to send array to th estored procedure using ESQL.
HemavathyRG

Replies: 5
Views: 2897

PostForum: WebSphere Message Broker (ACE) Support   Posted: Fri Apr 22, 2016 1:42 am   Subject: how to send array to th estored procedure using ESQL.
I am using ESQL to send the array to SP.
And I ended up in getting the below exception.
Can any one suggest how to resolve this please.

BIP2322E:Child SQL exception:IM002:0:[Microsoft][ODBC Drive ...
  Topic: PASSING
HemavathyRG

Replies: 12
Views: 9935

PostForum: WebSphere Message Broker (ACE) Support   Posted: Wed Apr 20, 2016 11:58 pm   Subject: need to pass array to the stored procedure
hi kotagiriaashish,
I fallowed what ever u suggested but I ma getting the below exception.
Can you please help me out.

Id Number:BIP2322E:Child SQL exception:IM002:0:[Microsoft][ODBC Driver Mana ...
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.