[Squirrel-sql-commits] SF.net SVN: squirrel-sql:[6710] trunk/sql12/plugins/db2/src/main/java/net/ sourceforge/squirrel_sql/plugins/db2/sql/DB2SqlImpl.java

[<man...@us...>]

Revision: 6710
          http://squirrel-sql.svn.sourceforge.net/squirrel-sql/?rev=6710&view=rev
Author:   manningr
Date:     2012-11-05 01:42:19 +0000 (Mon, 05 Nov 2012)
Log Message:
-----------
Fixed bug in UDF details-finding SQL, according to Cristiano Guadagnino's advice.

Modified Paths:
--------------
    trunk/sql12/plugins/db2/src/main/java/net/sourceforge/squirrel_sql/plugins/db2/sql/DB2SqlImpl.java

Modified: trunk/sql12/plugins/db2/src/main/java/net/sourceforge/squirrel_sql/plugins/db2/sql/DB2SqlImpl.java
===================================================================
--- trunk/sql12/plugins/db2/src/main/java/net/sourceforge/squirrel_sql/plugins/db2/sql/DB2SqlImpl.java	2012-10-31 18:08:15 UTC (rev 6709)
+++ trunk/sql12/plugins/db2/src/main/java/net/sourceforge/squirrel_sql/plugins/db2/sql/DB2SqlImpl.java	2012-11-05 01:42:19 UTC (rev 6710)
@@ -372,8 +372,8 @@
 					"T1.REMARKS AS comment " +
 					"FROM sysibm.SYSSEQUENCES T1 left outer join sysibm.SYSDATATYPES T2 " +
 					"on T1.DATATYPEID = T2.DATATYPEID " +
-					"where T1.SEQSCHEMA = ? " +
-					"and T1.SEQNAME = ? ";
+					"where T1.SCHEMA = ? " +
+					"and T1.NAME = ? ";
 			break;
 		}
 		

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