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.syscolumns WHERE tbname = 'local_table'" ); or my $sql=( "SELECT " . "name," . "tbname" . "from sysibm.syscolumns " . "where tbname = 'local_table'" ); It also needs to be in parens. Hth, Shaun --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.410 / Virus Database: 231 - Release Date: 31/10/2002 -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
