Inserting LOB into DB2 in pieces

2008-03-06 Thread Bong Tumanut
I'm writing an Apache::ASP program to upload a file and store it in a LOB column in DB2. Is there a way to store the uploaded file in pieces, i.e. while(read($filehandle, $data, 1024)) { # data from the uploaded file read into $data # load all $data into a LOB column }; I know the

Re: Inserting LOB into DB2 in pieces

2008-03-06 Thread Jonathan Leffler
On Thu, Mar 6, 2008 at 8:25 PM, Bong Tumanut [EMAIL PROTECTED] wrote: I'm writing an Apache::ASP program to upload a file and store it in a LOB column in DB2. Is there a way to store the uploaded file in pieces, i.e. while(read($filehandle, $data, 1024)) { # data from the uploaded file

Re: Inserting LOB into DB2 in pieces

2008-03-06 Thread Bong Tumanut
No, I didn't mean to imply that the web user's file has already been uploaded and saved in a file on the Apache server. Good point about the multiple trips between the Apache server and the DBMS. Although the 1024 was arbitrary, I could have made that bigger like 32K. Thanks for the feedback.