e feedback.
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.
>
>
>
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 uploade
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, PrintEr
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:
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
I just did some testing. Your SQL is
SELECT ... IN 1 2 3
That's syntactically incorrect.
Bong Tumanut
DBA
--- "Ho, Tony" <[EMAIL PROTECTED]> wrote:
> Hi Bong
> That's correct.
> Tony
>
> -Original Message-
> From: Bong Tumanut [mailto:[EMAI
I'm a Perl newbie but are you generating the SQL such that it is
syntactically
SELECT... IN (1,2,3)
?
Bong Tumanut
DBA
--- "Ho, Tony" <[EMAIL PROTECTED]> wrote:
> Hi guys
> I was wondering if you could help me.
>
> In my Perl code, I declare an array, say @some_
