flags argument
The IBM® Netezza® SQL Extensions toolkit
regular expression functions all take a flags argument.
The
flags argument can contain any of the
following
values:
| Flag | Short description | Full description |
|---|---|---|
| m | Multi-line | Specifies that the input data might contain more than one line, so the '^' and the '$' matches should take that into account. This flag is equivalent to the Perl /m option. |
| i | Not case-sensitive | Specifies that matching takes place without considering case. This flag is equivalent to the Perl /i option. |
| c | Case sensitive | Specifies the default, which is the opposite of the i flag. |
| s | Dot all | Specifies that the period (.) character matches new lines. This flag is equivalent to the Perl /s option. |
| n | Equivalent to the s flag | Included for compatibility with vendors that use the n flag. |
| x | Extended | Specifies that white space data characters in the regular expression are ignored unless escaped. This flag is equivalent to the Perl /x option. |
| p | Preserve matching | |
| u | Unicode rules | Indicates that the input string is in UTF-8 encoding. This option is equivalent to the Perl /u option. |