Source types of SQL do not have a typical create style, so no system
CRTxxx command to generate tables. One reason is that a lot of product
development teams develop their database using diagram tools and all the
database items are included and all database items are created at one
time.
Our migration seems similar to yours as we continue to use DDS for items
already defined in DDS and new items in SQL, (except for we have loaded
all products into our CMS). We develop and create each data base object
as separate CMS objects. It makes it easier to move forward but limits
the design to other ways. We type our SQL members as "SQL" and each
programmer has to add .SQL file type and association in to their
workspace. We have Aldon LM(i) and can create SQL types through their
interface but there was no Ctrl+Alt+C option until I modified Scott
Klement's BUILD tool to work with SQL types using the Aldon LM(i)
database. (See this thread
http://archive.midrange.com/wdsci-l/201409/msg00049.html). This
required us to add items to Aldon LM(i) for the command to work but
that's our direction anyway.
I utilized Aldon LM(i) commands to create my SQL types because it was
the easiest option for me (Aldon LM(i) product will drop all indexex and
tables for me before attempting to create the item again) but you could
take this code attached in the other thread and and the RUNSQLSTM for
you own purposes. There is no feed back to the error view for
situations like this. I then add this command to the compile prompts
in RDi, BUILD OBJ(&L/&N) SRCFILE(&L/&F) DBGVIEW(*SOURCE) REPLACE(*YES)
USECMS(*YES) OPTION(*EVENTF).
I believe COMPILE tool by Alan Campin at
http://www.think400.dk/downloads.htm Think400 can accomplish the same
thing.
You just have to make the create command yourself.
Thanks, Matt
-----Original Message-----
From: WDSCI-L [mailto:wdsci-l-bounces@xxxxxxxxxxxx] On Behalf Of Dan
Pankowski
Sent: Wednesday, February 25, 2015 11:55 AM
To: wdsci-l@xxxxxxxxxxxx
Subject: [WDSCI-L] DDL in RDi
Hello,
We're moving from dds to ddl. My question is how do you create and edit
DDL and then compile in RDi.
We have been adding members to qsqlsrc source file and running the
runsqlstm command on the green screen, but I'd to do all development in
RDi.
It works in the Arcad skipper plugin, but we don't have all of our
applications in Arcad yet.
Dan Pankowski
Information Technology Department
Ph: 801-524-2956
www.sinclairoil.com<
http://www.sinclairoil.com>
[Sinclair Logo]
--
This is the Rational Developer for IBM i / Websphere Development Studio
Client for System i & iSeries (WDSCI-L) mailing list To post a message
email: WDSCI-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list
options,
visit:
http://lists.midrange.com/mailman/listinfo/wdsci-l
or email: WDSCI-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/wdsci-l.
midrange.com
