In versions earlier than 15.7 ESD #2, Adaptive Server had a 16K limit on the size of individual statements stored in the statement cache, even if you configured statement cache size to a larger size.
Adaptive Server versions 15.7 ESD #2 and later allow you to store individual SQL statements up to 2MB (for a 64-bit machine) in the statement cache after you increase the statement cache size and max memory configuration parameters.
Use show_cached_text to display the statement cache’s SQL query text if it is less than 16K. However, if the SQL query text is larger than 16K, show_cached_text truncates the SQL query text, even if the full text is available in the statement cache.
Use show_cached_text_long to display SQL query text larger than 16K. show_cached_text_long displays SQL query text up to 2MB in size.
