1 Reply Latest reply: May 31, 2012 10:00 AM by uleblga RSS

    Apostrophes (single quote) are lost when generating DDL code.

    uleblga
      Hi,

      ODI Version : 11.1.1.5.0
      Java version : 1.6.0_24
      Database version : Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production

      Context: Generating DDL code for a an ODI Model

      PROBLEMATIC: When generating DDL code, all apostrophes (single quote: ') are removed from Datastore Descriptions and Datastore Colunms Descriptions in the process of generating Comments on Tables and Comments on Tables Columns. I tried to double, even triple apostrophes (in descriptions), without success. I also tried double quotes (") without success either.

      Ex: Datastore Column Description: *+ID de l'utilisateur+* becomes *+comment on table ... is 'ID de l utilisateur'+* in generated procedure.

      Do you know a way to keep the apostrophes when creating Comments on Columns and Oracle Tables by generating DDL code ?

      Regards,

      Gaston

      Edited by: uleblga on 23-May-2012 3:42 PM

      Edited by: uleblga on 23-May-2012 3:42 PM