Howdy:

Can someone tell me why I keep getting the errors:
[snip error]
D:\PERL\BIN\MY_SCPTS>db2_test1.pl
syntax error at D:\PERL\BIN\MY_SCPTS\db2_test1.pl line 35, near "my"
Global symbol "$sth" requires explicit package name at
D:\PERL\BIN\MY_SCPTS\db2_
test1.pl line 35.
Global symbol "$sql" requires explicit package name at
D:\PERL\BIN\MY_SCPTS\db2_
test1.pl line 35.
Global symbol "$sth" requires explicit package name at
D:\PERL\BIN\MY_SCPTS\db2_
test1.pl line 43.
Execution of D:\PERL\BIN\MY_SCPTS\db2_test1.pl aborted due to compilation
errors
..
[/snip error]

I'm trying to write a script to connect to the DB2 / mainframe and I don't
really see *why* I'm having a problem.  

[script]

#!perl.exe

# created 05 Nov 2002 
# script to connect the NT machine to DB2/ OS/390
# mainframe via db2 module (have to run on NT box for now)

# may test this with DBI:DBD:DB2

use strict;
use DBI;
use DBD::DB2::Constants;
use DBD::DB2;

my $username="joeuser";
my $password="joepasswd";
my $outfile="d:\testout.txt";

my $dbh=DBI->connect("dbi:DB2:DB2DSNE", $username, $password)
        or die "Can not connect: $!";
if (!defined($dbh)) {exit;}

my $sql="SELECT
name,
tbname
from sysibm.syscolumns
where tbname = 'local_table';
; "

# test the sql and prepare to use
#

my $sth = $dbh->prepare($sql);

# generate a text file for mailing
# will have to expound upon
#

open OUTFILE, ">$outfile";
print OUTFILE "This is a test ...\n\n";
while (my @row = $sth->fetchrow) {
print OUTFILE "$row[0]\t$row[1]\n";
}

close OUTFILE;

$dbh->disconnect;

[/script]

Thanks!

-X

Reply via email to