IBM Mainframe Forum

Hello,

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.

SELECT
TBCREATOR,
TBNAME,
COLNO,
NAME,
CASE
WHEN TYPENAME = ' ' THEN COLTYPE
ELSE TYPENAME
END,
TYPESCHEMA,
COALESCE(KEYSEQ,0),
LENGTH,
SCALE,
NULLS,
REMARKS,
DEFAULTVALUE

FROM SYSIBM.SYSCOLUMNS
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.

Has anyone already implemented SQL queries in Java code running on Windows against a DB2for zOS?

Thanks in advance.

Regards