Re: jpex editor and embedded SQL -- WDSCI-L

Sam

Nothing in WDSC, but I found a very nice formatter for SQL - called niceSQL. Link to it is <http://home.broadpark.no/~ihalvor/>, unregistered puts a banner into reformatted text, but registration is cheap. Per computer and does not migrate, but there might be multiple options.

E.g.,

select * from file where x = substr(field, 1, 4) and y = z

becomes

select
        *
from
        file
where
        x = substr(field, 1, 4) and
        y = z

There are options for uppercase, where ANDs go. And the developer is very responsive to bug reports, etc.

Vern

At 12:17 PM 10/29/2004, you wrote:

   The split option are interesting.  I may redefine a-s to splitLine.  Or
   maybe c-s-s.

   What I would really like in RPG is a split feature that would allow me to
   take something like this:

   C+ select field1, field2, field3

   and quickly turn it into this:

   C+ select field1,

   C+        field2, field3

   and then into this:

   C+ select field1,

   C+        field2,

   C+        field3

   I often paste unstructed, hard to read, SQL into my programs and I like to
   reformat it to a less "steam of consciousness" style.

   Right now I use alt-s, then RR and OO commands, but I'd like to do it more
   quickly.

   I don't suppose you've run into this while researching the splitting
   options?

Sam

   >From: Vernon Hamberg <vhamberg@xxxxxxxxxxx>

   >There are 3 "split" functions you can set to a key. "split" takes
   >everything from the cursor to the end of the line and puts it at the
   >start of a new line. Alt-s already does this, Alt-j joins them up
   >again.
   >
   >"splitLine" does something similar, except that in RPG, e.g., it
   >starts the data under the specification column of the new line.
   >
   >"splitAndShift" puts the data directly under its former location. I
   >like this one, I think.
   >
   >BTW, case matters - "splitandshift" does not work.

     ----------------------------------------------------------------------

Find the music you love on MSN Music. Start downloading now! _______________________________________________ This is the Websphere Development Studio Client for 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.