CA Easytrieve error EZTC0506E >>> $ decimals must be 0 for SQL

Products

• Easytrieve Report Generator
• PAN/SQL

Issue/Introduction

           586  SQL DECLARE C2 CURSOR FOR +                  
           587     SELECT A.WB_DATA +                        
           588     FROM DWBWAYBL.WB_SV_VERS A +              
           589     WHERE A.SER = :SV_SER AND +               
           590        A.VERS = :SV_VERS AND +                
 EZTC0506E >>>                  $ decimals must be 0 for SQL 

          

Environment

Release : 11.6

Component : CA-Pan/SQL (DB2 Interface)

Resolution

Change program to use the host variables from the INCLUDE, instead of using a Storage Field.

SQL INCLUDE LOCATION W FROM DWBWAYBL.WB_SV_VERS