Unpredictable errors in large IDMS table procedure request via IDMS Server

Products

• IDMS

Issue/Introduction

An SQL query selecting a large amount of data from an IDMS table procedure is failing but only when run through IDMS Server.

The same query works from OCF or IDMSBCF.  

Environment

Component: IDMS SQL, IDMS Server
Release: All supported releases.

Cause

The user written program implementing the table procedure is not coded to allow SUSPEND or RESUME calls.

Resolution

IDMS table procedures must be coded to consider it valid that the program has been invoked for a SUSPEND (op code 24) or RESUME (op code 28) operation. The code does not have to do anything on those op codes, but it needs to consider them as valid and not return an error.

An SQL query executed via IDMS Server that is returning a large amount of data is more likely to be invoked for SUSPEND/RESUME operations. This error will not happen when invoked via OCF or IDMSBCF.

The actual error messages returned can vary widely depending on how the program's error handling is coded. Typically it could be a specific value passed back in SQLSTATE or even TCP/IP-style communications errors.