DB2 for AIX, inserting from aix file to lob column

Martin Flavell

DB2 for AIX, inserting from aix file to lob column
Hi All,
I have a table with 3 columns - keyvalue, pdf(blob 64k), html(blob 48k). I am being supplied with a set of aix files that contain the pdf and html data as binary, called keyvalue.pdf and keyvalue.html.
Do you know how I can get this data extracted and inserted into the table. I've tried putting the data into a variable and putting the variable into the insert statement, but I'm always told the parameter list is too long in aix.

Martin Flavell 

IBM Certified Solutions Expert -- DB2 V7.1 Database Administration for OS/390
Systems Support Specialist
Thesaurus Computer Services Ltd.
Technical Infrastructure and Professional Services

[login to unmask email]
Telephone:01908 246500.    Fax:01908 246555.    
WWW: www.i-tcs.com  

Thesaurus Computer Services (www.i-tcs.com)

This email is confidential and intended solely for the use of the
individual to whom it is addressed. Any views or opinions presented are
solely those of the author and do not necessarily represent those of
Thesaurus Computer Services. If you are not the intended recipient, be
advised that you have received this email in error and that any use,
dissemination, forwarding, printing, or copying of this email is
prohibited. If you have received this email in error please notify the
sender, or [login to unmask email], by e-mail or telephone +44 (0)1908-246500
Thesaurus Computer Services (www.i-tcs.com)
--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm