REPSQLLOG

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