Re: Sqlload; can I do math during the upload?

From: Alex Filonov <afilonov_at_yahoo.com>
Date: 16 Jul 2002 13:48:17 -0700
Message-ID: <336da121.0207161248.6375932d_at_posting.google.com>


"David Van Zandt" <dvanzandt_at_iquest.net> wrote in message news:<mMYX8.71$P6.15401_at_news.iquest.net>...
> I need to start with an Excel-generated CSV file, multiply an input column
> variable by a constant, and out-put only five out of perhaps twenty source
> columns. For example, the table would be an extract of columns 3,6,4, the
> string "xyz", and column 5 * 85%.

This is quite easy, it all described in sqlloader examples in documentation. Just look how to create calculated columns.

>
> While reading the same input record, I need a second row created but with
> string "zyx" and column 10 * .123.

Can be done with loader too, also can be done using insert into <you table> as select from <your table>.

>
> Then they want the results saved back in Excel, but that's the easy part.
>

By the way, if output is important, you can load everything into table as is, then do all calculations needed in output (in select statement). It might be much easier.

> I'd appreciate any suggestions: this one's a tad harder than the manual's
> examples. TIA.
Received on Tue Jul 16 2002 - 22:48:17 CEST

Original text of this message