-586 THE TOTAL LENGTH OF THE CURRENT PATH SPECIAL REGISTER CANNOT EXCEED 2048 CHARACTERS
Explanation
The CURRENT PATH special register is defined as a VARCHAR(2048). The content of the string includes each schema name delimited with double quotes and sepa- rated from the next schema name by a comma. The total length of the string of all schema names in the CURRENT PATH cannot exceed 2048 characters. A SET PATH statement causing this message would exceed this limit.
System action
The statement cannot be processed.
Programmer response
Remove schema names to reduce the total length to fit the 2048 character maximum length. If all the schema names are required, it may be necessary to consolidate some user-defined functions so that fewer schema names are required for the CURRENT PATH.
SQLSTATE
42907