Once they are declared, Adaptive Server stores SQL statements containing LOBs.
In Adaptive Server version 15.7 and later, you can:
- Declare a large object (LOB) text, image, or unitext datatype for a local variable, and pass that variable as an input parameter to a stored procedure.
- Prepare SQL statements that include LOB parameters.
See the Reference Manual: Building Blocks.