Skip to main content

XDBUTILB DECIMAL External not supported

  • December 21, 2021
  • 0 replies
  • 0 views

Microfocus Enterprise Developer VS 2019.

Trying to load from Mainframe converted files (in ASCII) into XDB. The load statement is as follows. 

LOAD DATA INDDN SYSREC LOG NO ENFORCE NO RESUME YES
ASCII
INTO TABLE <Table Name>
( KLIM_KEY_RCOMPAKY
POSITION( 00001:00026) CHAR(00026)
, COMPLI_REMARKS
POSITION( 00027:00046) CHAR(00020)
, COMPLI_AIA_INDC
POSITION( 00047:00047) CHAR(00001)
, COMPLI_DOL
POSITION( 00048:00066) DECIMAL EXTERNAL (00019,00000)
, COMPLI_DLA
POSITION( 00067:00085) DECIMAL EXTERNAL (00019,00000)
, SKCOMPLI_FILLER_1
POSITION( 00086:00098) CHAR(00013)
, SMASTER_KLIM_KEY_MSTRNO
POSITION( 00099:00103) CHAR(00005)
, SEQ_COMPLI_AGENCY
POSITION( 00104:00108) CHAR(00005)
, SEQ_COMPLI_NO
POSITION( 00109:00128) CHAR(00020)
, SEQ_COMPLI_CAT
POSITION( 00129:00129) CHAR(00001)
, KLIM_KEY_RCOMPLKY
POSITION( 00130:00154) CHAR(00025)
)

I am getting the error. 

DSNU000I DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = XDBUTILB
Option DECIMAL EXTERNAL is not supported
DSNU012I DSNUGBAC - UTILITY EXECUTION TERMINATED, HIGHEST RETURN CODE=8
The decimal format is defined in XDB as (-zzzzzzzzz,zz9.99) with Float Decimal places as 2. 

#EnterpriseDeveloper