|
From: Jim It <ji...@ho...> - 2014-03-03 20:44:54
|
Eric, There are a whole host of jdbc properties which can effect the way the IBM system handles jdbc requests. http://pic.dhe.ibm.com/infocenter/iseries/v7r1m0/topic/rzahh/javadoc/com/ibm/as400/micro/doc-files/JDBCProperties.html?resultof=%22%53%79%73%74%65%6d%22%20%22%73%79%73%74%65%6d%22%20%22%70%72%6f%70%65%72%74%69%65%73%3a%22%20%22%70%72%6f%70%65%72%74%69%22%20 The one that changed is metadata source. The default setting was 0 - Database metadata will be retrieved through the Retrieve Object Information (ROI) data flow, but was change to 1 - Database metadata will be retrieved by calling system stored procedures in 7.1. Go into Alias properties, Driver Properties tab and specify the driver properties you want to use and the value you want to use, in this case 1. Jim |
