Accessing Z Tables using DB2 JDBC driver...

[Former Member]

Hi,

We are running SAP on iSeries and I need to access the SAP Z Tables in read only (for cross-referencing) from a simple Java program (standalone).

Is it acceptable (from SAP standpoint of view) to access those Z tables (in read-only) using DB2 JDBC driver or we are forced to use RFC calls?

I'm not a SAP expert and would appreciate your comments.

Best Regards.

Message was edited by: Massimo Di Marco

[Former Member]

Hi Massimo,

in general SAP people don't like it when others access the database directly, in fact they try to prevent it. The "proper" way would be to do it via an RFC call. It's fully possible to do it via jdbc (I've done it in some projects), there are no technical constraints, it's mostly a security question.

Talk to your SAP people and the DBA's, and I'm sure you can work something out. These are Z-tables, so they might be more lenient in letting you access them directly. But be prepared to fight for the right to read those tables

regards,

Dion