Re: Best Practices on DB2 SQL Databases

Nathan,

There's an API - QSQGNDDL - that will create the DDL from any Physical/Logical, including those defined with DDS. I believe Tom Holden for one has wrappered the API. That would probably be a DDS to SQL CL Command :-)

Crispin.

----- Original Message ----- From: "Nathan Andelin" <nandelin@xxxxxxxxx>
To: "Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
Sent: Wednesday, January 14, 2009 12:35 PM
Subject: Re: Best Practices on DB2 SQL Databases

>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.



--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.