SHOW and Embedded SQL
SHOW is a data returning statement. It returns a single row of a single column whose data type is VARCHAR(20480), and which contains new line characters embedded in the character string.
In the workstation-attached environment, SHOW returns carriage return characters in the string, which locate the cursor to the first position of the current line.
SHOW... INTO cannot be performed as a dynamic statement. Dynamic execution of data returning statements always requires a dynamic cursor.