CHOOSE current-date

[Michael Lee]

I realized I could have accessed Powerhouse during the conference. I couldn't
access Powerhouse from my hotel room in the morning whilst checking my email
however. Being that I had some problems retrieving email (and Cognos was NOT to
blame for that) I didn't want to chance waiting until the evening either. I'm
just amazed that I got it right ;-).


Michael Lee
MCL Systems Inc.


"Hamilton, Allison" wrote:

> Mike - you could have accessed PowerHouse on any machine in the Hands-on Lab
> or at the ADT booth in the Showcase... you were probably too busy to realise
> that!   All the hands-On lab machines had PH Web and Axiant on them, as did
> the machines at the booth.
> Allison Hamilton
>
> > ----------
> > From:         Michael Lee[SMTP:mcl_systems@bc.sympatico.ca]
> > Sent:         Wednesday, September 08, 1999 7:52 AM
> > To:   Johan Koelewijn
> > Cc:   Bob Feighner; powerh-l@lists.swau.edu
> > Subject:      Re: CHOOSE current-date
> >
> > I don't have access to Powerhouse right now as I'm stuck here in Florida
> > at the
> > user conference (life's rough) but I think you can do the following:
> > CHOOSE DATE-FIELD (SYSDATE)
> >
> > I may be wrong on this but give it a shot.
> >
> > Michael Lee
> > MCL Systems Inc.
> >
> >
> > Johan Koelewijn wrote:
> >
> > > Hello Bob,
> > >
> > > You can put the value of sysdate in a systemvalue and use that
> > systemvalue
> > > for your choose. That's the way we do it.
> > >
> > > Johan Koelewijn
> > > Van Dijk Delft BV
> > >
> > > -----Oorspronkelijk bericht-----
> > > Van: Bob Feighner <bfeighnr@mailclerk.ecok.edu>
> > > Aan: powerh-l@lists.swau.edu <powerh-l@lists.swau.edu>
> > > Datum: dinsdag 7 september 1999 23:47
> > > Onderwerp: CHOOSE current-date
> > >
> > > >I can't believe that I haven't tried this before, but it must be the
> > case.
> > > >
> > > >I want to use a QUIZ statement
> > > >'CHOOSE A-DATE SYSDATE'
> > > >where A-DATE is a key to the IMAGE detail data set residing on our
> > HP3000
> > > and
> > > >receive this error message.
> > > >
> > > >*E* Expected:  @  .  GENERIC  NOGENERIC  PARM  SYSTEMVALUE  ,  (
> > <number>
> > > >      <eol>
> > > >
> > > >If I change it to
> > > >'CHOOSE A-DATE 19990907', all is well.
> > > >
> > > >If I change it to
> > > >'SELECT IF A-DATE = SYSDATE', all is well (except that it does a serial
> > > read on
> > > >the file.
> > > >
> > > >I want to run this daily without having to 'seed' the command file with
> > the
> > > date
> > > >every time.
> > > >
> > > >I'm guessing that this is trivial for someone.
> > > >
> > > >Help, please and Thanks In Advance.
> > > >
> > > >Bob
> > > >
> > > >- Bob Feighner
> > > >- Director, Computer Services
> > > >- 159 Administration Building
> > > >- East Central University
> > > >- Ada, OK  74820
> > > >- bfeighnr@mailclerk.ecok.edu
> > > >- phone:   580/310-5256
> > > >- FAX:     580/436-4563
> > > >- http://www.ecok.edu
> > > >
> > > >
> > > >= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> > = =
> > > >Subscribe: "subscribe powerh-l" in message body to
> > majordomo@lists.swau.edu
> > > >Unsubscribe: "unsubscribe powerh-l" in message to
> > majordomo@lists.swau.edu
> > > >powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
> > > >This list is closed, thus to post to the list, you must be a
> > subscriber.
> > >
> > > = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> > = =
> > > Subscribe: "subscribe powerh-l" in message body to
> > majordomo@lists.swau.edu
> > > Unsubscribe: "unsubscribe powerh-l" in message to
> > majordomo@lists.swau.edu
> > > powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
> > > This list is closed, thus to post to the list, you must be a subscriber.
> >
> >
> >
> > = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> > =
> > Subscribe: "subscribe powerh-l" in message body to
> > majordomo@lists.swau.edu
> > Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
> > powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
> > This list is closed, thus to post to the list, you must be a subscriber.
> >
> = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
> Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
> powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
> This list is closed, thus to post to the list, you must be a subscriber.

= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
This list is closed, thus to post to the list, you must be a subscriber.