Troubleshooting
Problem
In some cases, the preference for "Maximum bytes to retrieve for character or binary column" on the Data Management >SQL Results View preference page behaves as if it is set to 100 in DSD2.1 and ODS 2.2 even if it is not. You will see this problem when the result set that is returned from a stored procedure contains data that has more than 100 characters or binary column data to display. If the result set data is greater than 100 characters, an ellipsis [...] button is enabled and the first 100 characters of the data is displayed in the pop-up dialog.
[{"Product":{"code":"SSSQRS","label":"Optim Development Studio"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Not Applicable","Platform":[{"code":"PF033","label":"Windows"}],"Version":"2.2","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}},{"Product":{"code":"SS62YD","label":"IBM Data Studio"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":null,"Platform":[{"code":"PF033","label":"Windows"}],"Version":"2.1","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]
Log InLog in to view more of this document
This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21395644