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

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	Java procedure Procedure using a Java routine
	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	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

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