Compile-time warnings

If the database server detects a potential problem, but the syntax of the SPL routine is correct, the database server generates a warning and places it in a listing file. You can examine this file to check for potential problems before you execute the routine.

The file name and path name of the listing file are specified in the WITH LISTING IN clause of the CREATE PROCEDURE or CREATE FUNCTION statement. For information about how to specify the path name of the listing file, see Specify a DOCUMENT clause.

If you are working on a network, the listing file is created on the system where the database resides. If you provide an absolute path name and file name for the file, the file is created at the location you specify.

For UNIX™, if you provide a relative path name for the listing file, the file is created in your home directory on the computer where the database resides. (If you do not have a home directory, the file is created in the root directory.)

For Windows™, if you provide a relative path name for the listing file, the default directory is your current working directory if the database is on the local computer. Otherwise the default directory is %ONEDB_HOME%\bin.

After you create the routine, you can view the file that is specified in the WITH LISTING IN clause to see the warnings that it contains.