Retrieving and Storing SQL Source for DB2 Database Objects
December 2, 2009 Skip Marchesani
One issue that System i professionals are constantly raising when I’m preaching the gospel of DB2 for i SQL is that it’s difficult, or in some cases, not possible, to capture and store the SQL source statements or DDL (Data Definition Language) that were used to create DB2 database objects on a System i.
This is actually quite easy to do in Navigator using either of two almost identical functions. One is Generate SQL found in Database, and the other will be the focus of this article: Insert Generated SQL found in Run SQL Scripts. For reference, I am running