IBM Informix Embedded SQLJ User's Guide
Chapter 4: The Embedded SQLJ Language
Contents
Index
SQL Statements
Embedded SQLJ supports SQL statements at the SQL92 Entry level, with the following additions:
The EXECUTE PROCEDURE statement, for calling SPL routines and user-defined routines
The EXECUTE FUNCTION statement, for calling stored functions
The BEGIN...END block
SQL statements must appear within curly braces, as follows:
#sql
{
create table customer
(
customer_num serial(101),
fname char(15),
lname char(15),
company char(20),
address1 char(20),
address2 char(20),
city char(15),
state char(2),
zipcode char(5),
phone char(18),
primary key (customer_num)
)
};
An SQL statement that is not enclosed within curly braces will generate a syntax error.
SQL statements are case insensitive (unless delimited by double quotes) and can be written in uppercase, lowercase, or mixed-case letters. Java statements are case sensitive.
IBM Informix Embedded SQLJ User's Guide
, Version 1.0
Copyright © 1999, IBM Corporation. All rights reserved.