Why does DBRM static bind fail with SQLCODE=-134?

Products

• Aion Business Rules Expert

Issue/Introduction

SQLCODE -134,

Error:
IMPROPER USE OF LONG STRING COLUMN OR AN EXPRESSION OF MAXIMUM LENGTH GREATER THAN 255

Aion compile procedures convert Aion code into C code, and generates the DBRM of the program. DB2 Bind procedure gives SQLCODE=-134 error if string mode host-variables are defined without appropriate length because string mode is a just pointer for a string variable in the C language.

Windows IDE can run without the problem because Windows IDE runs Aion application dynamic SQL mode even "USE STATIC SQL" is checked.

 

 

Environment

Release: 10.2
Component: Aion-Business Rules-Advanced Builder Option

Resolution

Please specify an appropriate length for string variables when the query class property is defined with "USE STATIC SQL".