Re: Confused about DDL and DDS

I also use GENDDL. I like it if I am converting from legacy but I hate to
write DDS. What a pain. If I am creating a DDS table, a lot of times I will
create in Ops Nav and then use DBU to extract the DDS from the SQL table
just to avoid writing DDS. I think Ops Nav is way cool. Not sure how it
would be too much work.

One of my favorites is text and headers. In Ops Nav, I just type the text
and the headers and it generates everything for me. With DDS I must type
TEXT('value the will fit + mark rest of text. Then COLHDG and so on and so
forth. What a pain.

On Wed, Apr 29, 2009 at 4:57 PM, Nathan Andelin <nandelin@xxxxxxxxx> wrote:

From: Alan Campin
Always use Operations Navigator ...
You never want to code this stuff by hand. Way too much work.

This seems to be an appropriate place to recommend Tommy Holden's GENDDL
command:

http://www.tommyholden.com/

See the Downloads link.

Use DDS & CRTPF to create tables. Use GENDDL to generate SQL DDL. Then
RUNSQLSTM to re-create tables.

Some of us think Operations Navigator is too much work.

Nathan.




--
This is the RPG programming on the IBM i / System i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.