SQL Loader...how to skip fields in data file
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: SQL Loader...how to skip fields in data file

  1. #1
    Join Date
    Dec 2002
    Posts
    32

    SQL Loader...how to skip fields in data file

    Hi

    I've a data file delimited by ~

    a~b~c~d~e

    and i'm loading the file into a table X with columns
    cola
    colb
    colc
    cole.
    Here I don't want to load the data d into my table. I want to skip the filed d of the data file and load data e into the column cole.
    Please suggest me , how to achieve this. I can't change the format of the datafile
    Thanks,
    Sajeev

  2. #2
    Join Date
    Apr 2001
    Location
    Louisville KY
    Posts
    295
    In your control file you can specify the locations of the field to be loaded. Just don't specify 'd'. It is easier in fixed format files than CSVs, but check the docs.
    Joseph R.P. Maloney, CSP,CDP,CCP
    'The answer is 42'

  3. #3
    Join Date
    Dec 2002
    Posts
    32
    Ican't specify the field position in control file. The table doen'thave any column like that. And its not a fixed length format..
    Sajeev

  4. #4
    Join Date
    Apr 2001
    Location
    Louisville KY
    Posts
    295
    Look at example 5-5 in the documentation (Using Filler Fields.)
    Joseph R.P. Maloney, CSP,CDP,CCP
    'The answer is 42'

  5. #5
    Join Date
    Dec 2002
    Posts
    32
    That's it.. It worked.
    Thanks
    Sajeev

Posting Permissions

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


Click Here to Expand Forum to Full Width