STRDEL bind option

The STRDEL bind option designates whether an apostrophe (') or double quotation marks (") is used as the string delimiter within SQL statements. If a value is not specified, Db2 uses the value specified in the SQL STRING DELIMITER field on panel DSNTIPF.

Command option Option values Used with
STRDEL
  • ( APOSTROPHE )
  • ( QUOTE )

Option values for STRDEL

STRDEL(APOSTROPHE)
Use an apostrophe (') as the string delimiter.
STRDEL(QUOTE)
Use double quotation marks (") as the string delimiter.

Default values for STRDEL

Process Default value
BIND SERVICE The value specified in the SQL STRING DELIMITER field of the DSNTIPF subsystem parameter