tag:blogger.com,1999:blog-6718031572629168377.post8662830311238603968..comments2024-03-28T13:58:58.979+02:00Comments on noksTechnotes: ESQL Code SnippetsNokuthulaMhttp://www.blogger.com/profile/09993295848345605349noreply@blogger.comBlogger9125tag:blogger.com,1999:blog-6718031572629168377.post-50232814397842462492021-07-19T13:26:00.235+02:002021-07-19T13:26:00.235+02:00See point 9 in the blog post, 9 Pass Parameters to...See point 9 in the blog post, 9 Pass Parameters to an HTTP request Node.<br /><br />To pass the account number I would use the foolowing code.<br /><br />SET OutputLocalEnvironment.Destination.HTTP.QueryString.account = <br /> '0005678';NokuthulaMhttps://www.blogger.com/profile/09993295848345605349noreply@blogger.comtag:blogger.com,1999:blog-6718031572629168377.post-12250193032782321352021-07-16T20:19:10.588+02:002021-07-16T20:19:10.588+02:00any idea how to pass parameter to HTTP request? I ...any idea how to pass parameter to HTTP request? I tried outputroot not working {<br /> "account": "0005678",<br /> "OrderID": "12345",<br /> "OrdItms": [<br /> {<br /> "ItemNumber": "11111"<br /> },<br /> {<br /> "ItemNumber": "22222"<br /> }<br /> ]<br />}Anonymoushttps://www.blogger.com/profile/08454508501046225806noreply@blogger.comtag:blogger.com,1999:blog-6718031572629168377.post-91232347474517989442021-02-05T13:47:31.372+02:002021-02-05T13:47:31.372+02:00Are you getting an error? If yes, what is the erro...Are you getting an error? If yes, what is the error. Can you share your code.NokuthulaMhttps://www.blogger.com/profile/09993295848345605349noreply@blogger.comtag:blogger.com,1999:blog-6718031572629168377.post-78067618283530861602021-02-05T12:28:31.466+02:002021-02-05T12:28:31.466+02:00Hi im receiving blob (contains token) from the res...Hi im receiving blob (contains token) from the response of a http request node. Tried your method #2 and #10 but no luck. Also, changed the properties of httprequestnode response parsing from blob to json but no luck. What is the alternative? rpj123https://www.blogger.com/profile/12147670645921597557noreply@blogger.comtag:blogger.com,1999:blog-6718031572629168377.post-38156414579528127702020-04-28T16:53:33.913+02:002020-04-28T16:53:33.913+02:00I would use a reference variable instead of using ...I would use a reference variable instead of using the CARDINALITY function.<br /><br />See this code snippet taken from IBM Knowledge Center (https://www.ibm.com/support/knowledgecenter/SSMKHH_10.0.0/com.ibm.etools.mft.doc/bj28653_.html).<br /><br />See this post why its better to use reference variables instead.<br />https://nokstechnotes.blogspot.com/2019/03/good-iib-esql-coding-practice.htmlNokuthulaMhttps://www.blogger.com/profile/09993295848345605349noreply@blogger.comtag:blogger.com,1999:blog-6718031572629168377.post-87203882652011175062020-04-25T22:15:56.598+02:002020-04-25T22:15:56.598+02:00I want to iterate same XML messages using Cardinal...I want to iterate same XML messages using Cardinality function but I am able to fetch the last XML tag 3 times. pls helpAnonymoushttps://www.blogger.com/profile/18307230273140240198noreply@blogger.comtag:blogger.com,1999:blog-6718031572629168377.post-43033629245717066412019-11-07T14:13:13.127+02:002019-11-07T14:13:13.127+02:00awesome , hope you keep addingawesome , hope you keep addingGreenArrowhttps://www.blogger.com/profile/02737693039948717542noreply@blogger.comtag:blogger.com,1999:blog-6718031572629168377.post-62120425605028280382019-05-29T10:14:28.062+02:002019-05-29T10:14:28.062+02:00I would do the following:-
1. Convert JSON to BLO...I would do the following:-<br /><br />1. Convert JSON to BLOB<br />2. Convert BLOB to char<br /><br />SET myBlob = ASBITSTREAM(InputRoot.JSON CCSID InputRoot.Properties.CodedCharSetId ENCODING InputRoot.Properties.Encoding);<br />Set Value1 = CAST(myBlob as char CCSID InputRoot.Properties.CodedCharSetId ENCODING InputRoot.Properties.Encoding);NokuthulaMhttps://www.blogger.com/profile/09993295848345605349noreply@blogger.comtag:blogger.com,1999:blog-6718031572629168377.post-43315186401834888942019-05-29T09:42:37.193+02:002019-05-29T09:42:37.193+02:00Awesome notes thanks, How do i convert a JSON into...Awesome notes thanks, How do i convert a JSON into a string?Labeeq Jaffarhttps://www.blogger.com/profile/02974712428746188511noreply@blogger.com