sybperl-l Archive

From: "Sabherwal, Balvinder (MBS)" <Balvinder dot Sabherwal at mortgagefamily dot com>
Subject: SQL failing
Date: Jul 14 2003 3:12PM

I have a script which connects to the Sybase database and create a work
table and has a check to see if the tables exists, drop it. The drop
statement is as below

$tblchk="if object_id(\"dbo.LatencyArch_staging\") is not null
begin
    drop table $opt_D\.\.$tbl
end
";



For some reason, the SQL gets executed and its not dropping the table. If I
print $tblchk from the debug mode and execute the generated sql from isql,
it works fine. What am I missing??

Thanks