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
votes
2 answers

How to remove empty string fields in OutputRoot.JSON.Data esql

How do I iterate OutputRoot.JSON.Data and remove empty string fields Input { firstName : 'test, lastName : '' } Result { firstName : 'test' }
lars1595
  • 886
  • 3
  • 12
  • 27
-1
votes
1 answer

How to convert Particular timezone of date into GMT timezone using esql of MQ?

I have the date of particular timezone, and I want to convert it to the GMT timezone, and then it needs to be inserted into DB using esql of MQ. Please help to resolve this issue.
Sarath
  • 9
  • 4
-1
votes
1 answer

ESQL code for CSV to XML conversion in IIB v10

I want to convert input CSV file to XML file using ESQL in IIB v10. Can you please help me with the ESQL code to achieve the same. I've provided the Input CSV file sample and Output XML file sample as below: Input CSV file Output XML file
Debashis Mohanty
  • 11
  • 1
  • 1
-1
votes
1 answer

ESQL to read value from cache property file

AM new to esql, in my message flow have a lookup file which contains some values for forking messages. Now i have a new requirement to read a value from lookup cache file and search for string, so if contains particular string duplicate the messages…
user3171821
  • 69
  • 1
  • 12
-2
votes
1 answer

How can I create procedure in ESQL for select data from database

I want to be able to enter a BankID into XML file and if record is exist then have integer result,if doesn't should display another result My code is written in IBM web sphere message broker toolkit Please help me about this simple problem!!!!
Sina Zeinali
  • 15
  • 2
  • 11
-3
votes
1 answer

ESQL convert date format

Given this date format 2019-12-10 16:34:20 How to convert it into 2019-12-30T17:32:28Z. In ESQL.
aaaCobianu
  • 1
  • 1
  • 1
1 2 3
…
10
11