Re: Input File name as one of the fields input for SQL*Loader

From: Arjan van Bentem <avbentem_at_DONT-YOU-DAREdds.nl>
Date: Wed, 19 Aug 1998 19:20:25 +0200
Message-ID: <6rf1f8$o4l$1@pascal.a2000.nl>

>Is there a way I can grab the name of the flat file into the table as
>one of the columns?

No, SQL*Loader does not support any parameter substitution at all.

At my work, we use a dummy text in the loader script, like __PARAM1. A simple Unix scripts makes a copy of the SQL*Loader script, in which __PARAM1 is replaced with the real value of that parameter, after which SQL*Loader is invoked. If you need such script, let me know.

Arjan. Received on Wed Aug 19 1998 - 12:20:25 CDT

This message: [ Message body ]
Next message: Mark R. Aughenbaugh: "MS Dev. Studio to Oracle?"
Previous message: petergangzhang_at_my-dejanews.com: "how to store special symbols into database"
In reply to: Omkar Vandara: "Input File name as one of the fields input for SQL*Loader"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US