× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



FWIW, the automatic SQL formatting starts to suck massively when the
statement gets even a little complex.

Example (hoping that line truncation won't make it even less readable)

Exec SQL
Select '1' into :sw_ok
from sysibm/sysdummy1
where exists (
Select 1
from PDIT19PF a
where pdmnbr19 = :pdmnbrpr and
vernbr19 = :vernbrpr and
wflcur19 like :wflid273 and
lcscur19 = :lcsalw73 and
exists (select 1 from pdwd73pf
where wflty173 = :wflty173 and
wflid173 = :wflid173 and
lcstar73 = :lcstarpr and
wflty273 = :wflty273 and
wflid273 like :wflid273 and
lcsalw73 = a.lcscur19 and
(claent73 = :c_allowed or
claent73 = :c_mandatory)) and
not exists (select 1 from pdlh27pf
where pdmnbr27 = a.pdmnbr19 and
vernbr27 = a.vernbr19 and
pdmcls27 = 'ITEM' and
wflide27 = a.wflcur19 and
lcstar27 = a.lcscur19 and
lcsfla27 = ' '));

gets mangled into

Exec SQL
Select '1'
into :sw_ok
from sysibm / sysdummy1
where exists (Select 1
from PDIT19PF a
where pdmnbr19 = :pdmnbrpr and
vernbr19 = :vernbrpr and
wflcur19 like :wflid273 and
lcscur19 = :lcsalw73 and
exists (select 1
from pdwd73pf
where wflty173 = :wflty173 and
wflid173 = :wflid173 and
lcstar73 = :lcstarpr and
wflty273 = :wflty273 and
wflid273 like :wflid273
and
lcsalw73 = a.lcscur19 and
(claent73 = :c_allowed or
claent73 = :c_mandatory))
and
not exists (select 1
from pdlh27pf
where pdmnbr27 = a.pdmnbr19 and
vernbr27 = a.vernbr19 and
pdmcls27 = 'ITEM' and
wflide27 = a.wflcur19 and
lcstar27 = a.lcscur19 and
lcsfla27 = ' '));


Eeeewwwww.

Peter Colpaert
Software Engineer, Consumer Luminaires

Industrieterrein Satenrozen 11, 2550 Kontich, Belgium
Tel. +32/ 3 450 74 09, Fax +32/ 3 450 74 33, Internal 1317
peter.colpaert@xxxxxxxxxxx, www.philips.com



The information contained in this message is confidential and may be
legally privileged. The message is intended solely for the addressee(s).
If you are not the intended recipient, you are hereby notified that any
use, dissemination, or reproduction is strictly prohibited and may be
unlawful. If you are not the intended recipient, please contact the sender
by return e-mail and destroy all copies of the original message.






JLong@xxxxxxxxxx
Sent by: wdsci-l-bounces@xxxxxxxxxxxx
06/05/2008 23:37
Please respond to
Websphere Development Studio Client for iSeries <wdsci-l@xxxxxxxxxxxx>


To
Websphere Development Studio Client for iSeries <wdsci-l@xxxxxxxxxxxx>
cc

Subject
Re: [WDSCI-L] SQL Prompting






Not sure about WDSCi.

WDSCi V7 does have some formatting options at:

Remote Systems
Remote Systems LPEX Editor
ILE RPG
Free-form SQL Formatting



Jack Long
CBK Ltd.



As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.