DB006001 Unrecognizable token trying to create a table procedure

Products

• IDMS
• IDMS - Database

Issue/Introduction

Getting the following error:

CREATE TABLE PROCEDURE EMPSQL.TPUPDO9
(
EMP_XDT_YY UNSIGNED NUMERIC(2),
EMP_XDT_MM UNSIGNED NUMERIC(2),
EMP_XDT_DD UNSIGNED NUMERIC(2),
EMP_STATUS_CODE CHAR(1),
309_EMPEDT_CC UNSIGNED NUMERIC(2),
309_EMPEDT_YY UNSIGNED NUMERIC(2),
309_EMPEDT_MM UNSIGNED NUMERIC(2),
309_EMPEDT_DD UNSIGNED NUMERIC(2),
320_EMPEDT_REASON CHAR(1)
)
EXTERNAL NAME TPUPDO9
DEFAULT DATABASE NULL
USER MODE
LOCAL WORK AREA 1024
GLOBAL WORK AREA 2048
++
Status = -4 SQLSTATE = 42600 Messages follow:
Syntax error in line 25 at column 10, token = 309_EMPEDT_CC
DB006001 T1144 C-4M330: Unrecognizable token

Environment

Release: All supported releases.
Component: SQL Option.

Cause

The identifiers cannot start with a numeric.

Resolution

Started column with alphanumeric and the error was resolved.