Re: SQLLOAD restricts to 256 chars?

Samir,

One successful method that I've used is to break up the logical records into multiple lines. Look into the SQLLOAD keyword "continueif". Basically I had to preprocess my data file to have col1 contain the continuation character "$" and have the end of the long text string terminated by a hex character.

For example, using a continue char of $

 col1 col2 col3 col4
$col5-------------
$------------- hex char

 col1 col2 col3 col4
$col5------------
$----------------
$----------------
$------------- hex char

Cliff Received on Tue Sep 09 1997 - 00:00:00 CEST