SELECT * FROM _SMY_QUEUE WHERE QUEUE_NAME MATCHES "E.*"Įrror: An expression of non-boolean type specified in a context where a condition is expected, near 'MATCHES'.Įrror: The executeQuery method must return a result set. It just gives me any QUEUE_NAME that has an "E" followed by 0 or more characters. *Here is the simpliest test I could think of with the MATCHES operator so I could rule out other syntax issues. Except for the MATCHES operator gives me the error below : I'm also using the SQuirreL SQL App to access/browse and query the database, which all seem to be working just fine. So I was assuming that EIM's Database was probably pretty close, if not the same version.Īnd I found on IBM's site for Informix Version 11.5 that the MATCHES operator is available for this version. IBM Informix Dynamic Server Version 11.50.UC5XA I couldn't find the version of the Informix Database being used for EIM but I was able to find a command to run if I SSH'ed to UCCX for example, which would get me the Informix version info for our other CallCenter servers like UCCX, CUCM, Unity, etc.Īdmin: run sql select unique dbinfo('version', 'full') from systables This question is for Cisco EIM's Informix Database.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |