DECSTAT DB2 z/OS getMetaData().getColumns etc

oceangbr · **Posted:** Fri Jan 13, 2006 4:53 pm

This is an FYI - no help required.

When using Hibernate Tools with DB2 on z/OS (Mainframe), be aware that you need to set DECSTAT=YES and rebind the packages in order for getMetaData().getColumns etc to work. NB. setting this will slightly increase your package size on DB2.

The reason for this is that within the Hibernate Tools class, org.hibernate.cfg.reveng.dialect.JDBCMetaDataDialect, calls are made with the column name, e.g. rs.getString("INDEX_NAME"). DB2 will not provide the column names without the DECSTAT setting. i.e. positioning works e.g. rs.getString(3). DB2 calls a packages SYSIBM.SQLTABLES, SYSIBM.SQLCOLUMNS etc.

oceangbr · **Posted:** Fri Jan 13, 2006 4:59 pm

That should read - DESCSTAT not DECSTAT

Quote:

This is an FYI - no help required.

When using Hibernate Tools with DB2 on z/OS (Mainframe), be aware that you need to set DESCSTAT=YES and rebind the packages in order for getMetaData().getColumns etc to work. NB. setting this will slightly increase your package size on DB2.

The reason for this is that within the Hibernate Tools class, org.hibernate.cfg.reveng.dialect.JDBCMetaDataDialect, calls are made with the column name, e.g. rs.getString("INDEX_NAME"). DB2 will not provide the column names without the DESCSTAT setting. i.e. positioning works e.g. rs.getString(3). DB2 calls a packages SYSIBM.SQLTABLES, SYSIBM.SQLCOLUMNS etc.

max · **Posted:** Fri Jan 13, 2006 5:27 pm

rs.getString(3) works but rs.getString("INDEX_NAME") does not ? great ;)

p.s. you can implement your own MetaDataDialect that works around this limitation if you want

max · **Posted:** Fri Jan 13, 2006 5:27 pm

p.s. if you put this in jira as a FAQ contribution i wont forget to include it in the tools doc at some point

bsdwork · **Joined:** Thu Sep 27, 2007 10:48 am **Posts:** 5

After all.. it's DESCSTAT ?! With S right?
Cheers