1.9.3 SQL executability using a non-POSIX library version of HiRDB (UNIX version only)

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

ClassificationSQL statementExecutable?SQL cannot be executed
Definition SQLALTER PROCEDURECIf a Java procedure is specified
ALTER ROUTINECIf a Java procedure or a Java function is specified
CREATE FUNCTIONCIf a Java routine is used
CREATE PROCEDURECIf a Java routine is used
CREATE TYPECIf a Java routine is used
CREATE VIEWCIf a Java function is specified
DROP FUNCTIONY

N/A

DROP PROCEDUREY

N/A

DROP SCHEMAY

N/A

Data manipulation SQLASSIGN LIST statementY

N/A

CALL statementC
  • Java procedure
  • Procedure using a Java routine
DELETE statementY

N/A

DROP LIST statementY

N/A

FREE LOCATOR statementY

N/A

INSERT statementCIf a Java function is used
PURGE TABLE statementYN/A
Single-row SELECT statementCIf a Java function is used
Dynamic SELECT statementCIf a Java function is used
UPDATE statementCIf a Java function is used
Assignment statementCUse of Java functions
Control SQLLOCK statementY

N/A

Embedded SQL languageINSTALL JARN

N/A

REPLACE JARN

N/A

REMOVE JARY

N/A

OtherFunction callC
  • If a Java function is called
  • If a Java function is used
Y: Can be executed.
C: Results in an error depending on the condition.
N: Cannot be executed.
N/A: Not applicable