IBM Support

How to fix error, "UT0016 An attempt to select a row from the control string DB2 table (EDICSTX) failed."

Troubleshooting


Problem

This case is for data transformation of EDI to XML. Example PERFORM command: PERFORM TRANSFORM WHERE INFILE(EDIIN) OUTFILE(XMLOUT) SYNTAX(E) FUNACKFILE(FUNACK) The following error is reported: Message: UT0016 Severity: 08 An attempt to select a row from the control string DB2 table (EDICSTX) failed. The SQL code was 100, the control string name was 837, the control string type was STD, and the sequence number was 1. **** File: EDI.TE51INT.PREPC(EDIUPCSD) Line: 341 Func: LoadCs(char**,char*,char*,long,bool)

Cause

WDI is unable to determine what EDI standard control string to use.

Resolving The Problem

Add the EDI standard version/release value as it appears in the input to the EDI2DICT forward translate table. The version/release as taken from either; GS08 for X12 or UNH0203 for EDIFACT.

For example:


Add "93A" to the EDI2DICT forward translation table:



Alternatively, add DICTIONARY(EDI93A) to the PERFORM statement. However, this is not as flexible since all input messages then must be for the same EDI standard dictionary.

[{"Product":{"code":"SSFKTZ","label":"WebSphere Data Interchange"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"WDI 3.2 for z\/OS","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF025","label":"Platform Independent"},{"code":"PF033","label":"Windows"},{"code":"PF035","label":"z\/OS"}],"Version":"3.2;3.2.1;3.3","Edition":"All Editions","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Document Information

Modified date:
01 August 2018

UID

swg21232428

Page Feedback