Midrange News for the IBM i Community

Posted by: clbirk
actually DDL question
has no ratings.
Published: 17 Feb 2012
Revised: 23 Jan 2013 - 2246 days ago
Last viewed on: 19 Mar 2019 (7474 views) 

Using IBM i? Need to create Excel, CSV, HTML, JSON, PDF, SPOOL reports? Learn more about the fastest and least expensive tool for the job: SQL iQuery.

actually DDL question Published by: clbirk on 17 Feb 2012 view comments(11)

In setting up new tables I am using DDL (sql commands). My question is what are folks doing to save this definition. Granted it is associated with the file and any time you can go into inav and generate it, but I had a person delete one of the tables as they wanted to clear it and well you lose your commands.

It would seem to me that it would be easiest to simply go and run inav and generate the sql for each and store these text somewhere.


But what do others do?

Return to midrangenews.com home page.
Sort Ascend | Descend