IBM Support

ERROR SQL Error Code: -204

Troubleshooting


Problem

ERROR SQL Error Code: -204

Symptom

Gentran Integration Suite, All Releases
Mapping to/from a DB2 database
File created on iSeries is in upper and lower case (External_Fuel_Vendor_Upload_File)

Error Message

Translation Log
ERROR SQL Error Code: -204
ERROR SQL State: 42704
com.ibm.db2.jdbc.app.DB2SQLSyntaxErrorException: EXTERNAL_FUEL_VENDOR_UPLOAD_FILE in UPGIS42 type *FILE not found.

Translation Report
Code: 721 UPDATE/INSERT/DELETE Execution Error
[SQL0204] EXTERNAL_FUEL_VENDOR_UPLOAD_FILE in JFJOHNSON type *FILE not found. Cause . . . . . :   EXTERNAL_FUEL_VENDOR_UPLOAD_FILE in UPGIS42 type *FILE was not found. If the member name is *ALL, the table is not partitioned. If this is an ALTER TABLE statement and the type is *N, a constraint or partition was not found. If this is not an ALTER TABLE statement and the type is *N, a function, procedure, trigger or sequence object was not found. If a function was not found, EXTERNAL_FUEL_VENDOR_UPLOAD_FILE is the service program that contains the function.  The function will not be found unless the external name and usage name match exactly.  Examine the job log for a message that gives more details on which function name is being searched for and the name that did not match. Recovery  . . . :   Change the name and try the request again.  If the object is a node group, ensure that the DB2 Multisystem product is installed on your system and create a nodegroup with the CRTNODGRP CL command. If an external function was not found, be sure that the case of the EXTERNAL NAME on the CREATE FUNCTION statement exactly matches the case of the name exported by the service program.

[{"Product":{"code":"SS3JSW","label":"IBM Sterling B2B Integrator"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Mapping and Translation","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All","Edition":"","Line of Business":{"code":"LOB77","label":"Automation 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.

Historical Number

NFX2251

Document Information

Modified date:
04 January 2019

UID

swg21553528