Hi Shaunn,
> my $sql="SELECT
> name,
> tbname
> from sysibm.syscolumns
> where tbname = 'local_table';
--^
You forgot the closing double quotes.
You either need to have the query all on one line or concatenate it:
my $sql = ( "SELECT name, tbname FROM sysibm.syscolumn
Johnson, Shaunn said:
> 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_
> tes
