Re: SQLRPGLE ... order by Timestamp descending

Hi Booth,

I'm not getting why you have a host variable with : in the ORDER BY
clause. What is the name of the column that is of data type timestamp?

A single host variable in an ORDER BY, like you've specified, will not
affect the sorted order. This is because the same host variable value is
being applied to all rows of the SET. It is the conceptual equivalent of
ORDER BY constant.

I'd need to see the rest of your SQL to see why you have a row filter
problem.

Mike



On Thu, Mar 1, 2018 at 6:34 PM, Booth Martin <booth@xxxxxxxxxxxx> wrote:

I have a file with a timestamp field which quite often has a value
0001-01-01. I want to select all records in the file, in descending order
for that timestamp.

First issue: Only records greater than 0001-01-01 are being returned.

Second issue: no records are returned if I use "order by :timestamp desc"

--
This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L)
mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: http://amzn.to/2dEadiD