EXEC SQL Program Relationship Projections

Statement Format Relationship Entities
ALTER TABLE
ALTER TABLE <table-name> …
Program Manipulates Table Table.Name = <table-name>
CALL
EXEC SQL CALL <procedure-name> …
PROGRAM Calls Program Entry Point Program Entry Point:
  • Name = <procedure-name>
  • MainEntry = false
CREATE INDEX
CREATE INDEX <index-name> 
ON <table-name> … 
				
Program Manipulates Table Table.Name = <table-name>
CREATE TABLE
CREATE TABLE <table-name>...
         [IN [DATABASE] [<database>.] <tablespace>]
Program Manipulates Table

Table attributes:

  • Database
  • TableSpace
  • Name = <table-name>
  • Origin = <source-file-path>
CREATE PROCEDURE
CREATE [OR REPLACE] PROCEDURE <procedure-name> …
Program Defines Stored Procedure Program Entry Point:
  • Name = <procedure-name>
  • MainEntry = false
DELETE
DELETE FROM <table-name>…
Program Deletes From Table Table.Name = <table-name>
DROP TABLE
DROP TABLE <table-name>
Program Manipulates Table Table.Name = <table-name>
INSERT
INSERT INTO <table-name> … 
				
Program Inserts Into Table Table.Name = <table-name>
SELECT
SELECT … FROM table-name
Program Reads Table Table.Name = <table-name>
UPDATE
UPDATE <table-name> …
Program Updates Table Table.Name = <table-name>