Re: DDL in RDi

On 2/25/2015 3:25 PM, Jim Diephuis wrote:

I created a user action that runs the RUNSQLSTMT when selected. It only
shows up when the source member type is sql.

Jim Diephuis

-----Original Message-----
From: WDSCI-L [mailto:wdsci-l-bounces@xxxxxxxxxxxx] On Behalf Of Dan
Pankowski
Sent: Wednesday, February 25, 2015 1:55 PM
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.

An alternative to User Actions is a compile command.
I just tried it out in 9.1.1 with a .sql member type.
Compile > Work with compile commands...
Click Add... next to Source type at the top.
New member type: SQL, OK

Label:runsqlstm
Command:runsqlstm srcfile(&L/&F) srcmbr(&N) commit(*none) naming(*sys)
Click Create at the bottom, then Close

Now all my .sql members have a compile option that will be invoked with
Ctrl-Shift-C (or the icon). Results are visible in the Commands Log view.