Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2003
    Posts
    9

    Red face Unanswered: Flat File To Table In Db2 - Control Center

    Hello...

    Im new in DB2 and i having problems with control center...

    I cant do the load processo about flat file into DB2 tables...
    HHelp... I someone could help me i houd be very gratefully...

    I somesome have a manual i hould be very gratefully to...


    Kind Regards,
    LULU

  2. #2
    Join Date
    Jan 2003
    Location
    Zutphen,Netherlands
    Posts
    256
    If you tell us were you are stranding we may be able to offer you some guidance. Using control center is all gui, so should be relatively painless. If you have a small dataset I would advice using the import gui, this way you have to specify even less parameters to import your data into the table..............
    Ties Blom
    Senior Application Developer BI
    Getronics Healthcare
    DB2,ORACLE,Powercenter,BusObj,Access,
    SQL, SQL server

  3. #3
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    You need to know how your flat file is delimited to identify where the columns start and end. Then make sure you select the right delimiter option in the GUI for the load.

    It might help to tell us what error you are getting or what your input file and table looks like.

    If you want to use the load command, refer to the Command Reference manual. DB2 Manuals can be found at:
    http://www-3.ibm.com/cgi-bin/db2www/...bs.d2w/en_main

Posting Permissions

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