Default Directory That Holds the File
The database server treats the specified filename (and any pathname) as relative.
On UNIX™, if you specify a simple filename instead of a full pathname as the file parameter, the client application looks for the file in your home directory on the computer where the database resides. If you do not have a home directory on this computer, the default directory is the root directory.
On Windows™, if you specify a filename but no directory as the file parameter, the client application looks for the file in your current working directory if the database is on the local computer. Otherwise, the default directory is %ONEDB_HOME%\bin.
Important: The preprocessor
does not process the contents of the file that you specify. It only
sends the contents to the database server for execution. Therefore,
there is no syntactic check that the file that you specify in CREATE
PROCEDURE FROM actually contains a CREATE PROCEDURE statement. To
improve readability of the code, however, it is recommended that you
match these two statements.