B204 SQL - SQL ERROR, SQLCODE IS -302

Products

• Easytrieve Report Generator
• PAN/SQL

Issue/Introduction

B204 SQL - SQL ERROR, SQLCODE IS -302                                     

B204 SQL - DSNT408I SQLCODE = -302, ERROR:  THE VALUE OF INPUT VARIABLE OR

B204 SQL -          INVALID OR TOO LARGE FOR THE TARGET COLUMN OR THE TARGE

B204 SQL - DSNT418I SQLSTATE   = 22001 SQLSTATE RETURN CODE               

B204 SQL - SQL ERRORS FOUND                                               

A014 PREMATURE TERMINATION DUE TO PREVIOUS ERROR(S) 

Environment

Easytrieve Plus Report Generator, release 6.4
Pan/SQL 2.4C (0203)

Cause

The SQL statement in an Easytrieve program is greater then the MAXSTLEN.

You can see these in the CAIMAC(OMSMCMD2) macro member. 

 

Resolution

Increase MAXSTLEN parameter in the DQSMCMD macro. We generally suggest that you change the MAXSTLEN to a number slightly larger then the largest statement and rerun IJ3STGE1 member to pick up the changes to the DQSMCMD macro. Then run CB2ACMDL to relink the related macro. 

You can see these in the CAIMAC(OMSMCMD2) macro member.

************************ Top of Data *

DQSMCMD MAXSTMT=30,

MAXCUR=10,

VWOWNR=xxxxx,

PLAN=xxxxx,,

DB2REL=091,

MAXGRP=1,

HLDCUR=03,

MAXSTLEN=8189 

END