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

Getting Current hour in local time zone ESQL Message broker

I am trying to get the current Hour in local timezone in esql for a requirement by the command: set throttle_time = EXTRACT(HOUR FROM LOCAL_TIMEZONE); But it gives me an exception which is given as below: ExceptionList RecoverableException …
jonathan white
  • 33
  • 4
  • 15
0
votes
1 answer

How to reach a value in LocalEnvironment Tree in ESQL :: IBM Message Broker

I'm trying to set WrittenDestination.Name to OutputLocalEnvironment.Variables.zipFileName . But when I try to run and track the message, value of zipFileName is null. Here is my ESQL code. CREATE COMPUTE MODULE TFM_ERecruit_compare CREATE…
NotA
  • 1
  • 1
  • 3
0
votes
1 answer

XMLNSC attributes

I am getting the below message from an application field:CHARACTER:abcd mv:CHARACTER:1 name:CHARACTER:NAME sv:CHARACTER:1 field:CHARACTER:aaaaa mv:CHARACTER:1 …
Nuthan
  • 1
  • 2
0
votes
0 answers

String is pruned automatically while getting data from Oracle using ESQL , but works fine with DB2

I am using ESQL to fetch data from Oracle and create a XML message. Everything works fine except that a column name FILENAME is pruned automatically to 20 character.Part of the ESQL creating the XML message: CREATE COMPUTE MODULE FileExpectedEvent …
Atul Rai
  • 9
  • 4
0
votes
1 answer

ESQL convert to binary

just wondering how to convert integers from XML to Binary PIC 9(4) BINARY Currently I have SET OutputRoot.DFDL.ORDERS.NUMBER_OF_ITEMS = CARDINALITY(InputRoot.XMLNSC.p:Order.p:Order_Items.p:Item[]); Cobol CopyBook NUMBER-OF-ITEMS PIC 9(4)…
user2381130
  • 193
  • 2
  • 12
0
votes
1 answer

ESQL transform from XML to COBOL and extarct date from string

I am ESQL newbie and transforming XML to Cobol copybook, one of the XML element is date but in string with a format yyyymmdd for example 20140908 I need to extract the year, month and day out of the string also in numeric 05 orderdate 10…
user2381130
  • 193
  • 2
  • 12
0
votes
2 answers

Getting a node in XML using fieldname in ESQL

