Adaptive Server includes the set show_sqltext, set tracefile, and set export_options parameters that enable you to collect diagnostic information about poorly-running queries without having to previously enable showplan or other investigatory parameters.
