PEPPLER.ORG
Michael Peppler
Sybase Consulting
Menu
Home
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
Freeware
Sybperl
Sybase::Simple
DBD::Sybase
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
FAQs
Sybase on Linux FAQ
Sybperl FAQ
Personal
Michael Peppler's resume

sybperl-l Archive

Up    Prev    Next    

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