'Y' in defined item name

[Martijn Nabben (INL)]

Indeed NONULLSEPARATOR does the trick!

Thanks very much for all your help, I thought I was going mad !

Cheers,
Martijn Nabben
Independent Newspapers Ltd
Wellington, New Zealand

-----Original Message-----
From: Holland, Michelle [mailto:Michelle.Holland@Cognos.COM]
Sent: Saturday, 10 November 2001 03:07
To: 'Martijn Nabben (INL)'; 'powerh-l@lists.swau.edu'
Subject: RE: 'Y' in defined item name


It's not a southern hemisphere thing - other than noone in the northern
hemisphere seems to have reported the problem before.  It looks like it is
fixed in PH 8.00C & later (correct me if I am wrong, I just did a quick test
in a couple of versions).  In the 7.10G versions, use NONULLSEPARATOR on
your define to get around the problem:

	def aby date format ddmmyy NONULLSEPARATOR = sysdate

this seems to do the trick.


Michelle Holland
Cognos Customer Support
Michelle.Holland@Cognos.com


-----Original Message-----
From: Martijn Nabben (INL) [mailto:Martijn.Nabben@inl.co.nz]
Sent: Thursday, November 08, 2001 10:50 PM
To: 'powerh-l@lists.swau.edu'
Cc: Lynley Smith (INL)
Subject: 'Y' in defined item name


Here's a very straight-forward Quiz program:

> cancel clear
> access <file>
>
> define ybcde date format ddmmyy = PERM-START-DATE 
> define aycde date format ddmmyy = PERM-START-DATE 
> define abyde date format ddmmyy = PERM-START-DATE 
> define abcye date format ddmmyy = PERM-START-DATE 
> define abcdy date format ddmmyy = PERM-START-DATE 
>
> report ybcde &
>        aycde &
>        abyde &
>        abcye &
>        abcdy
> go

And here's the output:
    YBCDE     AYCDE     ABYDE     ABCYE     ABCDY

  01/05/60  01/05/60  010560    01/05/60  01/05/60
  27/05/60  27/05/60  270560    27/05/60  27/05/60
  27/05/60  27/05/60  270560    27/05/60  27/05/60
  27/05/60  27/05/60  270560    27/05/60  27/05/60
  27/05/60  27/05/60  270560    27/05/60  27/05/60

My query: EVERY TIME when the character "Y" is in THIRD position of a
DEFINEd item name, the date SEPARATOR is not printed. Why is that?

Cheers,
Martijn Nabben
Analyst/Programmer, INL IT
Wellington, New Zealand
PowerHouse 4GL Quiz version 7.10.G on VAX/OpenVMS V7.1


= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.swau.edu
Subscribe: "subscribe" in message body to powerh-l-request@lists.swau.edu
Unsubscribe: "unsubscribe" in message body to
powerh-l-request@lists.swau.edu
http://lists.swau.edu/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.

This message may contain privileged and/or confidential information.  If you
have received this e-mail in error or are not the intended recipient, you
may not use, copy, disseminate, or distribute it; do not open any
attachments, delete it immediately from your system and notify the sender by
e-mail promptly that you have done so.  Thank You.