CUIS and CVP Informix Database Input Parameter Format

Version 1
    This document was generated from CDN thread

    Created by: Bill Westby on 10-08-2010 12:07:57 AM
    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

    Subject: RE: CUIS and CVP Informix Database Input Parameter Format
    Replied by: Brandon McDowall on 13-08-2010 12:32:11 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


    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.