HSQLDB example source code file (dsv-prepare.sql)

This example HSQLDB source code file (dsv-prepare.sql) is included in the DevDaily.com "Java Source Code Warehouse" project. The intent of this project is to help you "Learn Java by Example" ^TM.

Java - HSQLDB tags/keywords

and, and, create, create, insert, int, int, into, n, n, pl, table, values, where

The HSQLDB dsv-prepare.sql source code

/*
 * $Id: dsv-prepare.sql 311 2007-06-24 15:22:11Z unsaved $
 *
 * Tests PL 'prepare' command
 */

CREATE TABLE t (i INT, a INT, b INT, c INT);

* N = 4567
* prepare N

INSERT INTO t(i, a, b, c) VALUES (1, ?, 8, 9);

SELECT count(*) FROM t WHERE i = 1 AND a = 4567 AND b= 8 AND c = 9;

*if (*? != 1)
    \q PL prepare command failed
*end if