DB2 10.5 for Linux, UNIX, and Windows

JDBC samples

UNIX directory: sqllib/samples/java/jdbc.

Windows directory: sqllib\samples\java\jdbc.

JDBC samples include the following types of programs:

ADMIN_CMD routine samples: Samples that demonstrate the use of ADMIN_CMD stored procedure for administration tasks via SQL interface
Installation-image-level samples: Programs that deal with the installation image level of the database product.
Database-level samples: Programs that deal with database objects.
Table-level samples: Programs that deal with table objects.
Data type samples: Programs that deal with data types.
Applet samples: Samples that demonstrate Java applets.
Stored procedure samples: Samples that demonstrate stored procedures.
User-defined function samples: Samples that demonstrate user-defined functions.
Java bean samples: Samples that demonstrate Java bean classes.
Java GSS-API Plugin samples: Samples that demonstrate the JCC GCC_API plugin
Other samples: Samples that do not fall into any of the previous categories.

Table 1. JDBC sample program files
Type of sample	Sample program name	Program Description
ADMIN_CMD stored procedure samples	`AdmCmdAutoCfg.java`	How to autoconfigure a database using ADMIN_CMD routine.
	`AdmCmdContacts.java`	How to add, update and drop contacts and contactgroups using ADMIN_CMD routine.
	`AdmCmdOnlineBackup.java`	How to perform online backup using ADMIN_CMD routine.
	`AdmCmdUpdateCfg.java`	How to update and reset the Database and Database Manager configuration parameters using ADMIN_CMD routine.
	`AdmCmdExport.java`	How to export data using ADMIN_CMD routine.
	`AdmCmdImport.java`	How to import data using ADMIN_CMD routine.
	`AdmCmdQuiesce.java`	How to quiesce tablespace and database using ADMIN_CMD routine.
	`AdmCmdDescribe.java`	How to describe table and indices using ADMIN_CMD routine.
Installation-image-level samples	`IlInfo.java`	How to get and set installation level information.
Database-level samples	`DbAuth.java`	How to grant/display/revoke authorities at the database level.
	`DbAuth.java`
	`DbConn.java`	How to connect and disconnect from a database.
	`DbInfo.java`	How to get and set information at a database level.
	`DbMCon.java`	How to connect and disconnect from multiple databases.
	`DbNative.java`	How to translate a statement that contains an ODBC escape clause to a data source specific format.
	`DbRsHold.java`	How to use result set cursor holdability in Universal JDBC driver for Linux, Unix and Windows. The Universal JDBC driver implements the result set cursor holdability APIS specified in JDBC3.
	`DbSeq.java`	How to create, alter and drop a sequence in a database.
	`DbUse.java`	How to use database objects.
	`GetDBCfgParams.java`	How to get database configuration parameters.
	`GetDBMCfgParams.java`	How to get database manager configuration parameters.
	`GetLogs.java`	How to get customer view of diagnostic log file entries.
	`TrustedContext.java`	How to create a trusted context, identify and use a trusted connection for switching user IDs, and acquire trusted context-specific privileges.
Table-level samples	`Cgtt.java`	How to use created temporary tables with procedures, functions, triggers and views.
	`GetMessage.java`	How to get error message in the required locale with token replacement.
	`ImplicitCasting.java`	How to use implicit casting.
	`LargeRid.java`	How to enable Large RIDs support on both new tables / tablespaces and existing tables/tablespaces.
	`ScalarFunctions.java`	How to use improved scalar functions.
	`SetIntegrity.java`	How to perform online SET INTEGRITY on a table.
	`TbAST.java`	How to use staging table for updating deferred AST.
	`TbCompress.java`	How to create tables with null and default value compression option.
	`TbConstr.java`	How to work with table constraints.
	`TbCreate.java`	How to create, alter and drop tables.
	`TbGenCol.java`	How to use generated columns.
	`TbIdent.java`	How to use Identity Columns.
	`TbInfo.java`	How to get and set information at a table level.
	`TbInTrig.java`	How to use an 'INSTEAD OF' trigger on a view.
	`TbMerge.java`	How to use the MERGE statement.
	`TbMod.java`	How to modify information in a table.
	`TbOnlineInx.java`	How to create and reorg indexes on a table.
	`TbPriv.java`	How to grant/display/revoke table level privileges.
	`TbRead.java`	How to read information in a table.
	`TbRowcompress.java`	How to perform row compression on a table and use the Automatic Dictionary Creation enhancement.
	`TbSel.java`	How to select from each of: insert, update, delete.
	`TbTemp.java`	How to use Declared Temporary Tables.
	`TbTrig.java`	How to use a trigger on a table.
	`TbUMQT.java`	How to use user materialzed query tables (summary tables).
	`TbUnion.java`	How to insert through a UNION ALL view.
