Stack Overflow
Stack Overflow

Questions tagged [extended-sql]

IBM Integration Bus (IIB) specifies Extended Structured Query Language (ESQL) as a programming language used to define and manipulate data within a message flow.

Extended Structured Query Language (ESQL) is used by IBM Integration Bus to define and manipulate data within a message flow.

156 questions
1
vote
2 answers

Acces XMLNSC tag value in ESQL

I need to access some XML values and concatenate them as a file name for output document. The problem is that solution demands the message to be read in BLOB format so ESQL script must first translate the blob to CHARACTER/XMLNSC. See the code…
Jakub Sluka
  • 123
  • 1
  • 14
1
vote
3 answers

Initialize shared variables in a message flow with esql

I'm using IBM Integration Bus Version 10.0.0.15 and I'm looking for an option to intialize shared variables during the startup of a message flow, for example uing the command mqsistartmsgflow. Is there a special procedure or function one can…
Klaus Rohe
  • 21
  • 1
  • 3
1
vote
2 answers

Unable to generate repeating XML element root nodes using XMLNS in IBM Integration Bus

I'm trying to create the response for my soap web service in IBM integration Bus. I'm using ESQL compute node to generate the XML using XMLNS. I have to add some repeating element root nodes to my xml, and that is what I'am facing trouble…
Sivaprasad
  • 151
  • 10
1
vote
1 answer

RestRequest - Special characters - JSON parsing errors have occurred

I have simple RESTRequest node. In response I'm sending JSON from SOAP-UI mockup. JSON looks like this: { "SnapshotVersion": "43f4acca-b11a-4afe-b9bb-30af9864c3a0", "TotalExtraPrice": 0, "TotalPrice": 0, "Příliš žluťoučký Kůň": "úpěl…
Pivoman
  • 4,435
  • 5
  • 18
  • 30
1
vote
1 answer

IIB Collector node esql

I am using a collector node on IIB to collect a set of messages. Can someone help with sample ESQL after collector node to process a message collection? Since I am new to ESQL I am struggling to figure it out. The IBM info center is not very helpful…
user3171821
  • 69
  • 1
  • 12
1
vote
1 answer

How to create a variable in IIB which has scope for each single flow?

I need to create a variable in IIB flow which has to be available through out the flow. I have gone through the variables creation in documentation. As per my understanding, I should create a SHARED variable in ESQL module. But in documentation its…
Rama krishna
  • 51
  • 9
1
vote
2 answers

Trying to add special character (%) sign to variable with following concatenation sign in ESQL, it gives me the the below error

Trying to add special character (%) sign to variable with following concatenation sign, but it gives me the the error: Invalid characters. DECLARE Percent CHARACTER CAST ( ' %' AS CHARACTER CCSID 1208); SET AlocatedAmount = 45 SET InPercent =…
Chris
  • 53
  • 1
  • 7
1
vote
1 answer

How to update the error code in IIB for my pass thro

I am getting 500 error code and its a SOAP format. I see HTML, SOAP 1.1 & SOAP 1.2 formats available for response when there is an exception in my pass thro service for example when wrong endpoint request, it gives 500. I want to change it to 400 or…
Kumar
  • 51
  • 7
1
vote
0 answers

How can I convert a unicode character in XML to an equivalent ASCII character in IBM message broker or IIB10?

I am working on IIB10 right now, and we have a problem with candidate's names sometimes which contain accented/Unicode characters which need to be replaced with its equivalent ASCII character either in ESQL or Java. The input parser in XMLNC.
ankushh
  • 11
  • 3
1
vote
1 answer

Database nodes vs compute nodes (ESQL) in IIB, which performs better?

I understand that the Database nodes in IBM Integration Bus (IIB) toolkit are relatively new, how do they compare to using ESQL in regards to performance? and why would you choose to use one over the other?
I_LIKE_FOO
  • 2,744
  • 3
  • 16
  • 18
1
vote
2 answers

Enrich soap message with ESQL

I am creating a simple flow that receives a message via SOAP and in IIB I treat the message with ESQL. This is my SOAP message: …
Bruno
  • 438
  • 1
  • 5
  • 13
1
vote
0 answers

eSQL - Appending an array from an external query

I'm new with eSQL and my IBM resource doesn't seem to have the answer. I currently have this code which is gathering Transaction IDs from an ODM response; SET rEnvVar.TransList[] = Select qr.*:Transaction_Num …
JJG
  • 11
  • 1
1
vote
1 answer

Using ESQL-Sonar plugin in IIB V10

I am trying to use the Sonar-ESQL plugin in IIB V10 for ESQL code scanning. I downloaded the plugin jar file from the website http://www.sonarplugins.com/esql, then added the jar file in the plugin folder for Eclipse and restarted Eclipse. But I…
user3845894
  • 353
  • 1
  • 5
  • 17
1
vote
1 answer

Esql how to use select statement to retrieve value from input xml

I have an input xml that looks something like this 1 2 2 12345-67 What I do in esql…
bbedward
  • 6,368
  • 7
  • 36
  • 59
1 2
3
…
10 11