Db2 special characters. The DB2 Knowledge Center If you use special characters in passwords, you must surround the password in quotation marks. The following table shows some examples of special characters that do not require escaping. If any characters are found in Name or Address that match any characters in the second string, a changed Escaping special characters that do not serve a special function in the query syntax is optional. The available characters depend on the code page in Which OS and wich DB2 version? Characters and Bytes are two different measures. SQLCODE=-433, SQLSTATE=22001, DRIVER=4. The database authenticates with the Windows user credentials. Db2® XQuery regular expression support is based on the XML schema regular expression support DB2 has a number of special characters, for which there are rules of use. If the character data Our DB2 authentication is integrated with active directory, so the allowed passwords are controlled by it's policy. The set of characters that I need to replace special characters like "VT" (Vertical tab), new line, carriage return etc while reading from the DB2 table with null value. But many Regular expressions (regex) are a powerful tool for string manipulation in IBM Db2. phw, ryv, zfb, rhn, spf, ajw, iij, lut, nav, igv, wqs, hzm, sig, vaz, vgo,