Troubleshooting
Problem
The StaticBinder utility issues an error with SQLCODE -113 when you use the pureQuery tooling to bind the SQL in an interface or pureQueryXML file and your project is associated with DB2 for System i® V5R3 or V5R4.
Symptom
The StaticBinder utility issues an error in the Console view when you try to bind the SQL, as in this example:
Following Exception(s)/Warning(s) were reported for package : DeptData1 at
BIND STEP
Error Code : -113, SQLSTATE : 42602
Message : Name not allowed.. SQLCODE=-113, SQLSTATE=42602, DRIVER=4.7.89
Cause
When you specify a root package name in the Default.genProps file for the SQL in an interface that declares annotated methods or for the SQL in a pureQueryXML file, the pureQuery tooling does not check whether the root package name is capitalized or under eight characters when your project is associated with DB2 for System i® V5R3 or V5R4. Root package names for DB2 for System i® V5R3 or V5R4 must meet both of these requirements.
Resolving The Problem
Change the root package name opening the Default.genProps file and editing the entry for the interface or pureQueryXML file. Save the file and then try the bind operation again.
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21390665