AW: VMSDATE

[Bourchi, H.]

Chris,

Your gueses are correct. Its a RMS file type and key I am using is a UNIQUE
ALTERNATE key. 
I am still testing some other possibilliy with CHOOSE construction, like
what you suggested.
and reversing the place of B@@ in CASE function.
I consider conditional EXECUTE and conditional compilation as very
interesting options, but i would rather to make CHOOSE statement works. I am
stil testing ...

Regards,
Hamid Bourchi

> ----------
> Van: 	Chris Sharman[SMTP:Chris.Sharman@ccagroup.co.uk]
> Verzonden: 	donderdag 25 januari 2001 11:57
> Aan: 	David.Heasman@seacontainers.com
> CC: 	Chris.Sharman@ccagroup.co.uk; powerh-l@sphere.swau.edu
> Onderwerp: 	RE: VMSDATE
> 
> >Nifty Date format allows you to write to Audit files etc using
> VMSTIMESTAMP.
> >It contains a Date and a Time component (which of course prevents you
> >checking if the date = yyyymmdd).
> >
> >Is there a way of reporting a VMSDATE item which shows the Time bit
> >as well as the Date?
> 
> Here's my favourite:
> 
> def hhmm int*4 pic "^^:^^" signif 4 = &
> 	floor(0.00001*dateextract(<vmsdate>,time))
> 
> (I use floor rather than round to avoid displaying hh:60, particularly
> 23:60).
> 
> Allowing input is even less pleasant; and of course comparing any date
> item
> with VMSTIMESTAMP is a no-no: VMSTIMESTAMP is always greater than any date
> because it's treated as a (very large) number rather than a date.
> 
> dateextract(<vmsdate>,date) is OK for comparing with dates.
> 
> Wishlist:
> 1. It would be nice if Powerhouse supported full input/output of vmsdate
> (and
> stardate, or any other platform's timestamp), without klugey arithmetic
> from
> application programmers.
> 
> 2. Allow date (& numeric) keys to be generic like character keys (@@) in
> Quick screens. Presently I have to declare a char*8 redefinition in PHD &
> make
> that the key, have a proper int8/bin8 key in RMS, prompt for a date on the
> Quick screen (don't even think about trying to get the time portion), and
> using
> characters(<vmsdate>)+"@@" to lookup via the char*8 key, relying on
> Powerhouse
> using the RMS int8 key at the same offset without noticing it's the wrong
> type.
> Works in 6.10->7.10, & should in 8.30.
> 
> 99. Sensible behaviour for comparing vmstimestamp with dates: even just
> disallowing the comparison at compile time would be an improvement -
> vmstimestamp makes no sense as a number.
> 
> Chris
> _______________________________________________________________________
> Chris.Sharman@CCAgroup.co.uk		http://www.ccagroup.co.uk/
> CCA Stationery Ltd, Eastway, Fulwood, Preston, Lancashire, PR2 9WS.
> 
> 
> -----------------------------------------------------------------------
> 
> Any views expressed in this message are those of the sender and not
> necessarily those of CCA Group.  The unauthorized use, disclosure,
> copying or alteration of this message is forbidden.  The contents of
> this message may be confidential and/or privileged, copyright CCA Group
> and are intended solely for the use of the individual or entity to whom
> they are addressed.  Whilst this message has been scanned, CCA Group
> cannot guarantee that it is virus free or compatible with your systems
> and accepts no responsibility for any loss or damage arising from its
> use. The recipient is advised to run their own anti-virus software. If
> you receive this message in error please contact
> postmaster@ccagroup.co.uk immediately, destroy any copies and delete it
> from your computer systems.
> = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> =
> Subscribe: "subscribe powerh-l" in message body to
> majordomo@lists.swau.edu
> Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
> 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
This list is closed, thus to post to the list, you must be a subscriber.