Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2012
    Posts
    1

    Unanswered: data import from dbf file into db2 database

    i have dbf file with 80 lakh records.

    first i using insert query .but it will take time.instead that i want use load query.

    so give load query for import dbf file.

  2. #2
    Join Date
    Apr 2008
    Location
    Iasi, Romania
    Posts
    561
    Provided Answers: 2
    Try a search on Google with DB2 LOAD
    Florin Aparaschivei
    DB2 9.7, 10.5 on Windows
    Iasi, Romania

  3. #3
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    could you rephrase the question, because it is not very clear what your problem is, or what you want todo
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  4. #4
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    *.DBF files are in a format for dBase, which has nothing to do with IBM's DB2 database product. You cannot import data from a *.DBF file into DB2.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

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