DataDirect OpenAccess SDK Help

sqlipGetColval

Save PDF

Save PDF

This method returns the value of the specified column for the current row.

Object sqlipGetColval(
int iColNum, 
xo_int iXODataType, 
xo_int piIndicator, 
xo_int status);

Parameters for sqlipGetColval

Parameter	Type	Description
INPUT
iColNum	int	Column number – first column starts at 0.
OUTPUT
iXODataType	xo_int	Data type of the column. This information describes how the value is returned in an object. See Table 28 for data type definitions. The type of value returned matches the iXODataType returned by the sqlipGetColspec call.
piIndicator	xo_int	Whether the column value is null or not. NULL_INDICATOR – the value is null and therefore ppVal will not contain a valid pointer. ~NULL_INDICATOR – the column has a value and will be returned in an object.
status	xo_int	OADS_SUCCESS OADS_ERROR
RETURN
	Object	Create an object to hold the column value and return it. The OpenAccess SDK layer releases the object. See Table 94 for the object type to use for the various data types.

The following table describes the object type to use for the various data types.

Returning Column Value as a Java Object

XO Type of the Column	Class Type of the Returned Object
XO_TYPE_BIT	Short
XO_TYPE_CHAR	String
XO_TYPE_NUMERIC	String
XO_TYPE_INTEGER	Integer
XO_TYPE_SMALLINT	Short
XO_TYPE_FLOAT	Double
XO_TYPE_REAL	Float
XO_TYPE_DOUBLE	Double
XO_TYPE_DATE	Integer array
XO_TYPE_LONGVARCHAR	String
XO_TYPE_TIME	Integer array
XO_TYPE_TIMESTAMP	Integer array
XO_TYPE_VARCHAR	String - string of characters
XO_TYPE_TINYINT	Short
XO_TYPE_VARBINARY	Byte[ ]
XO_TYPE_WCHAR	String
XO_TYPE_WVARCHAR	String
XO_TYPE_WLONGVARCHAR	String
XO_TYPE_LONGVARBINARY	Byte[ ]