If the LONG column to be opened is only to be determined at runtime, the OPEN statement has to be constructed dynamically. Since, as described above, it is not possible to assign output values of an SQL statement to SQL-PL variables, the LONG descriptor returned by the dynamic OPEN statement must be specially treated.
For this purpose, the statement FETCH LONGDESCR is available which must immediately follow the dynamic OPEN statement. The LONG column descriptor generated with the OPEN statement is thus assigned to an SQL-PL variable and can therefore be used for further LONG statements.
Example:
Syntax:
