Re: sqlloader Question
Date: 1995/05/18
Message-ID: <sarek.13.000A8CFA_at_cais.com>#1/1
You cannot extract certain columns from the data file. All columns must be loaded somewhere. Best thing to do is either load a temp table then drop it or load a temp table then create the actual tables with the column you would like.
Scott
In article <3pcvbl$mo4_at_cnn.MOTOWN.GE.COM> ttroccol_at_motown.ge.com (Ted M.
Troccola X4721) writes:>From: ttroccol_at_motown.ge.com (Ted M. Troccola X4721)
>Subject: sqlloader Question
>Date: 17 May 1995 13:57:09 GMT
>I am using sqlloader to get data from a data file.
>The data file has like 10 columns in it.
>I am loading four tables which use some, but NEVER all, of the
>columns in the datafile.
>So, I have to extract only these certain columns for certain tables.
>Can this be done?
> Load TABLE(emp, salary, age)
> with (column_1, column_3, column_7)
> from 'MY_10_COLUMN_DATA_FILE'
>Thanks in advance,
>Ted
Received on Thu May 18 1995 - 00:00:00 CEST