Professional Web Applications Themes

Db2 Load using tab as delimeter - IBM DB2

I'm trying to load a file into a DB2 table using the load utility The file was generated by a 3rd party tool and the fields are seperated by tab. How do I define a tab "coldel" as the delimeter in my input file. -- Posted via [url]http://dbforums.com[/url]...

  1. #1

    Default Db2 Load using tab as delimeter


    I'm trying to load a file into a DB2 table using the load utility
    The file was generated by a 3rd party tool and the fields are
    seperated by tab.

    How do I define a tab "coldel" as the delimeter in my input file.

    --
    Posted via [url]http://dbforums.com[/url]
    riaanv Guest

  2. #2

    Default Re: Db2 Load using tab as delimeter

    riaanv <member33042dbforums.com> wrote:
    >
    > I'm trying to load a file into a DB2 table using the load utility
    > The file was generated by a 3rd party tool and the fields are
    > seperated by tab.
    >
    > How do I define a tab "coldel" as the delimeter in my input file.
    The "coldel" modifier is a single character, and you can specify the
    character code point (see footnotes "b" and "c" in the Command Reference,
    "LOAD" command):

    ... modified by coldel# ...
    ... modified by coldel0x23 ...
    ... modified by coldelX23 ...

    So in your case, you just use code point 0x09:

    ... wodified by coldel0x09

    --
    Knut Stolze
    Information Integration
    IBM Germany / University of Jena
    Knut Stolze Guest

Similar Threads

  1. How can I load load Additional extensions ?
    By Dennis Lee in forum PHP Development
    Replies: 9
    Last Post: May 18th, 03:42 AM
  2. load php
    By Ulitasch in forum Macromedia Flash Data Integration
    Replies: 2
    Last Post: April 29th, 11:48 AM
  3. RE-load mp3
    By joao bana in forum Macromedia Flash
    Replies: 0
    Last Post: December 10th, 01:56 AM
  4. Replies: 0
    Last Post: October 2nd, 09:08 PM
  5. load of ram
    By Karen in forum AIX
    Replies: 0
    Last Post: July 3rd, 10:05 AM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139