db2lk_generate_ddl is a stored procedure that provides functionality to generate DDL via SQL (similar to db2look which is a tool as db2llok cannot be executed througha SQL client tool. This function already exists but is not documented and I am not sure if it is supported yet.
This functionality would ease Db2 handling be not forcing the user to swtich to a command line which is not available in every environment for all users who could benefit from that function.
Easy working with Db2 as developers are used to such functions from other database vendors.
Why is it useful?
|Who would benefit from this IDEA?||Db2 users, developers, administrators|
How should it work?
1) document and support the existent db2lk_generate_ddl or provide a simple stored procedure to generate ddl
|Priority Justification||Important functionality - already developed - easy to do|
NOTICE TO EU RESIDENTS: per EU Data Protection Policy, if you wish to remove your personal information from the IBM ideas portal, please login to the ideas portal using your previously registered information then change your email to "email@example.com" and first name to "anonymous" and last name to "anonymous". This will ensure that IBM will not send any emails to you about all idea submissions