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
Parent topic: DBMCLI Command Reference