Specify a listing file

The WITH LISTING IN option allows you to direct any compile-time warnings that might occur to a file.

The following figure shows how to log the compile-time warnings in /tmp/warn_file when you work on UNIX™.
Figure 1: Log the compile-time warnings on UNIX.
CREATE FUNCTION raise_prices(per_cent INT)
. . .
END FUNCTION
   WITH LISTING IN '/tmp/warn_file'
The following figure shows how to log the compile-time warnings in \tmp\listfile when you work on Windows™.
Figure 2: Log the compile-time warnings on Windows.
CREATE FUNCTION raise_prices(per_cent INT)
. . .
END FUNCTION
   WITH LISTING IN 'C:\tmp\listfile'

Always remember to place single or double quotation marks around the file name or path name.