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

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

Revision: 6674
          http://squirrel-sql.svn.sourceforge.net/squirrel-sql/?rev=6674&view=rev
Author:   manningr
Date:     2012-10-01 23:49:47 +0000 (Mon, 01 Oct 2012)
Log Message:
-----------
Fixed UDF related queries for z/OS according to Cristiano's latest 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-01 20:59:12 UTC (rev 6673)
+++ 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)
@@ -68,8 +68,8 @@
 				"else 'no source available' " +
 				"end as definition " +
 				"from SYSIBM.SYSROUTINES " +
-				"where routine_schema = ? " +
-				"and routine_name = ? " +
+				"where schema = ? " +
+				"and name = ? " +
 				"and ROUTINETYPE = 'F' ";			
 		}
 		
@@ -441,10 +441,11 @@
 			break;
 		case ZOS:
 			result = 
-			    "select routine_name " +
-			    "from SYSIBM.SYSROUTINES " +
-			    "where routine_schema = ? " +
-			    "and routine_name like ? ";	
+				"SELECT * " +
+				"FROM SYSIBM.SYSROUTINES " +
+				"WHERE ROUTINETYPE = 'F' " +
+				"AND SCHEMA = ? " +
+				"AND NAME like ? ";
 			result = "";
 			break;
 		}

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