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
"What I would do in this case is avoid both menu mode and SELECT. In native
OLQ I would do something like (and the syntax will be a bit off because of
the rusty gate at the head of the path):

define path
get all CASE (field-1)
get LAST SPNARR (field-2) IN CASE-SPNARR
END PATH
EXEC PATH
SAVE QFILE CASE-SPNARR (so you can go in to add headings and modify EDIT
commands and so forth)

Or something to that effect. In fact - at this point you can switch into
MENU mode and do heading and other report formatting there. IDMS's ""real""
SQL supports a FIRST and LAST keyword as an extension to specifying the
WHERE SET extension to SQL (where you can specify whether the set navigation
is member to owner or owner to member) - I don't think that is supported in
SQL's SELECT statements.

Good luck - cheers - Gary

Outcomes