09-05-2008 10:28 AM - edited 03-15-2019 01:04 PM
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.
09-11-2008 01:50 PM
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
09-11-2008 02:16 PM
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.
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide