skip to main content
IP API Reference for Java : Statement-level Methods for Java : sqlipGetColval
 

sqlipGetColval

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);
 
Table 93: 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.
 
Table 94: 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[ ]