The lvarchar pointer variables

The following sections illustrate how to insert to and select from an opaque type column with an lvarchar pointer host variable. The structural representation of the opaque type column that the examples use is referred to as polygon_type, and is defined in the following lines:
struct {
int no_of_edges; /* No of sides in the polygon */
int length[100]; /* Maximum number of edges in this polygon
                    is 100 */
int center_x; /* Center x co-ordinate of the polygon */
int center_y; /* Center y co-ordinate of the polygon */
}
The following line illustrates the string representation of this column:
"no_of_edges, length_of_edge 1, . . . length_of_edge n, -1, center_x, 
center_y”

For information about a using an lvarchar pointer host variable with a FETCH or PUT statement that uses a dynamic SQL descriptor, see An lvarchar pointer host variable with a descriptor.


Copyright© 2019 HCL Technologies Limited