Every Statement is a prepared stored proc?
[email protected] Wed, 8 Oct 2008 17:52:24 -0400
| Newsgroups | gmane.comp.lang.perl.modules.dbi.sybase |
|---|---|
| Message-ID | <OF665E79EC.6389C0AB-ON852574DC.0077A9A6-852574DC.00782754@evergreeninvestments.com> |
<br><font size=2 face="sans-serif">How do we avoid this problem?</font>
<br><font size=2 face="sans-serif">Would using DBI{finish} cause this?</font>
<br>
<br>
<br><font size=2 face="sans-serif">create proc DBD17 as SELECT mycolumn
AS mycolumn FROM my2ndtable WHERE id = ?</font>
<br><font size=2 face="sans-serif">create proc DBD18 as UPDATE my2ndtable
SET mycolumn = ? WHERE id = ?</font>
<br><font size=2 face="sans-serif">create proc DBD19 as SELECT mycolumn
AS mycolumn FROM my2ndtable WHERE id = ?</font>
<br><font size=2 face="sans-serif">create proc DBD20 as UPDATE my2ndtable
SET mycolumn = ? WHERE id = ?</font>
<br><font size=2 face="sans-serif">create proc DBD21 as SELECT mycolumn
AS mycolumn FROM my2ndtable WHERE id = ?</font>
<br><font size=2 face="sans-serif">create proc DBD22 as UPDATE my2ndtable
SET mycolumn = ? WHERE id = ?</font>
<br><font size=2 face="sans-serif">create proc DBD23 as SELECT mycolumn
AS mycolumn FROM my2ndtable WHERE id = ?</font>
<br><font size=2 face="sans-serif">create proc DBD24 as UPDATE my2ndtable
SET mycolumn = ? WHERE id = ?</font>
<br><font size=2 face="sans-serif">create proc DBD25 as SELECT mycolumn
AS mycolumn FROM my2ndtable WHERE id = ?</font>
<br><font size=2 face="sans-serif">create proc DBD26 as UPDATE my2ndtable
SET mycolumn = ? WHERE id = ?</font>
<br><font size=2 face="sans-serif">create proc DBD27 as SELECT mycolumn
AS mycolumn FROM my2ndtable WHERE id = ?</font>
<br><font size=2 face="sans-serif">create proc DBD28 as UPDATE my2ndtable
SET mycolumn = ? WHERE id = ?</font>
<br><font size=2 face="sans-serif">create proc DBD29 as SELECT mycolumn
AS mycolumn FROM my2ndtable WHERE id = ?</font>
<br><font size=2 face="sans-serif">create proc DBD30 as UPDATE my2ndtable
SET mycolumn = ? WHERE id = ?</font>
<br><font size=2 face="sans-serif">create proc DBD31 as SELECT mycolumn
AS mycolumn FROM my2ndtable WHERE id = ?</font>
<br><font size=2 face="sans-serif">create proc DBD32 as UPDATE my2ndtable
SET mycolumn = ? WHERE id = ?</font>
<br><font size=2 face="sans-serif">create proc DBD33 as SELECT mycolumn
AS mycolumn FROM my2ndtable WHERE id = ?</font>
<br><font size=2 face="sans-serif">create proc DBD34 as UPDATE my2ndtable
SET mycolumn = ? WHERE id = ?</font>
<br><font size=2 face="sans-serif">create proc DBD35 as SELECT mycolumn
AS mycolumn FROM my2ndtable WHERE id = ?</font>
<br><font size=2 face="sans-serif">create proc DBD36 as UPDATE my2ndtable
SET mycolumn = ? WHERE id = ?</font>
<br><font size=2 face="sans-serif">create proc DBD37 as UPDATE my2ndtable
SET start_d = ? WHERE id = ?</font>
<br>