executeSQLUpdate Errors

[myron.johnson]

All,

I hope someone can help me. I am trying to run a AXL/SOAP executeSQLUpdate to update the Display on Phones. I know that Informix doesn't support JOINS for Update statements, and I have tried several alternatives to get this working to no avail.

Here is the Update for my script:

<axlapi:executeSQLUpdate sequence="1" xmlns:axlapi="http://www.cisco.com/AXL/API/1.0" xmlns:axl="http://www.cisco.com/AXL/1.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.cisco.com/AXL/API/1.0 axlsoap.xsd">

<sql> Update DeviceNumPlanMap SET DeviceNumPlanMap.display = \'test\' FROM NumPlan, DeviceNumPlanMap WHERE NumPlan.DNOrPattern = \'3301\' AND DeviceNumPlanMap.fknumplan = NumPlan.pkid </sql> </axlapi:executeSQLUpdate>';

The \'test\' and \'3301\' will eventually be replaced by variables that I extract from a CSV file.

I get a syntax error when I run the command.

Any help will be greatly appreciated.

[#2]

executeSQLUpdate is provided in AXL API calls that are new in Release 5.0.

The following URL may help you:

http://www.cisco.com/en/US/docs/voice_ip_comm/cucm/devguide/5_0_4/ccmdvCh1.html

[myron.johnson]

Thanks for your help, but I was hoping to have someone who actually uses AXL/SOAP give me some insight, since I have already went over ever Cisco document I can find.