Professional Web Applications Themes

SQL*Loader equivalent?? - IBM DB2

"Kenjis Kaan" <tivolinewbiecanada.com> wrote in message news:6a8ba9f8.0306271300.4f2de13dposting.google.c om... > Years ago, I was thrown a project working with Oracle and > Informix(Redbrick). We had a tool that allows us to upload a ton of > database records into a table by using just one text file. That's > right one single text file that contains some control instruction and > the rest of the file has the actual data to be loaded into the > database. Anyway, I recall we can just proceed to invoke a command > like SQLLOADER -blahblah bleh -blah bleh and it will load the entire ...

  1. #1

    Default Re: SQL*Loader equivalent??

    "Kenjis Kaan" <tivolinewbiecanada.com> wrote in message
    news:6a8ba9f8.0306271300.4f2de13dposting.google.c om...
    > Years ago, I was thrown a project working with Oracle and
    > Informix(Redbrick). We had a tool that allows us to upload a ton of
    > database records into a table by using just one text file. That's
    > right one single text file that contains some control instruction and
    > the rest of the file has the actual data to be loaded into the
    > database. Anyway, I recall we can just proceed to invoke a command
    > like SQLLOADER -blahblah bleh -blah bleh and it will load the entire
    > data into the database. I am just curious what the equivalent would
    > be for DB2
    > Universal Database Personal Edition Version 7(I think) currently
    > installed. I tried to do a search for sqlload* but it didn't find
    > anything on my machine. Need to find out fast, because the project
    > management people just changed the requirements and now I have to
    > upload data this way instead of doing a record by record "insert into
    > Table values(..." Some pointers and examples is appreciated TIA
    You need to start reading the manuals. You can get them at:
    www-3.ibm.com/cgi-bin/db2www/data/db2/udb/winos2unix/support/v7pubs.d2w/en_m
    ain
    (the above link may wrap on 2 lines)

    Check out the Command Reference Manuals for information about loading data.


    Mark A Guest

  2. #2

    Default Re: SQL*Loader equivalent??

    LOAD and IMPORT commands in particular...

    PM


    PM \(pm3iinc-nospam\) Guest

Similar Threads

  1. Using Loader Component
    By matt@frodis in forum Macromedia Flash Data Integration
    Replies: 0
    Last Post: September 28th, 02:02 PM
  2. Multiple swf loader
    By Nem123 in forum Macromedia Flash Sitedesign
    Replies: 2
    Last Post: February 14th, 02:39 PM
  3. pre loader
    By Matzola webforumsuser@macromedia.com in forum Macromedia Flash Actionscript
    Replies: 4
    Last Post: February 9th, 01:26 PM
  4. Looking 4 a LOADER.
    By BlueStar in forum Macromedia Flash
    Replies: 1
    Last Post: November 13th, 01:42 PM
  5. loader
    By edd1eg webforumsuser@macromedia.com in forum Macromedia Flash Sitedesign
    Replies: 4
    Last Post: July 9th, 10:41 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