Re: Best Practices on DB2 SQL Databases

[Tommy.Holden@xxxxxxxxxxxxxxxxxxxxx]

FWIW i hand-code DDL for new tables, etc. but use that command to convert 
existing DDS built tables, indexes, etc.  generating the DDL from scratch 
is much easier than create DDS compile, run command, etc.  the only things 
i use DDS for anymore is DSPF and PRTF...but that's just me 8^) 

Thanks,
Tommy Holden



From:
rob@xxxxxxxxx
To:
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Date:
01/15/2009 01:52 PM
Subject:
Re: Best Practices on DB2 SQL Databases
Sent by:
midrange-l-bounces@xxxxxxxxxxxx



I understand all that Nathan.  But learning DDL instead of tools like 
Tommy's will open yourself to stuff like constraints, identity columns and 

whatnot.  Wasn't arguing to be purist or pulling a "real database" action.


Rob Berendt