Re: ENTER in embedded SQL

When editing SQL you may find that the setting to auto-format SQL comes
into play...

Mike Hockings, M.Eng., P.Eng.
DevOps for Enterprise
IBM Developer for z Systems and Power Systems Software Technical Support
IBM Canada Ltd. Laboratory
hockings@xxxxxxxxxx




From: Justin Taylor <JUSTIN@xxxxxxxxxxxxx>
To: "Rational Developer for IBM i / Websphere Development Studio
Client for System i & iSeries" <wdsci-l@xxxxxxxxxxxx>
Date: 2018/03/16 15:36
Subject: Re: [WDSCI-L] ENTER in embedded SQL
Sent by: "WDSCI-L" <wdsci-l-bounces@xxxxxxxxxxxx>



For me:

Keyboard ENTER in SQL => Blank line, indented 2

Number pad ENTER in SQL => Split line, indented 2



Keyboard ENTER in RPGLE => Split line, indented 2

Number pad ENTER in RPGLE => Split line, no indent





RDi 9.6.0.1





-----Original Message-----

From: Vernon Hamberg [mailto:vhamberg@xxxxxxxxxxxxxxx]

Sent: Friday, March 16, 2018 12:06 PM

To: Rational Developer for IBM i / Websphere Development Studio Client for
System i & iSeries <wdsci-l@xxxxxxxxxxxx>

Subject: Re: [WDSCI-L] ENTER in embedded SQL



Maybe this was observed already, but I tried both Enter keys.



In embedded SQL, the main Enter key does not split the line,

                 the numkey Enter key adds a space, then does not split
the line - curious.



In other code, both Enter keys do the same thing - split the line or, if
you use the Ctrl key, just open the next line and go there.



For both SQL and other code, Ctrl with either Enter key creates the next
line and positions under the 1st character of the line above that. - this
latter I will find useful, methinks.



Vern

--
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:
https://urldefense.proofpoint.com/v2/url?u=https-3A__lists.midrange.com_mailman_listinfo_wdsci-2Dl&d=DwIGaQ&c=jf_iaSHvJObTbx-siA1ZOg&r=wo0uDJijITU2f7aW2HWa1KiNWzc2cb7dgMN4W-85iwI&m=6yaZs8j7wkipoWZv4ubRlp9T_yue15t9VQdON6TNQ64&s=aZwaZmgmhtGUjwqNenGdvbdrF_89qdDOLiA3lv7HFaI&e=

or email: WDSCI-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at
https://urldefense.proofpoint.com/v2/url?u=https-3A__archive.midrange.com_wdsci-2Dl&d=DwIGaQ&c=jf_iaSHvJObTbx-siA1ZOg&r=wo0uDJijITU2f7aW2HWa1KiNWzc2cb7dgMN4W-85iwI&m=6yaZs8j7wkipoWZv4ubRlp9T_yue15t9VQdON6TNQ64&s=zyn5pQXmsbgQzsdxouHX5rNaepmsozthx3uuwDcg2kc&e=
.