DDL Command Dependencies Example 1

You cannot run global DDL commands if the coordinator node is not running. Attempting to do so results in the error SQLCODE: -1004011, SQLSTATE QIA11: Coordinator node not responding.

For example, if you created this temporary function or stored procedure:

CREATE TEMPORARY FUNCTION f1() RETURNS INT
BEGIN
RETURN 1;
END

Next, if you tried to create a view that is dependent on the temporary function:

CREATE VIEW v1 AS SELECT * FROM f1()

You would receive the error Procedure 'f1' not found since it is not a permanent procedure. SAP Sybase IQ does not allow such operations in a multiplex environment.