1853857 - How to replicate tables containing column names that are also sql keywords - SRS | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

1853857 - How to replicate tables containing column names that are also sql keywords - SRS

Symptom

  • How to replicate tables containing column names that are reseved words or contain space?
  • A column name with reseved word "insert" raised the following error.

    Last command to 'dsname.testdb':
    Output command: insert into t1 (col1, col2, key) values (1, 'string1', 'string2')
    ERROR #1028 DSI EXEC(109(1) dsname.testdb) - dsiqmint.c(4445)
            Message from server: Message: 156, State 2, Severity 15 -- 'Incorrect syntax near the keyword 'key'.
    THREAD FATAL ERROR #5049 DSI EXEC(109(1) dsname.testdb) - dsiqmint.c(4458)

     
  • A column name with space. For example: "TAX RATE", raised the following error.

    ERROR #1028 DSI EXEC(104(1) dsname.testdb) - neric/dsi/dsiqmint.c(5095)
        Message from server: Message: 102, State 181, Severity 15 -- 'Incorrect syntax near 'RATE'.'.
    THREAD FATAL ERROR #5049 DSI EXEC(104(1) dsname.testdb) - neric/dsi/dsiqmint.c(5108)
    The DSI thread for database 'dsname.testdb' is being shutdown. DSI received data server error #102 which is mapped to STOP_REPLICATION. See logged data server errors for more information. The data server error was caused by output command #1 mapped from input command #2 of the failed transaction.

Read more...

Environment

SAP Replication Server (SRS)

Product

SAP Replication Server 15.7

Keywords

repserver, sybase, dsi_quoted_identifier, repdef, "replication definition", quoted, identifiers , KBA , BC-SYB-REP , Sybase Replication Server (standalone) , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.