Default Directory That Holds the File

Enterprise Edition Home | Express Edition Home | Previous Page | Next Page SQL Statements > CREATE PROCEDURE FROM >

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 %INFORMIXDIR%\bin.

Important:

The ESQL/C 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.

Related Information

Related statements: CREATE PROCEDURE, CREATE FUNCTION FROM , and CREATE ROUTINE FROM