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

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

Revision: 6675
          http://squirrel-sql.svn.sourceforge.net/squirrel-sql/?rev=6675&view=rev
Author:   manningr
Date:     2012-10-02 23:25:27 +0000 (Tue, 02 Oct 2012)
Log Message:
-----------
Fixes according to Cristiano's testing.

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-01 23:49:47 UTC (rev 6674)
+++ trunk/sql12/plugins/db2/src/main/java/net/sourceforge/squirrel_sql/plugins/db2/sql/DB2SqlImpl.java	2012-10-02 23:25:27 UTC (rev 6675)
@@ -441,7 +441,7 @@
 			break;
 		case ZOS:
 			result = 
-				"SELECT * " +
+				"SELECT NAME " +
 				"FROM SYSIBM.SYSROUTINES " +
 				"WHERE ROUTINETYPE = 'F' " +
 				"AND SCHEMA = ? " +
@@ -476,10 +476,10 @@
 			break;
 		case ZOS:
 			result = 
-	        "select SEQNAME " +
+	        "select NAME " +
            "from sysibm.SYSSEQUENCES " +
-           "WHERE SEQSCHEMA = ? " +
-           "AND SEQNAME like ? ";
+           "WHERE SCHEMA = ? " +
+           "AND NAME like ? ";
 			break;
 		}
 		

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