×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
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.
midrange.com
