Clean-up Resources

How to Add Inline Code Statements Containing ODBC/JDBC/ADO.NET Statements › Inline Code Statements with ODBC/JDBC/ADO.NET › Clean-up Resources

Clean-up Resources

Use the Code section of the inline statement to specify code that will clear up resources after the execution is complete. Resources specific to the data access layer must be released after their use.

C/ODBC

/* To execute SQL (INSERT) query */
ret_code = TiodbcFreeStmt(&create_stmt);

/* To execute SQL (SELECT) query */
ret_code = TiodbcFreeStmt(&read_stmt);

/* To execute SQL (UPDATE) query */
ret_code = TiodbcFreeStmt(&update_stmt);

C#/ADO.NET

/* To execute SQL (INSERT) query */
create_cmd.Close();

/* To execute SQL (SELECT) query */
read_rs.Close();
read_cmd.Close();

/* To execute SQL (INSERT) query */
update_cmd.Close();

JAVA/JDBC

/* To execute SQL (INSERT) query */
create_cmd.close();

/* To execute SQL (SELECT) query */
read_rs.close();
read_cmd.close();

/* To execute SQL (UPDATE) query */
update_cmd.close();

Provide details in the remaining fields in the dialog and click OK to close the dialog.

Appendix

Following SQL C types are used in calling either SQLBindColumn (as third argument) or SQLBindParameter (as fourth argument) ODBC APIs to bind the columns and query parameters respectively.

Table 1:

C/ ODBC	Gen Data Type	SQL C Types Used in ODBC APIs
	TEXT	SQL_C_CHAR
	NUMBER	SQL_C_SSHORT SQL_C_SLONG SQL_C_DOUBLE
	NUMBER (with precision enabled)	SQL_C_CHAR
	DATE	SQL_C_TYPE_DATE
	TIME	SQL_C_TYPE_TIMESTAMP
	TIMESTAMP	SQL_C_TYPE_TIMESTAMP
	BLOB	<none>

Following methods are used to bind query parameter with host variable before executing a query.

Table 2:

C# / ADO.NET	Gen Data Type	C# Method to Bind Query Parameter With Host Variable
	TEXT	IAbstractCommand.BindParamter
	NUMBER	IAbstractCommand.BindParamter
	NUMBER (with precision enabled)	IAbstractCommand.BindParamter
	DATE	IAbstractCommand.BindParamter
	TIME	IAbstractCommand.BindParamter
	TIMESTAMP	IAbstractCommand.BindParamter
	BLOB	IAbstractCommand.BindParamter

Table 3:

Java / JDBC	Gen Data Type	Java Method to Bind Query Parameter With Host Variable
	TEXT	PreparedStatement.bindParameterString
	NUMBER	PreparedStatement.setShort PreparedStatement.setInt PreparedStatement.setDouble
	NUMBER (with precision enabled)	PreparedStatement.setBigDecimal
	DATE	PreparedStatement.setDate
	TIME	PreparedStatement.setTime
	TIMESTAMP	PreparedStatement.setTimestamp
	BLOB	PreparedStatement.bindParameterBlob

Following methods are used to retrieve column value from the given result set after executing a query.

Table 4:

C# / ADO.NET	Gen Data Types	C# Method to Retrieve Column Value From Result Set
	TEXT	Globdata.GetDBMSData().GetDBMSManager().GetString
	NUMBER	Globdata.GetDBMSData().GetDBMSManager().GetInt16 Globdata.GetDBMSData().GetDBMSManager().GetInt32 Globdata.GetDBMSData().GetDBMSManager().GetDouble
	NUMBER (with precision enabled)	Globdata.GetDBMSData().GetDBMSManager().GetDecimal
	DATE	Globdata.GetDBMSData().GetDBMSManager().GetDateTime
	TIME	Globdata.GetDBMSData().GetDBMSManager().GetDateTime
	TIMESTAMP	Globdata.GetDBMSData().GetDBMSManager().GetDateTime
	BLOB	Globdata.GetDBMSData().GetDBMSManager().GetBlob

Table 5:

Java / JDBC	Gen Data Types	Java Method to Retrieve Column Value From Result Set
	TEXT	globdata.getDBMSData().getDBMSManager().getStringFromResultSet
	NUMBER	ResultSet.getShort ResultSet.getInt ResultSet.getDouble
	NUMBER (with precision enabled)	globdata.getDBMSData().getDBMSManager().getBigDecimalFromResultSet
	DATE	ResultSet.getDate
	TIME	globdata.getDBMSData().getDBMSManager().getTimeFromResultSet
	TIMESTAMP	ResultSet.getTimestamp
	BLOB	globdata.getDBMSData().getDBMSManager().getBlobFromResultSet