Results 1 to 2 of 2

Thread: newbie

  1. #1
    Join Date
    Sep 2006
    Posts
    6

    Unanswered: newbie

    hi,
    i just insatlled db2 on redhat linux. and created a sample database.
    Now i want to populate that database from a text sql file.
    Anybody help me which comand do that?
    database name is test and sql file is test.sql
    and also give me some reference about some tuts for basic stuff.

    thanks
    lhrt

  2. #2
    Join Date
    Jun 2006
    Posts
    471

    import

    import command is to be used
    all syntax/commands can be found at
    http://publib.boulder.ibm.com/infoce.../v8//index.jsp
    if the file is delimited use
    import from xxx.yy of del insert into tablename
    if file is positional, method L should be used with description of columns and positions in file.
    Best Regards, Guy Przytula
    DB2 UDB LUW certified V6/7/8

Posting Permissions

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