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.