Table 1-27 shows the executability of SQL statements in non-POSIX library versions of HiRDB. In the case of the HP-UX, Solaris, and AIX 5L versions, the non-POSIX library version of HiRDB refers to a HiRDB in which the load module in the POSIX library version has not been set up with the pdsetup command.
Table 1-27 Executability of SQL statements in non-POSIX library versions of HiRDB
Classification | SQL statement | Executable? | SQL cannot be executed |
---|---|---|---|
Definition SQL | ALTER PROCEDURE | C | If a Java procedure is specified |
ALTER ROUTINE | C | If a Java procedure or a Java function is specified | |
CREATE FUNCTION | C | If a Java routine is used | |
CREATE PROCEDURE | C | If a Java routine is used | |
CREATE TYPE | C | If a Java routine is used | |
CREATE VIEW | C | If a Java function is specified | |
DROP FUNCTION | Y | N/A | |
DROP PROCEDURE | Y | N/A | |
DROP SCHEMA | Y | N/A | |
Data manipulation SQL | ASSIGN LIST statement | Y | N/A |
CALL statement | C |
| |
DELETE statement | Y | N/A | |
DROP LIST statement | Y | N/A | |
FREE LOCATOR statement | Y | N/A | |
INSERT statement | C | If a Java function is used | |
PURGE TABLE statement | Y | N/A | |
Single-row SELECT statement | C | If a Java function is used | |
Dynamic SELECT statement | C | If a Java function is used | |
UPDATE statement | C | If a Java function is used | |
Assignment statement | C | Use of Java functions | |
Control SQL | LOCK statement | Y | N/A |
Embedded SQL language | INSTALL JAR | N | N/A |
REPLACE JAR | N | N/A | |
REMOVE JAR | Y | N/A | |
Other | Function call | C |
|