06-13-2016 11:42 AM - edited 03-19-2019 11:14 AM
The concat function doesn't seem to work on UCM 9.1, anybody know a way to utilize the Informix concat function in a select on UCM?
AO
06-13-2016 11:48 AM
Hi,
Can you elaborate you query.
JB
06-13-2016 11:50 AM
Hello,
My query is below, as you can see I am trying to concatenate some substrings and unfortunately experiencing an error, I've tried concat and concatenate:
Routine (concat) can not be resolved.
Routine (concatenate) can not be resolved.
run sql select n.dnorpattern, h.maxcallersinqueue, h.maxwaittimedestination, h.noagentdestination, h.queuefulldestination, h.maxwaittimeinqueue from numplan as n inner join huntpilotqueue as h on h.fknumplan_pilot=n.pkid where 1=1 and tkpatternusage = '7' and ((dnorpattern like '%110' and h.maxwaittimedestination<> concatenate('0000' , substr(dnorpattern,1,1) , '0' , substr(dnorpattern,2,3) , '0')) or (dnorpattern like '%120' and h.maxwaittimedestination<> concatenate('0000' , substr(dnorpattern,1,1) , '0' , substr(dnorpattern,2,3) , '1')) or (dnorpattern like '%130' and h.maxwaittimedestination<> concatenate('0000' , substr(dnorpattern,1,1) , '0' , substr(dnorpattern,2,3) , '2')) or (dnorpattern like '%170' and h.maxwaittimedestination<> concatenate('0000' , substr(dnorpattern,1,1) , '0' , substr(dnorpattern,2,3) , '3')) or (dnorpattern like '%171' and h.maxwaittimedestination<> concatenate('0000' , substr(dnorpattern,1,1) , '0' , substr(dnorpattern,2,3) , '4')) or (dnorpattern like '%180' and h.maxwaittimedestination<> concatenate('0000' , substr(dnorpattern,1,1) , '0' , substr(dnorpattern,2,3) , '5')) or (h.maxwaittimedestination <> h.noagentdestination ) or (h.maxwaittimedestination <> h.queuefulldestination))
06-13-2016 01:04 PM
Hi,
i tried it with root account also thinking it could be an issue with shell but it told me the same.
SQL: New Run Modify Use-editor Output Choose Save Info Drop Exit
Modify the current SQL statements using the SQL editor.
-------- ccm10_5_2_10000_2@cucm_10_5_ccm10_5+ ----- Press CTRL-W for Help -----
select concatenation(firstname, lastname, userid) from enduser
674: Routine (concatenation) can not be resolved.
JB
06-13-2016 01:48 PM
I did find this link which talks about CONCAT function, though it might help.
http://www.ucguerrilla.com/2014/06/using-sql-to-reconfigure-dial-plan.html
HTH
JB
06-13-2016 02:21 PM
Concat produced the same error
Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: