|
I'm getting this error ("ORDER BY column *N or expression not in result table") in V5R1 using this SQLRPGLE code: select cmcust,cmname,cmcity from custmast order by (case when :option = '*NAME' then cmname when :option = '*CITY' then cmcity end) The error is indicated at the "(case" statement, with or without parentheses. The column names are valid; OPTION is a valid character variable. Is this construct not supported in iSeries DB2? Or is my syntax just goofy? Thanks, irg ---------------------------------------------------------------------- Store more e-mails with MSN Hotmail Extra Storage * 4 plans to choose from!
As an Amazon Associate we earn from qualifying purchases.
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.