Re: Best Practices on DB2 SQL Databases

Ops Nav has the ability to convert DDS to SQL statements and there's an
API that is used to retrieve the SQL statement. i have a command on my
web site that uses the API. it's on the downloads section
http://tommyholden.com if you wish to download it.

Thanks,
Tommy Holden



From:
Nathan Andelin <nandelin@xxxxxxxxx>
To:
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Date:
01/14/2009 11:34 AM
Subject:
Re: Best Practices on DB2 SQL Databases
Sent by:
midrange-l-bounces@xxxxxxxxxxxx

From: Walden H. Leverich
My issue w/DDS is twofold...

The VARLEN keyword in DDS is great for "comment" fields. I've never used
BLOBs. I prefer storing stream files in the IFS and attaching references
to records. Then generate HTML pages with hyperlinks to stream files.

I like DDS because of it's simple syntax. Most of my tables are under 10K
rows. Read/Write performance is not much different at that size. I
validate data via RPG before writing it to a table.

Of course, I understand that there are cases where it makes more sense to
define tables with SQL. That's where a DDS to SQL CL command would be
helpful.

Nathan.