Use an ALIAS for UPPER(process) like:
Select Distinct upper(Process) AS Process_A, etc
Order by Process_A
Op 26-7-2022 om 19:51 schreef a4g atl:
I need help building this statement.Schedule
IBMi does not like it.
set schema oprutllib;
(Select Distinct upper(Process), Schedule_Year, Schedule_Period,
'Tasks' As File,
Select Distinct upper(Process), Schedule_Year, Schedule_Period,
'Log' As File,
from Mth_Logs )
Order by upper(Process), Schedule_Year desc, Schedule_Period desc,
If I do the order by as : Order by Process, Schedule_Year desc,
Schedule_Period desc, Schedule Desc
it complains that PROCESS is undefined or not in the list.
As the field Process allows both upper and lower case, I need to be able
sort using uppercase.
Any Suggestions would be appreciated.
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
Help support midrange.com by shopping at amazon.com with our affiliate
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.