IBM Support

Restrictions when using Interactive SQL (STRSQL)

News


Abstract

This document provides information on the limitations of using STRSQL to run SQL statements that is provided with product 5770ST1.

Content

It is suggested that ACS Run SQL Script be used for running SQL statements. 
STRSQL does not support the following:

1.  LOB data types.  *POINTER or unreadable characters will be returned.  You can cast the data type to a CHAR when possible (limited to the max size of char field).
      Example - select cast(LOB_Field as char(100) ccsid 37 ) as LOB_FIELD_CHAR
                           FROM LIB/FILE1

2.  SQL statements that return a result set.  

[{"Type":"MASTER","Line of Business":{"code":"LOB68","label":"Power HW"},"Business Unit":{"code":"BU070","label":"IBM Infrastructure"},"Product":{"code":"SWG60","label":"IBM i"},"ARM Category":[{"code":"a8m0z0000000CHeAAM","label":"IBM i Db2"}],"Platform":[{"code":"PF012","label":"IBM i"}],"Version":"All Versions"}]

Document Information

More support for:
IBM i

Component:
IBM i Db2

Software version:
All Versions

Operating system(s):
IBM i

Document number:
7168024

Modified date:
10 September 2024

UID

ibm17168024

Manage My Notification Subscriptions