Setting the characteristics for the SQL query

After creating a data set to use for your query, you must log on to FTP and set the file type for the query:

SITE/LOCSITE FILEtype=SQL

There are several commands that are relevant to the client and server in SQL mode. The server commands use SITE, and the client commands use LOCSITE. The following list describes the commands:

SITE/LOCSITE DB2®=: Specifies the name of the DB2 subsystem that you want to perform your queries. See Specifying the DB2 subsystem to perform the query for more information about DB2 subsystems.
SITE/LOCSITE SPRead or NOSPRead: Specifies whether you want the output to be in spreadsheet or report format. See Specifying the output format for more information about output format.
SITE/LOCSITE SQLCol=: Specifies whether you want the column headings to use the DB2 column names or labels. Valid values include Names, Labels, or Any. See Assigning column headings for the SQL query result table for more information about column headings.

To return to normal FTP processing after performing queries, or other processes, specify:

SITE/LOCSITE FILEtype=SEQ

On MVS™ systems, RECfm=VB is a recommended format that enables you to view the results of the SQL query. Issue the following command to specify that new data sets should be created with the RECfm=VB attribute:

SITE/LOCSITE RECFM=VB

To prevent the automatic sending of a SITE command that might override your SITE setting, toggle SENDSITE to OFF. For more information about the SENDSITE command, see SENDSite subcommand—Toggle the sending of site information.