Embedded SQLJ 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)
)
};