Data types	`DtInfo.java`	How to get information about data types.
	`DtLob.java`	How to read and write LOB data.
	`DtUdt.java`	How to create, use, and drop user-defined distinct types.
Applet samples	`Applt.java`	How to use applets.
Stored procedure samples	`spcat`	Stored procedure catalog script for the spserver program. This script calls SpDrop.db2 and SpCreate.db2 in UNIX.
	`spcat`	Stored procedure catalog script for the spserver program. This script calls SpDrop.db2 and SpCreate.db2 in Windows.
	`SpCreate.db2`	CLP script to issue CREATE PROCEDURE statements.
	`SpDrop.db2`	CLP script to drop stored procedures from the catalog.
	`SpClient.java`	Client program used to call the server functions declared in SpServer.java.
	`SpServer.java`	Stored procedure functions built and run on the server.
	`Arrays_Sqlpl.java`	Use ARRAY variable in SQL stored procedure.
	`Array_Stack.java`	Use ARRAY variable in SQL stored procedure. Implement stack functions.
	`bonus_calculate.db2`	Stored procdure code for Array_Sqlpl.java sample to query the bonus for an employee.
	`stack_functions.db2`	Stored procdure code for Array_Stack.java sample to implement stack functions.
User-defined function samples	`UDFcli.java`	Client application which calls the user-defined function library UDFsrv.
	`UDFsrv.java`	User-defined functions called by UDFcli.java.
	`udfcat`	UDF catalog script for the UDFsrv program. This script calls UDFDrop.db2 and UDFCreate.db2 in UNIX.
	`udfcat`	UDF catalog script for the UDFsrv program. This script calls UDFDrop.db2 and UDFCreate.db2 in Windows.
	`UDFDrop.db2`	CLP script to drop UDFs from the catalog.
	`UDFCreate.db2`	CLP script to issue CREATE PROCEDURE statements.
	`UDFjcli.java`	Client application which calls the user-defined function library UDFjsrv.
	`UDFjsrv.java`	User-defined functions called by UDFjcli.java.
	`udfjcat`	UDF catalog script for the UDFjsrv program. This script calls UDFjDrop.db2 and UDFjCreate.db2 in UNIX.
	`udfjcat`	UDF catalog script for the UDFjsrv program. This script calls UDFjDrop.db2 and UDFjCreate.db2 in Windows.
	`UDFjDrop.db2`	CLP script to drop UDFs from the catalog.
	`UDFjCreate.db2`	CLP script to issue CREATE PROCEDURE statements.
	`UDFsCreate.db2`	How to catalog the UDFs contained in UDFsqlsv.java
	`UDFsDrop.db2`	How to uncatalog the UDFs contained in UDFsqlsv.java
	`UDFsqlcl.java`	Call the UDFs in UDFsqlsv.java
	`UDFsqlsv.java`	User-Defined Functions with SQL statements called by UDFsqlcl.java
Java bean samples	`CreateEmployee.java`	How to create an employee record.
Java bean samples	`GeneratePayroll.java`	How to generate payroll reports by department.
Java GSS-API Plugin samples	`JCCKerberosPlugin.java`	Implement a GSS-API Plugin that does Kerberos authentication using IBM DB2 Universal Driver.
	`JCCKerberosPluginTest.java`	Use JCCKerberosPlugin to get a DB2 Connection using IBM DB2 Universal Driver.
	`JCCSimpleGSSPlugin.java`	Implement a GSS-API Plugin that does userid and password checking using IBM DB2 Universal Driver.
	`JCCSimpleGSSContext.java`	Implement a GSSContext to be used by JCCSimpleGSSPlugin
	`JCCSimpleGSSCredential.java`	Implement a GSSCredential to be used by JCCSimpleGSSPlugin
	`JCCSimpleGSSException.java`	Implement a GSSException to be used by JCCSimpleGSSPlugin
	`JCCSimpleGSSName.java`	Implement a GSSName to be used by JCCSimpleGSSPlugin
	`JCCSimpleGSSPluginTest.java`	Use JCCSimpleGSSPlugin to get a DB2 Connection using IBM DB2 Universal Driver.
Other samples	`Util.java`	Utilities for JDBC sample programs.