Helen,

> Place this statement directly into DstStatement.
>
> >INSERT INTO OUTMESSAGES (DATETIME, SMSSOURCE, SMSNAME, SMSADDRESS,
> >SMSID, SMSREP,SMSDEST, CELLNO, CELLMSG, IPADDRESS) VALUES
> >(:DATETIME, :SMSSOURCE, :SMSNAME, :SMSADDRESS, :SMSID,
> :SMSREP, :SMSDEST, :CELLNO, :CELLMSG, :IPADDRESS)

You are correct in one respect but please understand there isn't a way you
can put raw SQL text into the TIB_DataPump.

The TIB_Datapump takes a pointer reference for the SrcStatement and
DstStatement. What may confuse you some is it will clone the statement
which makes it appear as if the data pump generates its own internal
statement. This is controlled through the CloneCursor property.

HTH,
Jason