Reactions to story from Jason L. Froebe: Ramblings of a Geek
35383: DBD::Sybase calls the broken sp_tables stored procedure
http://froebe.net/ blog/ 2008/ 04/ 24/ 35383-dbdsybase-calls-the-broken-sp_tables-sto...
35383: DBD::Sybase calls the broken sp_tables stored procedure Centos 5 Linux dba-dev1 2.6.22.9-default #1 SMP Mon Oct 1 11:26:48 CDT 2007 i686 athlon i386 GNU/Linux Perl v5.8.8 built for i386-linux-thread-multi DBD::Sybase 1.07 but 1.08 also has the problem. Due to Sybase CR 497173, sp_tables can not be relied upon to retrieve table information correctly for ASE 15. (ASE 15 stored procedure “sp_tables” doesn’t work with SQL UDFs) We need to query the system tables instead. Obviously, the below code would work in v12.0 and higher. A temp table could probably be used for prior to 12.0 for the TABLE_TYPE to be filled correctly.
More rising blog posts
-
Entertainment »
SIGHting -
Business »
The Beginnings Of The Best Damn Stock Market GlossaryEver -
Lifestyle »
Separated At Birth -
Politics »
A Final NRA Salvo At Obama Mentions Wife, Wright (Updated) -
Sports »
Anthony Alridge - Denver Broncos Player Bio -
Technology »
Swashbot sashays his way into our hearts
More rising news stories
-
Entertainment »
Pete and Ashlee Celebrate at Rehearsal Dinner -
Business »
Saving Burma -
Lifestyle »
Train derailment, acid leak force evacuation -
Politics »
CNN: Ted Kennedy has apparent seizure -
Sports »
Jockey chases Triple Crown while son can still see it - USATODAY.com -
Technology »
Will Elder, 86; Zany Cartoonist for Mad and Playboy
Recent posts from Jason L. Froebe: Ramblings of a Geek
-
The Sybase TechWave 2008 Presentation Acceptance/Rejection letters are being sent now!
5 days ago -
Canon Pixma MP150 printer maintenance codes
5 days ago -
My daughter, Miriam is teething!
5 days ago