insert system date in quiz query

[Hasse, Christina]

Hi Scott,

Try using single quotes instead of double quotes.

Regards,

Christina Hasse
ADT North American Technical Manager
COGNOS CORPORATION
christina.hasse@cognos.com
425 N. Martingale Road, Suite 600
Schaumburg, IL  60173
Office:  847 - 285 - 2905
Cell:  847 - 612 - 6854


-----Original Message-----
From: scott wagler [mailto:stonecold99@hotmail.com]
Sent: Wednesday, September 25, 2002 11:21 AM
To: powerh-l@lists.swau.edu
Subject: insert system date in quiz query


hello everyone,

i am trying to add the system date as a column in a cursor in QUIZ.  i am 
trying a simple query that will have the date inserted into each record.  
since SYSDATE is a reserved word i was hoping i could just include it in 
double quotes.  here is what i've tried including the error:

>cancel clear
>sql declare sec_pos cursor for &
>select pf_secs.portfolio, "SYSDATE" from pf_secs
>access sec_pos
*E* Error parsing SQL statement.
DMS-E-GENERAL, A general exception has occurred during operation 'prepare
request'.
DMS-E-RBI_COLUMN, Column SYSDATE was not found.

any help here would be greatly appreciated, thanks.

scott.

_________________________________________________________________
Chat with friends online, try MSN Messenger: http://messenger.msn.com


= = = = = = = = = = = = = = = = = = = = = = = = = = = =
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
promptly by e-mail that you have done so.  Thank you.