IBM Informix Embedded SQLJ User's Guide
Chapter 1: Introducing IBM Informix Embedded SQLJ
Contents
Index
Embedded SQLJ Versus JDBC
Embedded SQLJ does not support dynamic SQL; you must use the JDBC API if you want to use dynamic SQL. Your Embedded SQLJ program can call the JDBC API to perform a dynamic operation (the SQLJ connection-context object that you use to connect an Embedded SQLJ program to the database contains a JDBC
Connection
object that you can use to create JDBC statement objects).
If you are using static SQL, Embedded SQLJ provides the following advantages:
Default connection context
. You only need to set the default connection context once within a program; then every subsequent Embedded SQLJ statement uses this connection context unless you specify otherwise.
Reduced statement complexity
. For example, you do not need to explicitly bind each variable; Embedded SQLJ performs binding for you. Generally, this feature allows you to create smaller programs than with the JDBC API.
Compile-time syntax and semantics checking
. The Embedded SQLJ translator checks the syntax of SQL statements.
Compile-time type checking
. The Embedded SQLJ translator and the Java compiler check that the Java data types of arguments are compatible with the SQL data types of the SQL operation.
Compile-time schema checking
. You can connect to a sample database schema during translation to check that your program uses valid SQL statements for the tables, views, columns, stored procedures, and so on in your sample.
IBM Informix Embedded SQLJ User's Guide
, Version 1.0
Copyright © 1999, IBM Corporation. All rights reserved.