02-01-2022 06:14 AM
Dear members,
I'm trying the attached query against the UCCX Informix Database. It is giving "Syntax Error" without mentioning where the error is.
Anyone can advise where the issue could be?
Thanks in advance for any help.
02-02-2022 11:57 AM
There's a lot of SQL there.
Can you supply more info on what you're trying to do, and what else you've tried?
From your question it seems like you might have found this code somewhere and are trying to use it.
02-03-2022 12:01 AM
As per my experience, CUIC query syntax sometimes does not compile specific SQL function like at times i had problem with CAST function or RANK function, though the query execution was fine in IBM informix engines.
I solved it by making custom procedures and it ran perfectly well.
02-03-2022 12:31 AM
Hello,
Thank you for taking the time to respond.
I'm trying to create a custom report to have the below info in 1 report:
"AgentName-Extension-AgentLoginDetails-AgentLogoutDetails-TotalLoggedInTime-NotreadyTotalTime-ReadyTime-Calls Handled-Calls Presented-AvgTalkTime-AvgHoldTime"
I tried to use a procedure but couldnt find how it can return a list that's why I'm using a function now.
Could you please advise if a procedure can return a list in Informix.
Thank you so much.
02-03-2022 12:39 AM
yes it does, iterateable objects can be returned. for that you will need to work on SP output parameter.
This is more related to SQL grip on IBM architecture than CUIC related.
best of luck
02-03-2022 06:15 AM
Is it possible that you share an example of a stored procedure returning a list? or a link that migh help.
Thank you for your help.
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