-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