IP API Reference for Java : Statement-level Methods for Java : sqlipSetInfo

sqlipSetInfo

This method is called to inform the IP of various statement level options such as the maximum number of rows to return, and query timeout. The IP can optionally use this information in its processing.

int sqlipSetinfo(

int iInfoType,

String sInfoValue);

Table 111: Parameters for sqlipSetInfo
Parameter	Type	Description
INPUT
iInfoType	Option type	Options are is defined in Table 112.
RETURN
	int	OADS_SUCCESS – if you are able to successfully apply the option or if you want to ignore the options. OADS_ERROR – if error in handling the requested option for which you do have support.

The following table describes the syntax for the SetInfo options.

Table 112: SetInfo Options
iInfoTpe	Description
OADS_STMT_INFO_QUERY_ TIMEOUT	Seconds to wait for query to finish executing. A value of 0 indicates no limit.
OADS_STMT_INFO_MAX_ROWS	Maximum number of rows to return. A value of 0 indicates no limit. This value must be a 64-bit integer.