Command line processor ECHO command

The ECHO command writes the contents of a text string to the output stream.

The ECHO command is useful for generating labels in an output file.

>>-ECHO--string------------------------------------------------><

Example: Use the ECHO command to identify a query in the output file

Suppose that you start the command line processor with the option -z output.txt. You connect to a DB2® server and execute these commands:

ECHO Find all tables that are not catalog tables:
ECHO SELECT NAME FROM SYSIBM.SYSTABLES WHERE NAME NOT LIKE 'SYS%'
SELECT NAME FROM SYSIBM.SYSTABLES WHERE NAME NOT LIKE 'SYS%'

output.txt contains output like this:

Find all tables that are not catalog tables:
SELECT NAME FROM SYSIBM.SYSTABLES WHERE NAME NOT LIKE 'SYS%'
NAME
...
ACT
AGEGROUP
AUX_BMP_PHOTO
AUX_EMP_RESUME
AUX_PSEG_PHOTO
...