ECHO (Db2 command line processor)

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.

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

Suppose that you start the Db2 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
...