1 Reply Latest reply on Aug 9, 2019 4:48 PM by Howard Heiligmann

    How to configure Unload  when using CSV format and the column contents either the terminatedby and enclosedby character?

    Marcos Hashimoto
      Share This:

      Hi all,

       

      We are using BMC unload+ to retrieve some DB2 tables to send to Linux:

       

      UNLOAD UNLOADDN(SYSREC01) CNTLDDN(SYSCTL01) FIXEDVARCHAR YES

      SYNC 100000 SHRLEVEL CHANGE                                

      FORMAT CSV TERMINATEDBY '|'  ENCLOSEDBY '"' AND '"'       

      NULLSTRING ''                                              

      SELECT * FROM  Z00.UC_H_PASSAGEM_LOG

       

      The problem is there is a column that contains either the '|' and '"' character. When the unloaded file is trated by the apllication, it brokes because the application cannot distinguish what the column delimiter is or whether it is a content. Remembering that we cannot use different characters in enclosedby clause.

       

      Thank you!