Skip to Content
avatar image
Former Member

Replication Agent and selecting field names with special characters from Oracle PDS

Hello All,

I have SAP Replication Server SP200 set up and working from Oracle to HANA. I'm creating a subscription with the direct_load option on the SAP table MARA. This is failing at the "SELECT" stage with the Oracle error "ORA-00936: missing expression". This is because the MARA table contains a few fields that begin with a forward slash e.g. /BEV1/LULEIHN. In order for this to work each field name needs to be enclosed in double quotes ("/BEV1/LULEIHN"). Does anybody know if there is an option in Replication Server to make it use double quotes in select statements?

If not I'll end up creating views for all the tables containing special characters.

Thanks

Matt

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Jun 29, 2015 at 08:45 AM

    Hello All,

    I've had a reply about this from SAP after logging a support call. There is a configuration parameter called dsi_quoted_identifier the has to be set to 'on' in the connection to the primary db. It seems that you then subscribe using the quoted key word to the table concerned.

    Once I have the exact syntax worked out and I've managed to replicate a table with special characters successfully I'll post here what worked for me.

    Thanks

    Matt

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hello,

      I've now got this working but setting the dsi_quoted_identifier to "always" when creating both primary and replicate connections. The syntax I used was as follows:


      create connection to pds.pdb

      using profile <profile_name>

      set username <username>

      set password <password>

      set dsi_quoted_identifier to "always"

      go

      Thanks

      Matt