I would like to use Java on Windows to access a DB2 zOS subsystem. I have already implemented some queries in a JCL in order to extract information from system-catalog into readable Windows text files and now I would like to use Java. For instance, I have the following query that allows to extract the list of columns of tables and views.
WHEN TYPENAME = ' ' THEN COLTYPE
ORDER BY TBCREATOR, TBNAME, COLNO;
Do you have an example of Java code that to execute queries from Windows against DB2 zOS and corresponding results?
Thank you in advance.