DB006001 T1144 C-4M330: Unrecognizable token when trying to create a table procedure
search cancel

DB006001 T1144 C-4M330: Unrecognizable token when trying to create a table procedure

book

Article ID: 32804

calendar_today

Updated On:

Products

IDMS IDMS - Database IDMS - ADS

Issue/Introduction

PROBLEM:

I've coded up a table procedure, and provided the list of variables defined in the USING statement of the external program generated by QuickBridge, removing the -D suffix, removing all the -I indicators, and substituting underscores (_) for hyphens (-). 
Now I'm getting the message: DB006001 Unrecognizable token 
It seems to be OK with the parameter list until it gets to the ones prefixed with the RECORDID number. 
Here's the output: 
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

CAUSE:

The identifiers cannot start with a numeric.

 

RESOLUTION:

 

Started column with alphanumeric and the error was resolved.

Environment

Release: IDADSO00100-18.5-ADS-for CA-IDMS
Component: