sqldyndescinp() — Get Dynamic Parameter Descriptions
Gets description information for all parameter markers in a dynamic ESQL statement.
This function returns normalized values. For more information, see the function return values in the "General Diagnostics" section in this chapter:
sqln
A pointer to the request handle that a previous call to
sqldynprep()
returns. For more information on request handles, see the "SQL Request Handles" section.psqlda
A pointer to an SQLDA_T structure to receive the column description information for any parameter markers that the statement associated with
sqln
specifies.NOTES
EXAMPLE
- Typically, an application calls
sqldynprep()
to prepare a dynamic SQL statement, allocates an SQLDA_T structure, and callssqldyndescinp()
to fill in the parameter marker descriptions. Before callingsqldyndescinp()
, the application can also callsqldynnparms()
to return the number of parameter markers in the statement, and use that information to allocate an SQLDA_T structure large enough to hold the returned information.- To receive dynamic parameter marker description information, allocate the supplied SQLDA_T structure large enough to hold the number of parameter markers in the statement (
psqlda
->SQLN is equal to or greater than the number of parameters in the statement). If it is not large enough,sqldyndescinp()
setspsqlda
->COLCNT to the actual number of parameter markers and returns 0 with no parameter description information in the structure.This example describes and initializes the parameter marker attribute information in the SQL descriptor area to which
psqlda
refers for a prepared searched UPDATE:
SEE ALSO
sqlald() — Allocate Dynamic SQL Descriptor, sqldynnparms() — Get the Number of Parameter Markers, sqldynprep() — Prepare a Dynamic SQL Statement,
proesql.h
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |