Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2004
    Location
    DELHI INDIA
    Posts
    338

    Unanswered: Load Tab separated file to Table

    Db2 V9.0 (on Linux)

    We need to load some tab-separated files received from sybase database to UDB tables. Can anyone help with the syntax for tab-separated.

    For "|" separated its: modified by COLDEL|

    Unable to find the same for TAB separated.

    Thanks

  2. #2
    Join Date
    Sep 2004
    Location
    Belgium
    Posts
    1,126
    Try using
    Code:
    modified by coldel0x09
    (Hex 09 is the ASCII tab character.)
    --_Peter Vanroose,
    __IBM Certified Database Administrator, DB2 9 for z/OS
    __IBM Certified Application Developer
    __ABIS Training and Consulting
    __http://www.abis.be/

Posting Permissions

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