How to get the elements of an XML if we know the nodename.I have a sample XML like below. Computer…</div> <div class="grid ai-start jc-space-between fw-wrap"> <div class="grid gs4 fw-wrap tags "> <a href="../../questions/tagged/xml" class="post-tag grid--cell" title="show questions tagged 'xml'" rel="tag">xml</a> <a href="../../questions/tagged/extended-sql" class="post-tag grid--cell" title="show questions tagged 'extended-sql'" rel="tag">extended-sql</a> </div> <div class="started mt0"> <div class="s-user-card s-user-card"> <time class="s-user-card--time" datetime="asked Aug 13 '14 at 05:15">asked Aug 13 '14 at 05:15</time> <a href="../../users/3932408/user3932408" class="s-avatar s-avatar__32 s-user-card--avatar"> <img class="s-avatar--image" src="../../users/profiles/3932408.webp" data-jdenticon-width="32" data-jdenticon-height="32" data-jdenticon-value="user3932408" /> </a> <div class="s-user-card--info"> <a href="../../users/3932408/user3932408" class="s-user-card--link">user3932408</a> <ul class="s-user-card--awards"> <li class="s-user-card--rep" title="reputation score">1</li> <li class="s-award-bling s-award-bling__bronze" title="3 bronze badges">3</li> </ul> </div> </div> </div> </div> </div> </div> </div> <div class="mln24"> <div class="question-summary" id="question-summary-25260070"> <div class="statscontainer"> <div class="stats"> <div class="vote"> <div class="votes"> <span class="vote-count-post"><strong>0</strong></span> <div class="viewcount">votes</div> </div> </div> <div class="status "> <strong>1</strong> answer </div> </div> </div> <div class="summary"> <h3><a href="../../questions/25260070/accessing-the-xml-using-xpath" class="question-hyperlink">Accessing the xml using xpath</a></h3> <div class="excerpt">I am getting xpath from database as character. I want to retrieve that element from XML using esql. Since the xpath is character , I am not able to retrieve the element from XML. Is any way to convert the character to refer the XML? For example, my…</div> <div class="grid ai-start jc-space-between fw-wrap"> <div class="grid gs4 fw-wrap tags "> <a href="../../questions/tagged/ibm-integration-bus" class="post-tag grid--cell" title="show questions tagged 'ibm-integration-bus'" rel="tag">ibm-integration-bus</a> <a href="../../questions/tagged/extended-sql" class="post-tag grid--cell" title="show questions tagged 'extended-sql'" rel="tag">extended-sql</a> </div> <div class="started mt0"> <div class="s-user-card s-user-card"> <time class="s-user-card--time" datetime="asked Aug 12 '14 at 08:55">asked Aug 12 '14 at 08:55</time> <a href="../../users/3932408/user3932408" class="s-avatar s-avatar__32 s-user-card--avatar"> <img class="s-avatar--image" src="../../users/profiles/3932408.webp" data-jdenticon-width="32" data-jdenticon-height="32" data-jdenticon-value="user3932408" /> </a> <div class="s-user-card--info"> <a href="../../users/3932408/user3932408" class="s-user-card--link">user3932408</a> <ul class="s-user-card--awards"> <li class="s-user-card--rep" title="reputation score">1</li> <li class="s-award-bling s-award-bling__bronze" title="3 bronze badges">3</li> </ul> </div> </div> </div> </div> </div> </div> </div> <div class="mln24"> <div class="question-summary" id="question-summary-25198328"> <div class="statscontainer"> <div class="stats"> <div class="vote"> <div class="votes"> <span class="vote-count-post"><strong>0</strong></span> <div class="viewcount">votes</div> </div> </div> <div class="status "> <strong>1</strong> answer </div> </div> </div> <div class="summary"> <h3><a href="../../questions/25198328/how-to-separate-xml-based-on-xpath-in-esql" class="question-hyperlink">how to separate xml based on xpath in esql</a></h3> <div class="excerpt">I am new to esql. I have an XML similar to the one given below <vehicles> <car make="Ford"> <model>Mustang</model> <year>1965</year> </car> <car make="Chevrolet"> <model>Nova</model> <year>1967</year> </car> </vehicles> When i…</div> <div class="grid ai-start jc-space-between fw-wrap"> <div class="grid gs4 fw-wrap tags "> <a href="../../questions/tagged/xml" class="post-tag grid--cell" title="show questions tagged 'xml'" rel="tag">xml</a> <a href="../../questions/tagged/ibm-mq" class="post-tag grid--cell" title="show questions tagged 'ibm-mq'" rel="tag">ibm-mq</a> <a href="../../questions/tagged/ibm-integration-bus" class="post-tag grid--cell" title="show questions tagged 'ibm-integration-bus'" rel="tag">ibm-integration-bus</a> <a href="../../questions/tagged/extended-sql" class="post-tag grid--cell" title="show questions tagged 'extended-sql'" rel="tag">extended-sql</a> </div> <div class="started mt0"> <div class="s-user-card s-user-card"> <time class="s-user-card--time" datetime="asked Aug 08 '14 at 07:40">asked Aug 08 '14 at 07:40</time> <a href="../../users/1001006/biju" class="s-avatar s-avatar__32 s-user-card--avatar"> <img class="s-avatar--image" src="../../users/profiles/1001006.webp" data-jdenticon-width="32" data-jdenticon-height="32" data-jdenticon-value="Biju" /> </a> <div class="s-user-card--info"> <a href="../../users/1001006/biju" class="s-user-card--link">Biju</a> <ul class="s-user-card--awards"> <li class="s-user-card--rep" title="reputation score">17</li> <li class="s-award-bling s-award-bling__bronze" title="8 bronze badges">8</li> </ul> </div> </div> </div> </div> </div> </div> </div> <div class="mln24"> <div class="question-summary" id="question-summary-24780454"> <div class="statscontainer"> <div class="stats"> <div class="vote"> <div class="votes"> <span class="vote-count-post"><strong>0</strong></span> <div class="viewcount">votes</div> </div> </div> <div class="status "> <strong>2</strong> answers </div> </div> </div> <div class="summary"> <h3><a href="../../questions/24780454/issue-in-wmb-message-broker-insert-to-a-sybase-database-table" class="question-hyperlink">Issue in WMB message broker insert to a Sybase Database Table</a></h3> <div class="excerpt">Currently am facing an issue while inserting data in to Sybase database 15.7 with WMB code flow. Am currently using WMB7 Broker and I have written code in our message flow which is trying to insert the data in the table directly rather than using …</div> <div class="grid ai-start jc-space-between fw-wrap"> <div class="grid gs4 fw-wrap tags "> <a href="../../questions/tagged/insert" class="post-tag grid--cell" title="show questions tagged 'insert'" rel="tag">insert</a> <a href="../../questions/tagged/sybase" class="post-tag grid--cell" title="show questions tagged 'sybase'" rel="tag">sybase</a> <a href="../../questions/tagged/messagebroker" class="post-tag grid--cell" title="show questions tagged 'messagebroker'" rel="tag">messagebroker</a> <a href="../../questions/tagged/ibm-integration-bus" class="post-tag grid--cell" title="show questions tagged 'ibm-integration-bus'" rel="tag">ibm-integration-bus</a> <a href="../../questions/tagged/extended-sql" class="post-tag grid--cell" title="show questions tagged 'extended-sql'" rel="tag">extended-sql</a> </div> <div class="started mt0"> <div class="s-user-card s-user-card"> <time class="s-user-card--time" datetime="asked Jul 16 '14 at 12:09">asked Jul 16 '14 at 12:09</time> <a href="../../users/290364/wenzer" class="s-avatar s-avatar__32 s-user-card--avatar"> <img class="s-avatar--image" src="../../users/profiles/290364.webp" data-jdenticon-width="32" data-jdenticon-height="32" data-jdenticon-value="WENzER" /> </a> <div class="s-user-card--info"> <a href="../../users/290364/wenzer" class="s-user-card--link">WENzER</a> <ul class="s-user-card--awards"> <li class="s-user-card--rep" title="reputation score">205</li> <li class="s-award-bling s-award-bling__gold" title="1 gold badge">1</li> <li class="s-award-bling s-award-bling__silver" title="5 silver badge">5</li> <li class="s-award-bling s-award-bling__bronze" title="15 bronze badge">15</li> </ul> </div> </div> </div> </div> </div> </div> </div> <div class="mln24"> <div class="question-summary" id="question-summary-21125453"> <div class="statscontainer"> <div class="stats"> <div class="vote"> <div class="votes"> <span class="vote-count-post"><strong>0</strong></span> <div class="viewcount">votes</div> </div> </div> <div class="status "> <strong>1</strong> answer </div> </div> </div> <div class="summary"> <h3><a href="../../questions/21125453/websphere-message-broker-soap-request-node-calling-net-web-service-in-gateway-" class="question-hyperlink">Websphere Message Broker SOAP Request Node calling .NET web service in gateway mode (no WSDL)</a></h3> <div class="excerpt">I have been struggling with this issue for a while now and all of the search results (and there are many that I have read) do not seem to apply to my situation. I have a Websphere Message Broker message flow with a subflow that is calling a web…</div> <div class="grid ai-start jc-space-between fw-wrap"> <div class="grid gs4 fw-wrap tags "> <a href="../../questions/tagged/soap" class="post-tag grid--cell" title="show questions tagged 'soap'" rel="tag">soap</a> <a href="../../questions/tagged/ibm-mq" class="post-tag grid--cell" title="show questions tagged 'ibm-mq'" rel="tag">ibm-mq</a> <a href="../../questions/tagged/webservice-client" class="post-tag grid--cell" title="show questions tagged 'webservice-client'" rel="tag">webservice-client</a> <a href="../../questions/tagged/ibm-integration-bus" class="post-tag grid--cell" title="show questions tagged 'ibm-integration-bus'" rel="tag">ibm-integration-bus</a> <a href="../../questions/tagged/extended-sql" class="post-tag grid--cell" title="show questions tagged 'extended-sql'" rel="tag">extended-sql</a> </div> <div class="started mt0"> <div class="s-user-card s-user-card"> <time class="s-user-card--time" datetime="asked Jan 14 '14 at 22:34">asked Jan 14 '14 at 22:34</time> <a href="../../users/3195931/user3195931" class="s-avatar s-avatar__32 s-user-card--avatar"> <img class="s-avatar--image" src="../../users/profiles/3195931.webp" data-jdenticon-width="32" data-jdenticon-height="32" data-jdenticon-value="user3195931" /> </a> <div class="s-user-card--info"> <a href="../../users/3195931/user3195931" class="s-user-card--link">user3195931</a> <ul class="s-user-card--awards"> <li class="s-user-card--rep" title="reputation score">1</li> <li class="s-award-bling s-award-bling__silver" title="1 silver badges">1</li> <li class="s-award-bling s-award-bling__bronze" title="3 bronze badges">3</li> </ul> </div> </div> </div> </div> </div> </div> </div> <div class="mln24"> <div class="question-summary" id="question-summary-20997108"> <div class="statscontainer"> <div class="stats"> <div class="vote"> <div class="votes"> <span class="vote-count-post"><strong>0</strong></span> <div class="viewcount">votes</div> </div> </div> <div class="status "> <strong>2</strong> answers </div> </div> </div> <div class="summary"> <h3><a href="../../questions/20997108/how-to-send-an-email-with-ibm-message-broker" class="question-hyperlink">How to send an email with IBM Message Broker?</a></h3> <div class="excerpt">As a part of overall project, I need to create one Message-Broker application which accepts data in XML format and produce email. I created one message flow like below "MQ Input - Compute - emailoutput" Please help me what should I write in xml file…</div> <div class="grid ai-start jc-space-between fw-wrap"> <div class="grid gs4 fw-wrap tags "> <a href="../../questions/tagged/email" class="post-tag grid--cell" title="show questions tagged 'email'" rel="tag">email</a> <a href="../../questions/tagged/ibm-mq" class="post-tag grid--cell" title="show questions tagged 'ibm-mq'" rel="tag">ibm-mq</a> <a href="../../questions/tagged/ibm-integration-bus" class="post-tag grid--cell" title="show questions tagged 'ibm-integration-bus'" rel="tag">ibm-integration-bus</a> <a href="../../questions/tagged/extended-sql" class="post-tag grid--cell" title="show questions tagged 'extended-sql'" rel="tag">extended-sql</a> </div> <div class="started mt0"> <div class="s-user-card s-user-card"> <time class="s-user-card--time" datetime="asked Jan 08 '14 at 13:30">asked Jan 08 '14 at 13:30</time> <a href="../../users/3173432/user3173432" class="s-avatar s-avatar__32 s-user-card--avatar"> <img class="s-avatar--image" src="../../users/profiles/3173432.webp" data-jdenticon-width="32" data-jdenticon-height="32" data-jdenticon-value="user3173432" /> </a> <div class="s-user-card--info"> <a href="../../users/3173432/user3173432" class="s-user-card--link">user3173432</a> <ul class="s-user-card--awards"> <li class="s-user-card--rep" title="reputation score">11</li> <li class="s-award-bling s-award-bling__silver" title="1 silver badges">1</li> <li class="s-award-bling s-award-bling__bronze" title="3 bronze badges">3</li> </ul> </div> </div> </div> </div> </div> </div> </div> <div class="mln24"> <div class="question-summary" id="question-summary-19997176"> <div class="statscontainer"> <div class="stats"> <div class="vote"> <div class="votes"> <span class="vote-count-post"><strong>0</strong></span> <div class="viewcount">votes</div> </div> </div> <div class="status "> <strong>2</strong> answers </div> </div> </div> <div class="summary"> <h3><a href="../../questions/19997176/esql-check-one-of-the-incoming-xml-tag-contains-serialzed-data" class="question-hyperlink">ESQL : Check One of the incoming xml tag contains serialzed data</a></h3> <div class="excerpt">Need help to validate if one of the incoming XML tag contains serialized data or not. If ir doesn't contain then have to thow an user defined exception. This has to be achieved using ESQL. example…</div> <div class="grid ai-start jc-space-between fw-wrap"> <div class="grid gs4 fw-wrap tags "> <a href="../../questions/tagged/messagebroker" class="post-tag grid--cell" title="show questions tagged 'messagebroker'" rel="tag">messagebroker</a> <a href="../../questions/tagged/ibm-integration-bus" class="post-tag grid--cell" title="show questions tagged 'ibm-integration-bus'" rel="tag">ibm-integration-bus</a> <a href="../../questions/tagged/extended-sql" class="post-tag grid--cell" title="show questions tagged 'extended-sql'" rel="tag">extended-sql</a> </div> <div class="started mt0"> <div class="s-user-card s-user-card"> <time class="s-user-card--time" datetime="asked Nov 15 '13 at 09:03">asked Nov 15 '13 at 09:03</time> <a href="../../users/2995546/user2995546" class="s-avatar s-avatar__32 s-user-card--avatar"> <img class="s-avatar--image" src="../../users/profiles/2995546.webp" data-jdenticon-width="32" data-jdenticon-height="32" data-jdenticon-value="user2995546" /> </a> <div class="s-user-card--info"> <a href="../../users/2995546/user2995546" class="s-user-card--link">user2995546</a> <ul class="s-user-card--awards"> <li class="s-user-card--rep" title="reputation score">1</li> <li class="s-award-bling s-award-bling__gold" title="1 gold badge">1</li> <li class="s-award-bling s-award-bling__silver" title="1 silver badge">1</li> <li class="s-award-bling s-award-bling__bronze" title="1 bronze badge">1</li> </ul> </div> </div> </div> </div> </div> </div> </div> <div class="mln24"> <div class="question-summary" id="question-summary-10548481"> <div class="statscontainer"> <div class="stats"> <div class="vote"> <div class="votes"> <span class="vote-count-post"><strong>0</strong></span> <div class="viewcount">votes</div> </div> </div> <div class="status answered-accepted"> <strong>1</strong> answer </div> </div> </div> <div class="summary"> <h3><a href="../../questions/10548481/message-broker-6-1-sleep-exception" class="question-hyperlink">Message Broker 6.1 sleep exception</a></h3> <div class="excerpt">I'm trying to add a simple sleep function to extend the base ESQL API. Java implementation: public static void sleep(long millis) { try { Thread.sleep(millis); } catch (InterruptedException e) { e.printStackTrace(); …</div> <div class="grid ai-start jc-space-between fw-wrap"> <div class="grid gs4 fw-wrap tags "> <a href="../../questions/tagged/sleep" class="post-tag grid--cell" title="show questions tagged 'sleep'" rel="tag">sleep</a> <a href="../../questions/tagged/messagebroker" class="post-tag grid--cell" title="show questions tagged 'messagebroker'" rel="tag">messagebroker</a> <a href="../../questions/tagged/ibm-integration-bus" class="post-tag grid--cell" title="show questions tagged 'ibm-integration-bus'" rel="tag">ibm-integration-bus</a> <a href="../../questions/tagged/extended-sql" class="post-tag grid--cell" title="show questions tagged 'extended-sql'" rel="tag">extended-sql</a> </div> <div class="started mt0"> <div class="s-user-card s-user-card__deleted"> <time class="s-user-card--time" datetime="asked May 11 '12 at 09:04">asked May 11 '12 at 09:04</time> <div class="s-avatar s-avatar__32 s-user-card--avatar"> </div> <div class="s-user-card--info">user821445</div> </div> </div> </div> </div> </div> </div> <div class="mln24"> <div class="question-summary" id="question-summary-10000547"> <div class="statscontainer"> <div class="stats"> <div class="vote"> <div class="votes"> <span class="vote-count-post"><strong>0</strong></span> <div class="viewcount">votes</div> </div> </div> <div class="status answered-accepted"> <strong>4</strong> answers </div> </div> </div> <div class="summary"> <h3><a href="../../questions/10000547/wmb-esql-passing-constants-to-passthru" class="question-hyperlink">WMB ESQL passing constants to passthru</a></h3> <div class="excerpt">I am working on IBM Websphere Message Broker v6.0 and writing a message flow in ESQL. I am using passthru to fire a select query on database. Now the problem is passthru uses ' to start and end its parameter string. And we use ' in SQL to denote…</div> <div class="grid ai-start jc-space-between fw-wrap"> <div class="grid gs4 fw-wrap tags "> <a href="../../questions/tagged/ibm-integration-bus" class="post-tag grid--cell" title="show questions tagged 'ibm-integration-bus'" rel="tag">ibm-integration-bus</a> <a href="../../questions/tagged/extended-sql" class="post-tag grid--cell" title="show questions tagged 'extended-sql'" rel="tag">extended-sql</a> </div> <div class="started mt0"> <div class="s-user-card s-user-card"> <time class="s-user-card--time" datetime="asked Apr 03 '12 at 20:05">asked Apr 03 '12 at 20:05</time> <a href="../../users/578046/saurabh-patil" class="s-avatar s-avatar__32 s-user-card--avatar"> <img class="s-avatar--image" src="../../users/profiles/578046.webp" data-jdenticon-width="32" data-jdenticon-height="32" data-jdenticon-value="Saurabh Patil" /> </a> <div class="s-user-card--info"> <a href="../../users/578046/saurabh-patil" class="s-user-card--link">Saurabh Patil</a> <ul class="s-user-card--awards"> <li class="s-user-card--rep" title="reputation score">4,170</li> <li class="s-award-bling s-award-bling__gold" title="4 gold badges">4</li> <li class="s-award-bling s-award-bling__silver" title="32 silver badges">32</li> <li class="s-award-bling s-award-bling__bronze" title="33 bronze badges">33</li> </ul> </div> </div> </div> </div> </div> </div> </div> <div class="s-pagination pager fr"> <a class="s-pagination--item" href="../../questions/tagged/extended-sql_page=9" rel="prev" title="Go to page 9">Prev </a> <a class="s-pagination--item" href="../../questions/tagged/extended-sql_page=1" rel="" title="Go to page 1">1</a> <a class="s-pagination--item" href="../../questions/tagged/extended-sql_page=2" rel="" title="Go to page 2">2</a> <a class="s-pagination--item" href="../../questions/tagged/extended-sql_page=3" rel="" title="Go to page 3">3</a> <div class="s-pagination--item s-pagination--item__clear">…</div> <div class="s-pagination--item is-selected">10</div> <a class="s-pagination--item" href="../../questions/tagged/extended-sql_page=11" rel="" title="Go to page 11">11</a> <a class="s-pagination--item" href="../../questions/tagged/extended-sql_page=11" rel="next" title="Go to page 11"> Next</a> </div> </div> </div> </div> </div> <script src="../../static/js/stack-icons.js"></script> <script src="../../static/js/fromnow.js"></script> </body> </html>