Valid for
Replicat
Description
Use REPSQLLOG
to redirect the log to a file other than the Replicat report file. The default is to write the SQL log to the report file.
If you specify the SHOWSYNTAX
option of the MAP
parameter, the text of the SQL statement is displayed before the statement is executed.
You can also redirect the SQL log with the define =GGS_REPSQLLOG
.
Default
APPEND
Syntax
REPSQLLOG file_name [APPEND | PURGE | !]
file_name
The fully qualified path and file name of the alternative file, such as $data1.sqllog.jsr01
.The file_name
cannot be a structured file or SQL table, it can be a spooler, a process, a terminal or an EDIT
file.
APPEND
The default. Appends current log information to an existing file.
PURGE
Purges any existing file at startup.
Example
REPSQLLOG $data1.sqllog.jsr01