Re: sqlloader Question
Date: 1995/05/18
Message-ID: <jalford.50.002E048D_at_immcms1.redstone.army.mil>#1/1
In article <sarek.13.000A8CFA_at_cais.com> sarek_at_cais.com (Scott T. Johnson) writes:
>From: sarek_at_cais.com (Scott T. Johnson)
>Subject: Re: sqlloader Question
>Date: Thu, 18 May 1995 07:15:05 EST
>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
If the data is fixed width, you can then extract only the columns you need by defining fields in the sqloader control file. The case refered to, does not state whether or not the data is comma or space delimited ! my .02
>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