IBM Support

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"}]

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 the link to actual document below to access the full document. You will be asked to log on if you are not already logged in. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

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

Manage My Notification Subscriptions