Any SQL command can be run from within an embedded SQL
application. Below are some examples of how to do that. Creating
a table: EXEC SQL CREATE TABLE foo (number integer, ascii
char(16)); EXEC SQL CREATE UNIQUE INDEX num1 ON foo(number);
EXEC SQL COMMIT; EXEC SQL INSERT INTO foo (number, ascii) VALUES
(9999, 'doodad'); EXEC SQL COMMIT; EXEC SQL DELETE FROM foo
WHERE number = 9999; EXEC SQL COMMIT; EXEC SQL SELECT foo INTO
:FooBar FROM table1 WHERE ascii = 'doodad'; Select using
Cursors: EXEC SQL DECLARE foo_bar CURSOR FOR SELECT number,
ascii FROM foo ORDER BY ascii; EXEC SQL FETCH foo_bar INTO
:FooBar, DooDad; ... EXEC SQL CLOSE foo_bar; EXEC SQL COMMIT;
EXEC SQL UPDATE foo SET ascii = 'foobar' WHERE number = 9999;
EXEC SQL COMMIT; The tokens of the form :something are host
variables, that is, they refer to variables in the C program.
They are explained in the next section. In the default mode,
statements are committed only when EXEC SQL COMMIT is issued.
The embedded SQL interface also supports autocommit