Passing Parameters to SQLLDR control file
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Passing Parameters to SQLLDR control file

  1. #1
    Join Date
    Apr 2001
    Posts
    4
    Hi,
    Does anybody know of a way of passing parameters (variables) to a SQLLDR control file?

    We will be using SQLLDR to load several sets of tables, and need to load a different identifying code with each row in each table for each set of data.

    The only way of achieving this seems to be to manually edit each .ctl file and set the DataSet identifier as a CONSTANT for each set of data.

    Any help much appreciated.

    E
    Thanks in Advance for your help

  2. #2
    Join Date
    Jan 2001
    Posts
    515

    Try this link

    http://www.onwe.co.za/frank/faqloadr.htm#MODIFY

    you can specify a different load for each table all in one file.

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