Datacom SQL -4 OVERFLOW

Products

• Datacom
• Datacom/AD
• Datacom/DB
• Datacom/Server
• Datacom/Server

Issue/Introduction

My Datacom Server application is getting -4 SQL return code

(-4 - OVERFLOW TYPE<x> ACTION<ASSIGNMENT/CONVERSION>).

How can I provide information to Support to help diagnose the problem?  

Environment

z/OS
WINDOWS 
LINUX

Resolution

For the SQL -4, turn on the following traces:

TRACEERR - Calls to MUF
TRACEEXPR - Expression and data type

See Datacom Core - 15.1 section COMM ALTER (Modify Error Table)
 
Scroll down in the section to “,TRACE=“  for the SQL trace class-name list of available traces for SQL situations.

Turn on traces.

Example DBUTLTY statements. Supply the Jobname to limit the tracing Datacom Server mainframe jobname

  COMM OPTION=ALTER,TRACE=TRACEERR,JOBNAME=jobname
  COMM OPTION=ALTER,TRACE=TRACEEXPR,JOBNAME=jobname

Recreate the -4 situation.

Turn off the traces:
   COMM OPTION=ALTER,TRACE=NONE

Provide Support with the trace outputs (PXXSQLnn SYSOUT) (or DBUTLTY REPORT AREA=PXX,DUMPS=TRACE report if not using SYSOUT).
 

 

Additional Information

For the details for SQL return codes, refer to Datacom Messages  section SQL Return Codes Quick Reference

Refer to Article 18269 - Using the SYSOUT Multi-User Facility Startup Option