Help with a field name that conflicts with a function name
Ronald W. Olenic
olenicr@dteenergy.com
Tue, 14 Mar 2000 15:44:43 -0500
This is a multi-part message in MIME format.
--------------848F7AAF81E389C8B2E7C02C
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Hi Kim!
What data type is REV?
I had the following results on Unix
Q U I Z (PowerHouse 8.13.D1)
Copyright 1999 COGNOS INCORPORATED
Licensed PH8-UNIX-DEVELOPMENT for customer: 5019940001 DETROIT EDISON
UNIX
define REV = 1
*W* Data name REV may conflict with the keyword REVERSE.
define x = REV
...
define REV = 1
define x CHAR * 2 = REV
^
*E* Expected: (
^
*E* Expected: ( CENTRE CENTER REVERSE DOWNSHIFT GETSYSTEMVAL
LINKVALUE
LEFT LJ PACK ATTRIBUTE SUBSTITUTE RIGHT RJ SPREAD TRUNCATE
UPSHIFT ZEROFILL DECRYPT ENCRYPT SOUNDEX ASCII CONTENTS
<string>
MISSING NULL CHARACTERS LOGONID PORTID SYSNAME SIGNONUSER
UIC
<qualifier> <item>
Ron Olenic
The opinions expressed are my own. The lease expires in 5 weeks and
then I can trade up from quiet insecurity to full blown arrogance!!
Kim Williams wrote:
>
> I am using Quiz 8.19c4 on MPE version 5.5.
>
> I have a database with a field named REV. This conflicts with a function name in Quiz. How can I convince Quiz to let me put this on the right side of a select or define statement?
>
> (I don't want to rename the field in my dictionary.)
>
> Thanks for any help.
>
> Q U I Z (PowerHouse 8.19.C4)
> Copyright 1999 COGNOS INCORPORATED
> Ultratech Stepper
>
> > ACCESS IM
> > DEFINE X CHAR*2 = REV
> ^
> *E* Expected: (
> ^
> *E* Expected: ( CENTRE CENTER REVERSE DOWNSHIFT GETSYSTEMVAL LINKVALUE
> LEFT LJ PACK ATTRIBUTE SUBSTITUTE RIGHT RJ SPREAD TRUNCATE
> UPSHIFT ZEROFILL DECRYPT ENCRYPT SOUNDEX ASCII CONTENTS <string>
> MISSING NULL CHARACTERS LOGONID PORTID SYSNAME SIGNONUSER
> SIGNONGROUP SIGNONACCOUNT <qualifier> <item>
> >
>
> > ACCESS IM
> > REPORT REV
> > GO
>
> REV LVL
>
> 00
> 01
> --
> 01
> 01
> --
>
> Kim Williams
> Business Applications Manager
> phone: (408) 325-6484
> kwilliams@corp.ultratech.com
> Ultratech Stepper
> !
!
!
> !
> !
>
>
> = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> 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.
--------------848F7AAF81E389C8B2E7C02C
Content-Type: text/x-vcard; charset=us-ascii;
name="olenicr.vcf"
Content-Transfer-Encoding: 7bit
Content-Description: Card for Ronald W. Olenic
Content-Disposition: attachment;
filename="olenicr.vcf"
begin:vcard
n:Olenic;Ronald
x-mozilla-html:TRUE
org:Compuware
adr:;;;;;;
version:2.1
email;internet:ronolenic@bigfoot.com
title:Senior Systems Analyst
note;quoted-printable:The opinions expressed are my own, and as such are subject to change or even complete reversal without notice=0D=0A
fn:Ronald Olenic
end:vcard
--------------848F7AAF81E389C8B2E7C02C--
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
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.