IBM Informix Embedded SQLJ User's Guide

######

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.