Re: Help with Long Column Problem

Hi Roger,

If you are willing to examine 3rd party software, you should examine DataMirror's Transformation Server. DataMirror Transformation Server is a high-performance peer-to-peer data integration tool that enables you to replicate your data across multiple platforms. That said, Transformation Server natively supports DB2 UDB on OS/390 (among other databases/platforms including Oracle, SQL Server, Sybase on OS/390, UNIX, Linux, AS/400, NT ...). DataMirror Transformation Server received top-honours in a ranking by Meta Group (Spex Research) a while back for ETL. More product information is available on our web-site (http://www.datamirror.com).

Hope this helps
Amy Stearns

gamebuddah_at_hotmail.com (Roger Carden) wrote in message news:<fbd13bc3.0108070638.2e36f0dd_at_posting.google.com>...
> Hello Everyone,
>
> I'm trying to move data between two databases and one of the columns
> that needs to be moved is a long. Currently I have a cursor which
> selects all the values from the remote database table (including the
> long column), runs through the lst, and inserts the data into the
> local database. This works fine if the value of the long column is
> under 32760 bytes.
>
> However, one of the rows in the remote database has a column which is
> currently over 45000 bytes! When I include this row in my cursor, the
> procedure bombs, however when I exclude it, the procedure moves all
> the other data.
>
> First: Is there anyway to move this data from within PL/SQL? (I am
> aware that I may be able to use the COPY command from SQL/PLUS but
> this will not meet the requirements that I have for this job.)
>
> Second: If there isn't a way to move it, is there a way to check the
> length of Long columns and exclude any over 32760 from my cursor?
>
> Any help would be greatly appreciated.
>
> Thanks,
> Roger Carden
> gamebuddah_at_hotmail.com
Received on Wed Aug 22 2001 - 15:21:42 CEST