CREATE TABLE Failed. 3707

Database
Visitor

CREATE TABLE Failed. 3707

Hello Team,

 

I am trying to create below table:

 

SyntaxEditor Code Snippet

CREATE TABLE MaestroAbpLndTbls.SUBSCRIBER(SUBSCRIBER_NO NUMBER(9,0) NOT NULL,
        SYS_CREATION_DATE DATE NOT NULL,
        SYS_UPDATE_DATE DATE,
        OPERATOR_ID NUMBER(9,0),
        APPLICATION_ID CHAR(6),
        DL_SERVICE_CODE CHAR(5),
        DL_UPDATE_STAMP NUMBER(4,0),
        SUB_SEQ_NO NUMBER(9,0),
        EXTERNAL_ID VARCHAR(100),
        CUSTOMER_ID NUMBER(9,0) NOT NULL,
        CH_NODE_ID NUMBER(9,0),
        EFFECTIVE_DATE DATE,
        EXPIRATION_DATE DATE,
        INIT_ACT_DATE DATE,
        SUB_STATUS CHAR(1),
        SUB_STATUS_DATE DATE,
        SUB_STS_ISSUE_DATE DATE,
        SUB_STS_LAST_ACT VARCHAR(25),
        SUB_STS_RSN_CD VARCHAR(6),
        DEALER_CODE CHAR(8),
        INITIAL_DLR_CODE CHAR(8),
        SUBSCRIBER_TYPE VARCHAR(4),
        SUB_PASSWORD VARCHAR(15),
        PRIM_RESOURCE_TP VARCHAR(4),
        PRIM_RESOURCE_VAL VARCHAR(200),
        PRIM_RES_PARAM_CD VARCHAR(255),
        CALC_PYM_CATEGORY VARCHAR(4),
        INS_TRX_ID NUMBER(9,0),
        TRX_ID NUMBER(9,0),
        CONV_RUN_NO NUMBER(3,0),
        BUSINESS_ENTITY_ID NUMBER(9,0),
        LANGUAGE VARCHAR(5),
        LINK_PREV_SUB_NO NUMBER(9,0),
        LINK_NEXT_SUB_NO NUMBER(9,0),
        ORIG_ACT_DATE DATE,
        ROUTING_POLICY_ID NUMBER(9,0),
        REQUIRED_PARTITION CHAR(1),
        L9_SAM_KEY VARCHAR(13),
        L9_SUBSCRIBER_SUB_TYPE CHAR(1),
        L9_EQUIP_SUM NUMBER(9,0),
        L9_FRAUD_INDICATOR CHAR(1),
        L9_FRAUD_SUS_IND CHAR(1),
        L9_SUS_HISTORY VARCHAR(64),
        L9_ANGLER_IND CHAR(1))
    UNIQUE PRIMARY INDEX (SUBSCRIBER_NO);

It is throwing below error:

CREATE TABLE Failed. 3707:  Syntax error, expected something like an 'UDFCALLNAME' keyword between '.' and the 'SUBSCRIBER' keyword. 

Please advise.

Thank you for your help in advance.

Regards,
Amol
Tags (1)

Accepted Solutions
Teradata Employee

Re: CREATE TABLE Failed. 3707

Subscriber is a SQL restricted word. It can be used if quoted. 

 

See appendix B of the SQL fundamentals reference for details on how to find these words:

 

sel * from syslib.sqlrestrictedwords where restricted_word = 'subscriber';

 *** Query completed. One row found. 3 columns returned.
 *** Total elapsed time was 1 second.

restricted_word                 category  ANSI_restricted
------------------------------  --------  ---------------
SUBSCRIBER                      R         T

1 ACCEPTED SOLUTION
1 REPLY
Teradata Employee

Re: CREATE TABLE Failed. 3707

Subscriber is a SQL restricted word. It can be used if quoted. 

 

See appendix B of the SQL fundamentals reference for details on how to find these words:

 

sel * from syslib.sqlrestrictedwords where restricted_word = 'subscriber';

 *** Query completed. One row found. 3 columns returned.
 *** Total elapsed time was 1 second.

restricted_word                 category  ANSI_restricted
------------------------------  --------  ---------------
SUBSCRIBER                      R         T