Need some insight and help from the gurus. To set the knowledge
foundation - I know nothing about stored procedures, blobs, and
sybase. I have a Lotus Notes application that has captured information
and PDF attachments. I want to populate a Sybase database (ver 11.5)
with what is in Lotus Notes. I have been told that "Stored Procedures"
could transfer the data, but not the PDF file.

Is this true? If so, is there a workaround for this?

Thanks for all your help.
Franklin

On Wed, 12 Nov 2003 07:54:14 -0800, Frank wrote:

> Need some insight and help from the gurus. To set the knowledge foundation
> - I know nothing about stored procedures, blobs, and sybase. I have a
> Lotus Notes application that has captured information and PDF attachments.
> I want to populate a Sybase database (ver 11.5) with what is in Lotus
> Notes. I have been told that "Stored Procedures" could transfer the data,
> but not the PDF file.

That is correct - you can't pass TEXT or IMAGE parameters to stored
procedures. There are a few other methods, but they depend on the
underlying API, and I have no idea what API Lotus Notes uses.

Michael
--
Michael Peppler Data Migrations, Inc.
mpeppler@peppler.org http://www.mbay.net/~mpeppler
Sybase T-SQL/OpenClient/OpenServer/C/Perl developer available for short or
long term contract positions - http://www.mbay.net/~mpeppler/resume.html