Heads Up :
The post you are writing will appear in a public forum. Please ensure all content is appropriate for public consumption. Review the employee guidelines for the community here.
We are seeing some failed PSTN calls coming in via a CUBE SIP trunk failing to go through, with the CDR displaying origCause_value=570425365 - on closer inspection it seems to be rejected based on 'rejectAnonymousCall=t' if the caller ID is not bei...
When trying to run executeSQLQuery such as this: select numplan.pkid from numplan where dnorpattern like '\\+1123456';this returns a valuebut if I wish to use a wildcard: select numplan.pkid from numplan where dnorpattern like '\\+112345%';it...
Thanks dstaudt for pointing me off to find the comprehensive manual "IBM Informix Guide to SQL: Syntax" - its a ripper.the chapter titled - LIKE and MATCHES Condition gives a few solutions..dnorpattern matches '[\]+618644431*'-or-dnorpattern like 'z\...
Thanks for the reply, I also read this - "You can also use an escape character to escape itself"in the database +E164 numbers are stored in the 'numplan' table with the escape character '\' preceding the '+' - so the escape character is stored in the...
