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:

SYNTAX
int
sqldyndescinp ( sqln, psqlda )
  SQLRQHDL    *sqln;  /* INPUT */
  SQLDA_T      *psqlda;  /* OUTPUT */ 

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

This example describes and initializes the parameter marker attribute information in the SQL descriptor area to which psqlda refers for a prepared searched UPDATE:

#include "proesql.h"
static SQLRQHDL *sql1 = (SQLRQHDL *) 0;
static long    SQLCODE;
struct SQLDA_T   *psqlda = (struct SQLDA_T *) 0;
            .
            .
            .
if ((psqlda = sqlald((int) 2)) == (struct SQLDA_T *) 0)
{
  printf("Couldn’t alloc memory for 2 parameter markers.\n");
  break;
}
            .
            .
            .
sqlcdbind(&SQLCODE, (char *)0);
sqldynprep(			&sql1, 
        "UPDATE customer SET name = ? WHERE cust\-num = ?, 
        "STMT6"
      );
            .
            .
            .
sqlcdbind(&SQLCODE, (char *)0);
sqldyndescinp(sql1, psqlda); 

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