get complete CLOB

From: RAYmond RICHard <RBTMEKRDQKDL_at_spammotel.com>
Date: 17 Nov 2003 03:27:58 -0800
Message-ID: <1daf4fc6.0311170327.15996ab2@posting.google.com>

Hello,

I'm trying to recive a CLOB-field with a batchscript:

set echo off
set feedback off
set heading off
set verify off

spool Mailtext.txt
select MAILBODY
from FT_CUSTOMERGROUPS
where CUSTOMERGROUP = '&1';
spool off
quit

But I only get the first vew lines of the whole text in it. Is there anything wrong with my statement? And if yes, how can I make it work?

Regards
RAY Received on Mon Nov 17 2003 - 05:27:58 CST