Hi David
you can use the clause
upper
for example
Exec Sql Declare cursorJ77 CURSOR For
Select *
From File77
order by AgcmDATE, upper(Name)
For Read Only;
Exec Sql Open cursorJ77;
but it will not change the actual value of the data
Alan Shore
Programmer/Analyst, Distribution
E:AShore@xxxxxxxxxxx
P:(631) 200-5019
C:(631) 880-8640
"If you're going through Hell, keep going" - Winston Churchill
"David Fairbairn"
<dfairbairn@xxxxx
ylor.mi.us> To
Sent by: <rpg400-l@xxxxxxxxxxxx>
rpg400-l-bounces@ cc
midrange.com
Subject
Using Alternate Sequence In SQL -
11/30/2009 02:46 QCASE256
PM
Please respond to
RPG programming
on the IBM i /
System i
<rpg400-l@midrang
e.com>
Hi
Table qusrsys/qcase256 can be used in DDS to sort alphabetically and ignore
the case. (ie A=a in the sort sequence)
Can this be done in an embedded SQL statement? For example,
Exec Sql Declare cursorJ77 CURSOR For
Select *
From File77
order by AgcmDATE, Name
For Read Only;
Exec Sql Open cursorJ77;
AgcmDate is a date field. Name is an alpha field with mixed case letters.
The above statement returns records in an order like:
2009-01-06 knight
2009-01-06 Bowman
Unfortunately, knight comes before Bowman.
This is a join file and each key field comes from a different file. So I
can't use DDS to sort the file. (Key fields from different files are not
allowed.)
I was hoping an SQL statement could do this. (And yes, I am trying to
avoid using OPNQRYF.)
Thank you
--
This is the RPG programming on the IBM i / System i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at
http://archive.midrange.com/rpg400-l.
midrange.com
