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
2
votes
1 answer

IIB/Esql how to propagate XMLTYPE from oracle table to OutputRoot.XMLNSC

I have a message flow with a compute node and an MQOutput node that looks like this: MQInput->Compute->MQOutput In the compute node I retrieve an array of xml documents from an oracle database like this: declare xmlDoc row; set xmlDoc.rows[] =…
bbedward
  • 6,368
  • 7
  • 36
  • 59
2
votes
2 answers

IBM IIB 9 multiple data sources

I have message flow with compute node, which is calling some stored procedure from database. I set up data source field on this node for db1, same name exists in odbc.ini file. Now I want dynamically(without redeploying) change datasource to db2.…
2
votes
1 answer

Order By in esql

I have an xml message like this 2 6 1 and i want to select the element with the lowest number something like this SET data[] = SELECT…
Kingo Mostafa
  • 357
  • 5
  • 21
2
votes
2 answers

Custom plugin for checkmarx

We are writing a large application using IBM Integration Bus and using ESQL as major language for transformation. We are investigating CheckMarx for static code analysis and scanner. But CheckMarx does not support ESQL out of the box. Is it…
Aakash
  • 2,029
  • 14
  • 22
2
votes
1 answer

Exception in logging xml esql message broker IIB

My code is working fine for every other type of request. But for one type of request the logdebug function throws exception. The trace is: ExceptionList RecoverableException …
2
votes
2 answers

TimeStamp issue

I'm having trouble with this code snippet: DECLARE FormattedTimeStamp TIMESTAMP; DECLARE pattern CHARACTER 'yyyy-mm-ddTHH:mm:ss'; SET FormattedTimeStamp = CAST(EnvRef.ConsumerTrxnsInq.paymentList[i].TransactionDate as DATE FORMAT 'yyyy-MM-dd'); SET…
seeker
  • 79
  • 2
  • 16
2
votes
3 answers

Websphere Message Broker: Accessing XML elements in ESQL

Websphere Message Broker: File in File out example. I have an XML file with repeating element structure. How can I access and modify value of a particular element in ESQL. I worte following code.. CREATE PROCEDURE CopyEntireMessage() BEGIN …
Neha Raje
  • 151
  • 3
  • 7
  • 16
2
votes
2 answers

Is the character § supported by CCSID 1208

I need to know if the character § is supported by CCSID 1208. In general, How do we find the list of characters supported by a particular CCSID. Thanks
Lee
  • 101
  • 1
  • 2
  • 6
2
votes
2 answers

How to cast(convert) string to blob? in ESQL?

So i am reading an XML file from request note of flow. And need to convert XML data to blob.
Kenneth Lhv
  • 558
  • 2
  • 6
  • 16
1
vote
3 answers

'Unconvertable character' exception in HTTPRequest node when sending a HTTPRequestHeader containing a special character

I'm getting an 'Unconvertable character' exception when sending a HTTPRequestHeader to HTTPRequest Node containing a special character. Error in the ExceptionList when debugging: RecoverableException …
1
vote
2 answers

JSON Nested Array in ESQL IIB

I am new to IIB and I am struggling to create below JSON data from a nested array in Extended SQL. Kindly suggest me.Thanks a lot in advance. { "entities": [ { "entityId": "104477", "systemId": "CCCTP1", "segmentType":…
Loopinfility
  • 15
  • 1
  • 7
1
vote
2 answers

ESQL convert to ISO8601 yyyy-MM-dd

Given this date format: "15.03.2016" How to convert it into ISO8601 yyyy-MM-dd.
1
vote
1 answer

IBM App Connect Enterprise - Remove a default Header using ESQL

I have a simple REST API project built using IBM App Connect Enterprise version 11. What I observed is in the response headers, key value pair of Server and IBM App Connect Enterprise are added by default. I checked in the server.conf.yaml and…
Yasothar
  • 435
  • 1
  • 7
  • 24
1
vote
2 answers

IBM App Connect Enterprise - Form Data in Rest Request Node

According to this IIB v10 link application/x-www-form-urlencoded form data parameters are not supported for a Rest Request Node. https://www.ibm.com/support/knowledgecenter/SSMKHH_10.0.0/com.ibm.etools.mft.doc/bi12026_.htm Is this still the case for…
Yasothar
  • 435
  • 1
  • 7
  • 24
1
vote
1 answer

0 xsd:anyURI using esql.IBM Integration Bus

I'm working with IIB v10.0.0.7. I'd like to define one of the XML elements to be of type xsd:anyURI using esql. output should be like given above:
iibNewbie
  • 11
  • 1
1
2
3
10 11