Reason for a B097 LENGTH INVALID FOR TYPE - B

Products

• Easytrieve Report Generator
• PAN/SQL

Issue/Introduction

Easytrieve compile error:

 B097 LENGTH INVALID FOR TYPE - B

How may this be resolved?

 

Environment

Easytrieve 11.6-C compatibility mode.

Resolution

The problem is in your Easytrieve source code of; 

13 * WORKING STORAGE * 

14 **************************************** 

15 WS-PID W 10 A 

16 WS-NAME W 128 A 

17 WS-DB2-GENERATED-DOCID-FOR-XML W 8 B 0 

17 *******B097 LENGTH INVALID FOR TYPE - B . 

 

Since you are running in compatibility mode; 

1 3/09/17 11.33.46 EASYTRIEVE PLUS 11.6-C SP0 <======11.6-C is compatibility mode 

the following is applicable; 

On page 3-9 of the User Guide for release 6.4, it states that the maximum 

length for a binary field is 4 bytes: 

 

 

Additional Information

If you were running in true 11.6 new functionally mode with special PTF's, then you would be able to use the DB2 function of BIGINT.