Contact Center Reporting

« Back to Contact Center Reporting

CUIS and CVP Informix Database Input Parameter Format

Combination View Flat View Tree View
Threads [ Previous | Next ]
CUIS and CVP Informix Database Input Parameter Format
Answer
8/10/10 10:16 PM
I'm trying to write a custom CUIS report but cannot figure out how to get input parameters into the script.  The DECLARE @var does not work (it seems) with Informix, the DECLARE statement in Informix seems to be for cursor usage, generates a validation error which is very generic. 
 
Does anyone have experience writing Informix queuries against the CVP database and specifiying input parameters like date, element name, etc.?  I downloaded and installed the CVP CUIS templates however none of those prompt for input parameters.
 
Thank you.
Bill Westby
Flag

RE: CUIS and CVP Informix Database Input Parameter Format
Answer
8/13/10 5:32 PM as a reply to Bill Westby.
I'm trying to write a custom CUIS report but cannot figure out how to get input parameters into the script.  The DECLARE @var does not work (it seems) with Informix, the DECLARE statement in Informix seems to be for cursor usage, generates a validation error which is very generic. 
 
Does anyone have experience writing Informix queuries against the CVP database and specifiying input parameters like date, element name, etc.?  I downloaded and installed the CVP CUIS templates however none of those prompt for input parameters.
 
Thank you.
Bill Westby


Drop the SQL in SQL Server 2005 and it will give you a more detailed error message. Nothing everything that will go through on SQL Server will go through in CUIS though so keep that in mind.
Flag