# No column with reverse Database

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