QUERYID bind option

The QUERYID option frees entries in the SYSIBM.SYSQUERY table, and the SYSIBM.SYSQUERYPLAN table or the SYSIBM.SYSQUERYOPTS table.

Command option	Option values	Used with
QUERYID	(number) (ALL)	FREE QUERY subcommand (DSN)

Option descriptions for QUERYID

DELIM(number): Frees an entry in the SYSIBM.SYSQUERY table that has the same QUERYID value, and the corresponding entries in the SYSIBM.SYSQUERYPLAN table or the SYSIBM.SYSQUERYOPTS table.
DELIM(ALL): Frees all the entries from the SYSIBM.SYSQUERY table and the corresponding entries from the SYSIBM.SYSQUERYPLAN table or the SYSIBM.SYSQUERYOPTS table.