PATH
You can define paths to resources in SQL Script by providing a unique names to each path. PATH is similar to IMPORT in Java.
Remarks
• PATH should be specified in the first BEGIN/END as the first statement after BEGIN.
• Wherever you can use a variable, you can use PATH.
• PATH can be used to fully qualify unqualified tables or procedures used in the FROM clause, and CALL and INSERT/DELETE/UPDATE statements.
Syntax
PATH <full path>
Example
PROCEDURE p_path1(out outgoing int)
BEGIN
PATH /users/composite/test/views;
DECLARE public x constant int default 0;
DECLARE public y constant int default 5;
DECLARE public z constant int default 0;
DECLARE public e1 exception;
SET outgoing = y;
EXCEPTION
WHEN /users/composite/test/views/p_path1.e1 THEN
END