SMFSQL (FTP server) statement

Use the SMFSQL statement to specify that SMF records are collected when FILETYPE is SQL (SQL query function).

If SMFSQL is not specified, no SMF records are issued when FILETYPE is SQL.

Syntax


>>-SMFSQL--+---------+-----------------------------------------><
           '-TYPE119-'

Parameters

TYPE119: Issue records for filetype SQL for all type 119 SMF records. If no parameters are given, records for filetype SQL are issued for all type 118 SMF records.

Examples

To record SMF type 118 records for RETR when FILETYPE=SQL, use the following code:

SMFRETR STD
SMFSQL

To record SMF type 119 records for RETR when FILETYPE=SQL, use the following code:

SMFRETR TYPE119
SMFSQL TYPE119

Usage notes

SMFSQL statements for each record type (118 and 119) function independently of each other.

Related topics