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 Bong Tumanut
. Jonathan Leffler [EMAIL PROTECTED] wrote: On Thu, Mar 6, 2008 at 8:25 PM, Bong Tumanut 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

RE: ORA-12154: TNS:could not resolve the connect identifier specified

2007-12-12 Thread Bong Tumanut
There's a file named tnsnames.ora file in $ORACLE_HOME/network/admin. Make sure there is an entry for $dbName there. Bong Loo, Peter # PHX [EMAIL PROTECTED] wrote: Here is what I did: eval { $dbh = DBI-connect(dbi:$dbDriver:$dbName, $dbUser, $dbPass, { RaiseError = 1, PrintError =

RE: Slow connection to Oracle 9i

2004-10-19 Thread Bong Tumanut
Commit is not to improve the performance of a single thread. It is to complete a transaction (i.e. set of SQL either is comitted or rolled back, no partial). Doing so also minimizes contention with other threads. Bong Tumanut DBA --- Reidy, Ron [EMAIL PROTECTED] wrote: Hmm... I strongly

Re: Perl import text file into DB2 database

2002-12-27 Thread Bong Tumanut
IMPORT is not a valid SQL statement. You need to execute it as an external (OS) command. --- Andy Nguyen [EMAIL PROTECTED] wrote: Hi I had a problem using Perl scripts to import text file into DB2 database. Could someone helps me to get over this problem. One of my projects I am