Use this page to do customization and binding for the Structured Query Language in Java (SQLJ) profiles for DB2® that are included in this application. You can also use this page to do binding for pureQuery bind files in the application. You can view SQLJ profiles for other database types, but you cannot change these profiles. PureQuery bind files are only valid for DB2. Use SQLJ or pureQuery to develop data access applications that connect to DB2 databases. SQLJ is a set of programming extensions that enable a programmer to use the Java programming language to embed statements that provide SQL database requests. PureQuery provides an alternate set of APIs that can be used instead of JDBC to access the DB2 database.
To view this administrative console page, click
.Advantages of developing applications with SQLJ include improved performance and a shorter, more efficient development cycle. With SQLJ, you can:
DB2 pureQuery run time is an alternative set of APIs to JDBC or SQLJ. Advantages of developing applications with pureQuery include allowing SQL execution to be either dynamic or static. In addition to improved performance by using static SQL statements, pureQuery has better problem determination and diagnosis because it allows for errors at the DB2 server to be related back to application artifacts rather than to SQL that was generated by an application generator.
Specifies that the application server processes the SQLJ profiles that you select from this application.
By default, one DB2 package is created in the database for each isolation level. The customization process augments the profile or profiles with information that is specific for the DB2 database for use at run time. Typically, the customization process should run after the SQLJ application has been translated and before the application is started. If you do not run the customization step, the SQLJ application uses dynamic SQL like a JDBC application.
Binding DB2 SQLJ profiles involves the process of binding the customized SQLJ profiles to the DB2 database.
Specifies that the application server binds the SQLJ profiles that you select to the DB2 database server.
Bind packages from the SQLJ application that have already been customized.
Specifies the profiles to process from the list that is provided.
When SQLJ or pureQuery profiles have been added to Selected Profiles, select profiles from that list and use Move Up or Move Down to change the order in which the profiles are processed.
Specifies that the application server creates a .grp file that contains the SQLJ profiles that you selected.
When you click OK, there is an option on the next page to download the .grp file.
Specifies a profile group file from the local file system to customize or bind.
Specifies the URL of the database to which the profile or profiles are bound.
jdbc:db2://host_name:port_name/database_name
Specifies the user ID for the database administrator on the server where the database is located.
Specifies the password for the database administrator on the server where the database is located.
Specifies additional options to use during the customization and bind processes.
-bindoptions "BLOCKING NO"
For
more information about pureQuery bind options, refer to the DB2 pureQuery
Bind Utility topic.Specifies the class path where the sqlj.zip, and db2jcc.jar or db2jcc4.jar files for SQLJ are located. Specifies the class path where the pdq.jar, pdqmgt.jar, db2jcc.jar, and db2jcc_license_cisuz.jar files for pureQuery are located.