I am trying to insert incoming xml into sql server and its failing at the insert where xml has no value and attribute null="y",and field in sql is decimal so inserting '' empty string is not valid and throwing following error. Is there way to insert null instead of '' string. I tried _qual function.
Error: Error converting data: type varchar to numeric
tried: _qval(xpath(//row/total_amount),'single','null') still gets replaced with ''
Can someone help in how to insert into decimal field as default of null not ''?This message has been edited. Last edited by: Tamra,
Windows, All Outputs
There error msg is referring to trying to add an alpha " " to a numeric field.
What type of table are you updating? Can you add nulls to the column?
Here is a link to the documentation for
iWay Integration Suite
Thank your for participating in the Focal Point Forum,
Focal Point Moderator
WebFOCUS 8x - BI Portal, Developer Studio, App Studio, Excel, PDF, Active Formats and HTML5
|Powered by Social Strata|