CA IDMS IUA EIUA

  • 1.  Re:OLQ menu

    Posted 03-04-2005 02:44 AM
    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