Understanding SQL & Java Together: A Guide to SQLJ, JDBC, and Related Technologies

Appendix F: SQLJ Part 1 Syntax

F.1 Introduction

This appendix contains the syntax defined in SQLJ Part 1. Some of the nonterminals refer to elements defined in either Java or SQL.

F.2 Names and Identifiers

 ::=             !! SQL identifier ::=            !! Java identifier ::=               !! SQL data type ::=     [ [  . ]  . ]  ::=  ::=  ::= 

F.3 SQL-Java Paths

 ::= [ ... ] ::= ( ,  ) ::=       [  . ] *      [  . ]  ::=  [ .  ]... ::=  ::=  ::= 

F.4 SQLJ Procedures

sqlj.install_jar (url IN VARCHAR(*), jar IN VARCHAR(*),                  deploy IN INTEGER)sqlj.replace_jar (url IN VARCHAR(*), jar IN VARCHAR(*))sqlj.remove_jar (jar IN VARCHAR(*), undeploy IN INTEGER)sqlj.alter_java_path (jar varchar(*), path varchar(*))

F.5 DDL Statements

F.5.1 CREATE PROCEDURE/FUNCTION Statement

 ::=     CREATE PROCEDURE  ( [  ] )          [ DETERMINISTIC  NOT DETERMINISTIC ]      ::=     CREATE FUNCTION         ( [  ] )...

UNLIMITED FREE
ACCESS
TO THE WORLD'S BEST IDEAS

SUBMIT
Already a GlobalSpec user? Log in.

This is embarrasing...

An error occurred while processing the form. Please try again in a few minutes.

Customize Your GlobalSpec Experience

Category: Statistical Process Control Software (SPC)
Finish!
Privacy Policy

This is embarrasing...

An error occurred while processing the form. Please try again in a few minutes.