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_ > test1.pl line 35.
Looks like you need a semicolon on the end of the previous statement. > my $sql="SELECT > name, > tbname > from sysibm.syscolumns > where tbname = 'local_table'; > ; " Here. > # test the sql and prepare to use > # > > my $sth = $dbh->prepare($sql); -- Paul Johnson - [EMAIL PROTECTED] http://www.pjcj.net -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
