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.