Resolving DB2 SQL Error: SQLCODE=-302 When Creating a New Data Source

Troubleshooting

Problem

When attempting to add a new data source on the QMF server, the process reaches the final step but results in the following error:

"REP01004. The following error has occurred while accessing database: DAL010059. An error occurred while accessing the database: DB2 SQL Error: SQLCODE=-302, SQLSTATE=22001, SQLERRMC=null, DRIVER=4.33.32"

Extended error description is as below:
The value of a host variable in the EXECUTE or OPEN statement is too large for its corresponding use.

Version:

QMF Server version V13.1.1.0, Build ID 20230718.

Document Location

Worldwide

[{"Type":"MASTER","Line of Business":{"code":"LOB76","label":"Data Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SS6QWT","label":"IBM QMF Analytics for Multiplatforms"},"ARM Category":[{"code":"a8mKe0000008OIPIA2","label":"QMF Z Client-\u003EQMF Server"}],"ARM Case Number":"TS017578386","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"}]

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

More support for:
IBM QMF Analytics for Multiplatforms

Component:
QMF Z Client->QMF Server

Software version:
All Versions

Document number:
7173726

Modified date:
07 November 2024

UID

ibm17173726

IBM Support

Tips