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>