SUBSTR or SUBSTRING extracts nchars characters from the string, starting at start_pos. If nchars is omitted, SUBSTR and SUBSTRING extracts characters from start_pos through the end of the string. Trailing spaces are automatically truncated. To avoid syntax errors, be sure to separate numeric values with a comma and a space, as shown in the examples.
IBM®Interact supports the following formats only: SUBSTR(string_value, start_pos[, nchars]) or SUBSTRING(string_value, start_pos[, nchars])