ca.portal.admin

Re:OLQ menu

Discussion created by ca.portal.admin on Mar 4, 2005
Hello all,
I am trying to produce a ""quick and dirty"" report for the user. Was trying
to use OLQ menu mode to build the report and then save a qfile and run
batch. The question is - is there a way to make OLQ walk a set backwards?
I have record ""A"" that is stored calc and record ""B"" that is stored via ""A""
but the most recent records are always stored first in the set. In my
query, I just want the first record stored chronologically (ie. the ""last""
one in the set). Is there a way to alter the path that OLQ creates when it
builds the query?
thanks,
Debbie Grafton
D.C. Superior Court

"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Re: OLQ menu
"Debbie,

In the SQL Reference Manual there is an explanation as to how the set
specification within the WHERE statement ('case-spnarr') can be modified to
use either the FIRST or LAST option. The 15.0 Manual has the information in
section 9.6.2.

Save the query as a Q-File and use the IDD to edit it to add the correct
keyword.

John Wheeler

Outcomes