I try reverse engineering with a db2 as400 and connect to the database via Toolbox for Java JDBC Driver. I can also read the table correctly, but unfortunately only without the column information.
Why can’t I get the information about the columns?
Thank you for your help
I have a solution to the problem.
Permissions must be granted to use the following SQL procedures:
SQL PROCEDURE SYSIBM/SQLFOREIGNKEYS
program name. . . . . . . . . . . . . . . . . . . . . QSQSIFOREI
library . . . . . . . . . . . . . . . . . . . . . . . . . . . . QSYS
SQL PROCEDURE SYSIBM/SQLPRIMARYKEYS
program name. . . . . . . . . . . . . . . . . . . . . QSQSIPRIMA
library . . . . . . . . . . . . . . . . . . . . . . . . . . . . QSYS
1 Like