Hi,

I have created SQL Data Source object with default configuration connecting to a DB. Its operational state is going down and up frequently. It will be down for around 5-10 sec when it goes down. During that interval, the requests will fail.

Hi,

sounds like you'll need to open a PMR to IBM Support.

--Hermanni

Hi Hermann,

To get rid of sql data source, am trying to use REST call to cloud db. and dbapi/v4/sql_jobs is the job to insert the data.

But in commands field, I need to give insert statement where one of the column value should be an xml payload..

since the namespaces (xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/") in xml has " , its failing but with \" its working.. I checked that by manually replacing " with \". Now trying to do the same in xslt. checked translate function, other solutions from forum using recursive calls. but none working..

Can you help here.

Hi Hermann,

To get rid of sql data source, am trying to use REST call to cloud db. and dbapi/v4/sql_jobs is the job to insert the data.

But in commands field, I need to give insert statement where one of the column value should be an xml payload..

since the namespaces (xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/") in xml has " , its failing but with \" its working.. I checked that by manually replacing " with \". Now trying to do the same in xslt. checked translate function, other solutions from forum using recursive calls. but none working..

Can you help here.

It would help if you'd post some code... With xslt you might want to try dp:serialize.

https://www.ibm.com/support/knowledgecenter/SS9H2Y_7.7.0/com.ibm.dp.doc/serialize_element.html

--Hermanni

ps. Hermann is the other, more skilled, guy :)

Serialization did helped. thq