This option prompts
the SQL*Loader to use the PARFILE= option. This SQL*Loader option
lets you specify SQL*Loader command-line options in a file instead
of as command-line options. Here is an example of how you can call
the SQL*Loader by specifying user ID and control options.
sqlldr userid=scott/tiger control=example.ctl
You can also call it
by using the PARFILE = option.
sqlldr parfile=example.par
Example.par now contains
the USERID= and CONTROL= options. Security is a major advantage
of using the BL_PARFILE= option because the user ID and password are
stored in a separate file.
Permissions on the file
default to operating system defaults. Create the file in a protected
directory to prevent unauthorized users from accessing its contents.
To display the contents
of the parse file in the SAS log, use the
SASTRACE=",,,d"
option.
The password is blocked out and replaced with
xxxx
,
however.