[Treebase-guts] SF.net SVN: treebase:[26] trunk/treebase-core/src/main/perl/dump/sqldump

[<rv...@us...>]

Revision: 26
          http://treebase.svn.sourceforge.net/treebase/?rev=26&view=rev
Author:   rvos
Date:     2009-06-11 06:19:36 +0000 (Thu, 11 Jun 2009)

Log Message:
-----------
Changed SQL for fetching all tables

Modified Paths:
--------------
    trunk/treebase-core/src/main/perl/dump/sqldump

Modified: trunk/treebase-core/src/main/perl/dump/sqldump
===================================================================
--- trunk/treebase-core/src/main/perl/dump/sqldump	2009-06-11 06:11:11 UTC (rev 25)
+++ trunk/treebase-core/src/main/perl/dump/sqldump	2009-06-11 06:19:36 UTC (rev 26)
@@ -114,7 +114,7 @@
 
 sub get_all_tables {
 	my $dbh = get_handle();
-	my $sth = $dbh->prepare('show tables');
+	my $sth = $dbh->prepare('SELECT * FROM SYSCAT.TABLES');
 	#my @fetched_tables;
 	use Data::Dumper;
 	$sth->execute();


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.