Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2015
    Posts
    1

    Unanswered: Export db2 objects delimited by hexadecimals

    I am trying to export db2 tables delimited by hexadecimals

    The oracle control file format is

    Code:
      Unrecoverable load data characterset AL32UTF8 infile 
        '/mnt/MAZDA_DM/Build_DM_Dev/Datafile/SABARISH.dat' "STR X'083746303030303030080D0A'" append into table 
         fields terminated by X'07' optionally enclosed by X'08' 
        trailing nullcols()
    How to frame the `DB2 equivalent` query to delimit the data in the above control file delimited format in DB2?

  2. #2
    Join Date
    Jul 2013
    Location
    Moscow, Russia
    Posts
    666
    Provided Answers: 55
    Try this:

    $ db2 "export to 1.txt of del modified by coldel0x07 select current server, current timestamp from sysibm.sysdummy1"
    Regards,
    Mark.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •