TIBCO Service Gateway™ for IDMS/DB (R5.0):Issue 1: Unable to support fields with a syntax of CHARACTER (‘C’) and length greater than 127 bytesIssue 2: Conversion Error using fields with a syntax of PACKED (‘P’)

TIBCO Service Gateway™ for IDMS/DB (R5.0):Issue 1: Unable to support fields with a syntax of CHARACTER (‘C’) and length greater than 127 bytesIssue 2: Conversion Error using fields with a syntax of PACKED (‘P’)

book

Article ID: KB0085783

calendar_today

Updated On:

Products Versions
TIBCO Service Gateway for IDMS/DB -
Not Applicable -

Description

Resolution:
Issue 1:
Defining a field with a syntax of CHARACTER (‘C’) and a length greater than 127 results in the field not being initialised to the length required.
This is resolved by AP13232, however this fix introduced a further problem as detailed in Issue 2 below.  

Issue 2:
When writing an occurrence to an IDMS table containing fields with a syntax of PACKED (‘P’), a Conversion Error may be received if the PACKED field is not explicitly initialised.

S6BID038E IDMSCV8 CV8A01 IDMSETOF: CONVERSION ERROR on field nnnnnnnn:   CONVERTI return code non-zero

This is resolved by AP13249  

Both AP13232 & AP13249 will be packaged within OSB 5.0 IDMS hotifx 2.
If you require these fixes before availability of this hotfix is announced, please open a Service Request (SR) with Tibco Support.

Issue/Introduction

TIBCO Service Gateway™ for IDMS/DB (R5.0):Issue 1: Unable to support fields with a syntax of CHARACTER (‘C’) and length greater than 127 bytesIssue 2: Conversion Error using fields with a syntax of PACKED (‘P’)