× 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.



There is a pdf file of the SQL reference in the RDi help located at:

IBM i programming resources > SQL > SQL reference > PDF file for SQL reference

It looks like the syntax formatting is correct in the pdf.


James Littlejohn
fortra.com



-----Original Message-----
From: WDSCI-L <wdsci-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of David Gibbs via WDSCI-L
Sent: June 19, 2025 4:58 PM
To: Rational Developer for IBM i / Websphere Development Studio Client for System i & iSeries <wdsci-l@xxxxxxxxxxxxxxxxxx>
Cc: David Gibbs <david@xxxxxxxxxxxx>
Subject: [WDSCI-L] Broken formatting in help content

External: Pause and review the sender's email address, any URLs before clicking links, opening attachments, or following requests. When in doubt, contact the Service Desk.


Folks:

Anyone else seeing bad formatting in some of the help content?

Specifically, I'm seeing missing spaces in the syntax for SQL statements.

For example: On the create index help...

CREATEUNIQUEWHERE NOT NULLENCODED VECTORINDEXindex-nameFOR SYSTEM NAMEsystem-object-identifierONtable-name(,key-expressionASCDESC)WHEREsearch-conditionindex-optionskey-expressionexpressionAScolumn-nameFORCOLUMNsystem-column-nameindex-optionsWITHintegerDISTINCTVALUESNOT
PARTITIONEDPARTITIONEDINCLUDE(,aggregate-function-name
(expression))PAGESIZE64PAGESIZE81632128256512RCDFMTformat-nameADD ALL COLUMNSADD KEYS ONLYADD,column-namemedia-preferencememory-preference1media-preferenceUNIT
ANYUNIT SSDmemory-preferenceKEEP IN MEMORYNOYES

Looks like all the syntax content in the SQL help is suffering from the same thing.

david
--
IBM i on Power Systems: For when you can't afford to be out of business!

I'm riding in the American Diabetes Association's Tour de Cure to raise money for diabetes research, education, advocacy, and awareness.
You can make a tax-deductible donation to my ride by visiting https://mideml.diabetessucks.net/.
--
This is the Rational Developer for IBM i (WDSCI-L) mailing list
To post a message email: WDSCI-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/wdsci-l
or email: WDSCI-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at https://archive.midrange.com/wdsci-l.



As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

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

This mailing list archive is Copyright 1997-2025 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.