<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.6000.16890" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=234333120-12082009><FONT face=Arial size=2>Hi folks
--</FONT></SPAN></DIV>
<DIV><SPAN class=234333120-12082009><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=234333120-12082009><FONT face=Arial size=2>I'm trying to work
out how to pull some data out of our CM.</FONT></SPAN></DIV>
<DIV><SPAN class=234333120-12082009><FONT face=Arial size=2>Running
6.01sr13</FONT></SPAN></DIV>
<DIV><SPAN class=234333120-12082009><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=234333120-12082009><FONT face=Arial size=2>If you've used the
AXL SQL toolkit that comes with UCM 6.01, you've probably seen this line in
'sample.xml'</FONT></SPAN></DIV>
<DIV><SPAN class=234333120-12082009><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=234333120-12082009><FONT face=Arial size=2>"<sql
query="select * from device where name like 'SEP001BD43291E9'
"/>"</FONT></SPAN></DIV>
<DIV><SPAN class=234333120-12082009><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=234333120-12082009><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=234333120-12082009><FONT face=Arial size=2>You also probably
know that this line</FONT></SPAN></DIV>
<DIV><SPAN class=234333120-12082009><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=234333120-12082009><FONT face=Arial size=2>"java -cp
.\classes;.\lib\saaj-api.jar;.\lib\saaj-impl.jar;.\lib\mail.jar;.\lib\activation.jar;.\lib\jaxm-api.jar;.\lib\jaxm-runtime.jar;.\lib\xercesImpl.jar;.\lib\xml-apis.jar
AxlSqlToolkit -username=******* -password=******* -host=<ip-of-publisher>
-input=sample.xml -output=sample-response.xml"<BR></FONT></SPAN></DIV>
<DIV><SPAN class=234333120-12082009><FONT face=Arial size=2>would pull out the
data for phone SEP001BD43291E9</FONT></SPAN></DIV>
<DIV><SPAN class=234333120-12082009><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=234333120-12082009><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=234333120-12082009><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=234333120-12082009><FONT face=Arial size=2>What I'm trying to
figure out without much success is how to query for a list of
phones.</FONT></SPAN></DIV>
<DIV><SPAN class=234333120-12082009><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=234333120-12082009><FONT face=Arial size=2>This is the full
'sample.xml' file:</FONT></SPAN></DIV>
<DIV><SPAN class=234333120-12082009><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=234333120-12082009><FONT face=Arial size=2>"<?xml
version="1.0" encoding="UTF-8"?><BR><!--DTD generated by XMLSPY v5 rel. 4
U (<A
href="http://www.xmlspy.com">http://www.xmlspy.com</A>)--><BR><!DOCTYPE
data [<BR> <!ELEMENT data (sql+)><BR> <!ELEMENT sql
EMPTY><BR> <!ATTLIST sql<BR> query CDATA
#IMPLIED<BR> update CDATA
#IMPLIED<BR>><BR>]><BR><data><BR><sql query="select * from device
where name like 'SEP001BD43291E9' "/></FONT></SPAN></DIV>
<DIV><SPAN class=234333120-12082009><FONT face=Arial
size=2></data>"</FONT></SPAN></DIV>
<DIV><SPAN class=234333120-12082009><FONT face=Arial
size=2> </DIV></FONT></SPAN>
<DIV><SPAN class=234333120-12082009><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=234333120-12082009><FONT face=Arial size=2>Simply doing more
lines like:</FONT></SPAN></DIV>
<DIV><SPAN class=234333120-12082009><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=234333120-12082009><FONT face=Arial size=2><sql
query="select * from device where name like 'SEP001BD43291E9'
"/></FONT></SPAN></DIV>
<DIV><SPAN class=234333120-12082009><FONT face=Arial size=2><sql
query="select * from device where name like 'SEP001BD445d64
"/></FONT></SPAN></DIV>
<DIV><SPAN class=234333120-12082009><FONT face=Arial size=2><sql
query="select * from device where name like 'SEP001BD46F3C4'
"/></FONT></SPAN></DIV>
<DIV><SPAN class=234333120-12082009><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=234333120-12082009><FONT face=Arial size=2>works -- but there's
excess garbage in the resulting XML file.</FONT></SPAN></DIV>
<DIV><SPAN class=234333120-12082009><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=234333120-12082009><FONT face=Arial size=2>What I want to do is
something like this:</FONT></SPAN></DIV>
<DIV><SPAN class=234333120-12082009><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=234333120-12082009><FONT face=Arial size=2><sql
query="select * from device where name like 'SEP001BD43291E9' or like
'SEP001BD445d64' or like 'SEP001BD4A3C4B7' "/></FONT></SPAN></DIV>
<DIV><SPAN class=234333120-12082009><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=234333120-12082009><FONT face=Arial size=2>But using "or like"
doesn't work.</FONT></SPAN></DIV>
<DIV><SPAN class=234333120-12082009><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=234333120-12082009><FONT face=Arial size=2>Nor does "like" or
"," or anything else that I can think of.</FONT></SPAN></DIV>
<DIV><SPAN class=234333120-12082009><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=234333120-12082009><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=234333120-12082009><FONT face=Arial size=2>I can't find a
reference on Cisco's site for the SQL syntax of the Informix (?) engine being
used.</FONT></SPAN></DIV>
<DIV><SPAN class=234333120-12082009><FONT face=Arial size=2>Other documents
exist, like a data dictionary (handy) --</FONT></SPAN></DIV>
<DIV><SPAN class=234333120-12082009><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=234333120-12082009><FONT face=Arial size=2>but I've not been
able to find how to write a simple select query with multiple
matches</FONT></SPAN></DIV>
<DIV><SPAN class=234333120-12082009><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=234333120-12082009><FONT face=Arial size=2>I can do this all
day long in MySQL or MSSQL --- but Informix must be different yet from either of
those</FONT></SPAN></DIV>
<DIV><SPAN class=234333120-12082009><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=234333120-12082009><FONT face=Arial size=2>Anyone got any
ideas?</FONT></SPAN></DIV>
<DIV><SPAN class=234333120-12082009><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=234333120-12082009><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=234333120-12082009><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=234333120-12082009><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=234333120-12082009><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV align=left><FONT face=Arial size=2>Tim Reimers</FONT></DIV>
<DIV align=left><FONT face=Arial size=2>Systems Analyst II</FONT></DIV>
<DIV align=left><FONT face=Arial size=2>Information Technology
Services</FONT></DIV>
<DIV align=left><FONT face=Arial size=2>City of Asheville</FONT></DIV>
<DIV align=left><FONT face=Arial size=2>70 Court Plaza</FONT></DIV>
<DIV align=left><FONT face=Arial size=2>Asheville, NC 28801</FONT></DIV>
<DIV align=left><FONT face=Arial size=2>phone - 828-259-5512</FONT></DIV>
<DIV align=left><FONT face=Arial size=2><A
href="mailto:timreimers@ashevillenc.gov">treimers@ashevillenc.gov</A></FONT></DIV>
<DIV> </DIV></BODY></HTML>