Results 1 to 5 of 5
  1. #1
    Join Date
    Sep 2003
    Location
    Texas
    Posts
    5

    Unanswered: DB2 Load utility

    Hi,

    I'm trying to load a delimited file into a table using DB2 load utility.

    Is it possible to filter records based on the column values.

    If it can be done please provide me with the syntax or links to some website where i can find the help.

    Thanks somuch for your reply
    Siddartha

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: DB2 Load utility

    I do not understand what 'filter records' means ...

    But, in any case, you will have to load all records from the file into a table ...

    Cheers

    Sathyaram

    Originally posted by hemanth07
    Hi,

    I'm trying to load a delimited file into a table using DB2 load utility.

    Is it possible to filter records based on the column values.

    If it can be done please provide me with the syntax or links to some website where i can find the help.

    Thanks somuch for your reply
    Siddartha
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    Sep 2003
    Location
    Texas
    Posts
    5

    Re: DB2 Load utility

    I'll try to explain with the sample data file.

    Below is the sample data file.

    A,1,10
    A,2,20
    A,3,20
    B,3,10
    A,3,10

    by using the db2 Load utility, is it possible to load only the "A" records from the above flat file sample , this is possible in Oracle SQL*Loader

    Thanks
    Sid

  4. #4
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    There is a feature to do this on the Load Utility for DB2 390 (using the WHEN clause) but I don't believe it exists on the other platforms.

  5. #5
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Originally posted by Marcus_A
    There is a feature to do this on the Load Utility for DB2 390 (using the WHEN clause) but I don't believe it exists on the other platforms.
    As a workaround, I think you could create a check constraint on the table that would reject records that you don't want to load.

    Nick
    ---
    "It does not work" is not a valid problem statement.

Posting Permissions

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