Possible 'undocumented' feature in QUIZ
Deskin, Bob
Bob.Deskin@Cognos.COM
Tue, 9 Jan 2001 13:10:40 -0500
I don't know why this happens. I was playing around with this and found that
it only happened when a dictionary is specified. The default sysdate if you
have no dictionary is century excluded with a format of YYMMDD. I then
tested with a dictionary with century excluded (I had one lying around from
Y2K testing - remember that?) and everything worked. With a dictionary with
century included, I get what you get.
If the sysdate value was binary zeros (null), then QUIZ would show the
results we're seeing. Why that would be I don't know. Does this happen with
any other report widths?
Bob Deskin
PowerHouse Web Product Manager and Senior Product Advisor
Application Development Tools, Cognos Inc.
bob.deskin@cognos.com (613) 738-1338 ext 7268 FAX: (613) 727-1178
3755 Riverside Drive P.O. Box 9707 Stn. T, Ottawa ON K1G 4K9 CANADA
-----Original Message-----
From: Pickering, John (NORBORD) [mailto:PICKERIJ@norbord.com]
Sent: January 9, 2001 12:07 PM
To: 'Karman, Al'; powerh-l@sphere.swau.edu
Subject: RE: Possible 'undocumented' feature in QUIZ
Al
You're right - it does behave rather curiously!
With this code and 8.19.C4 I get the same result -- a "2" in column 161.
> :file temp1;temp
> :purge temp1,temp
> set report device disc name temp1
> set page width 169 length 1
> set nohead
> report &
> tab 1 "Text" &
> tab 161 sysdate pic "^^^^^^^^" &
> tab 169 "2"
>
But if I change the page length from 1 to 2 I get what I expect - i.e. the 8
digit yyyymmdd in 161/168 and a "2" in 169. Adding 'set report spacing 0'
makes no difference.
Sorry - no explanation from me. I'll leave that to @.Cognos.
Do you really need a 169 byte record length? Besides my natural aversion to
odd length records in both MPE and PH I'd prefer a little slack at the end
of each record. All is fine with a record length of 170 :-)
Regards,
JWP
> -----Original Message-----
> From: Karman, Al [SMTP:AKarman@USFreightways.com]
> Sent: Thursday, January 04, 2001 1:45 PM
> To: powerh-l@sphere.swau.edu
> Subject: Possible 'undocumented' feature in QUIZ
>
> Greetings to the list.....
>
> I came across something interesting and am curious if others have had the
> same experience.
>
> In QUIZ (PH8.29D) on my trusty HP 3000 937/LX running MPE/iX 6.0 pp0....
> (Oh Yeah, I'm Running For Power Patches Right Now....!)
>
> I SET REP DEV DISK, and SET PAGE WIDTH 169.
>
> When I try to REPORT .....TAB 161 SYSDATE PIC '^^^^^^^^' &
> TAB 169 '1'
>
> My record[161:9] = '2 '
>
> => YET <=
>
> When I SET PAGE WIDTH 170
> My record[161:9] = '200101041'
>
> I welcome any information on this....
>
> Thanks In Advance!
>
> Al Karman
>
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
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.