9.7.9 SET

Purpose

The SET command sets a variable to alter the DBMCLI environment settings for the current session.

Syntax

SET DATEFORMAT {LOCAL | STANDARD}
SET ECHO [ON | OFF]

Usage Notes

The SET DATEFORMAT command controls the format of displayed dates. For commands that accept dates, the standard date-time format is recommended. The local format is also accepted. The standard format is recommended for scripts because that format is less sensitive to the time zone, region, and locale changes that might occur when running a script.

The SET ECHO command controls whether to echo commands in a script that is run with @ or START. The ON option displays the commands on screen. The OFF option suppresses the display. The SET ECHO command does not affect the display of commands entered interactively or redirected from the operating system.

Example 9-80 Setting the Date Format with the SET Command

SET DATEFORMAT STANDARD