Re: SQLRPGLE ... order by Timestamp descending

[Mike Jones <mike.jones.sysdev@xxxxxxxxx>]

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