CUIS and CVP Informix Database Input Parameter Format

Document created by cdnadmin on Jan 24, 2014
Version 1Show Document
  • View in full screen mode
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.

Attachments

    Outcomes