Re: SQL*Loader 256 Char Delimited Field

From: Matt Southcott <matts_at_nifcosynergy.com>
Date: 1997/06/24
Message-ID: <33b0071e.74006685@news.bctel.net>#1/1

On Tue, 17 Jun 1997 18:20:55 -0500, Rob Peters <rpeters_at_cdc.com> wrote:

>Anyone know how to set up a delimited field that is
>greater than 256 characters?
>
>Thanks
>Rob
>rpeters_at_cdc.com

This is some info on the same problem that I had I left the Sig file of the owner so he gets the credit for the solution...

After John Caputo send me a mail I checked again and found out that delimited text fields, larger than 255 bytes, can indeed be processed by SQL*Loader. The manual says "The *default* maximum length of delinited data is 255 bytes". So, this is a DEFAULT, not an ABSOLUTE maximum length!

To specify a larger maximum length, you have to to specify the field as type CHAR (VARCHAR fields can't be delimeted) with specified maximum length in your control file, e.g.:

LOAD DATA ......
INTO TABLE my_table ....
FIELDS TERMINATED BY '[delimiter]'
(first_column, large_column CHAR(900), ......)

Regards,

Jurij Modic                             Republic of Slovenia
tel: +386 61 178 55 14                  Ministry of Finance
fax: +386 61  21 45 84                  Zupanciceva 3

e-mail: jurij.modic_at_mf.sigov.mail.si Ljubljana 1000

Received on Tue Jun 24 1997 - 00:00:00 CDT