Thanks for the compliment.
DBeaver uses an "undocumented" stored proc to generate table DDL: SYSPROC.DB2LK_GENERATE_DDL(). This one is used internally by the "db2look" command
This is the best way to generate an exact and "perfect" DDL, corresponding to what db2look gives. The drawback is that you need to have access to this SP and its dependencies, including the SYSTOOLS.DB2LOOK_INFO_V view
The SQL executed to generate DDL is actually:
call SYSPROC.DB2LK_GENERATE_DDL("-e -td <delimiter> -t <fully qualified table name>",?)
Maybe this SP or its dependencies do not exist or act differently of on your server (I test with DB2 Win/v10.5 and DB2 AIX64/9.7+10.1 too..)
Could you verify if you have something in the error logs or in the query manager view while you try to display DDL of a table . Also please check the dbeaver error.log (in your <user home>/.dbeaver/.metadata/dbeaver-debug.log)
To display those views, in the "Window" menu
- check "Query manager"
- chek "Error Log"
Please send the result to me :
titou10.titou10@gmail.comThanks
Denis