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"}]
Was this topic helpful?
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