Hello trafodioneers,
I am trying to use jdbc metadata api to retrieve the equivalent of what a
showddl or invoke would provide in sqlci or trafci.
If I use
DatabaseMetaData metadata =
conn.getMetaData();
ResultSet rs =
metadata.getColumns("TRAFODION", "ERIC","TBL", "%");
The resulting resultset does not provide hidden columns. For example the
"_SALT_" and "_DIVISION_1_".
And when doing a
rs = metadata.getPrimaryKeys("TRAFODION",primarySchema, primaryTable);
the "_DIVISION_1_" column is returned, but not the _SALT_.
Any idea if it is possible to use jdbc to get same level of info I would get
with showddl or invoke in SQLCI/trafci?
Thanks in advance for the help,
Eric