insert system date in quiz query

[scott wagler]

hi christina,

i've tried that and all i get is the string SYSDATE returned in each record.

scott


----Original Message Follows----
From: "Hasse, Christina" <Christina.Hasse@COGNOS.com>
To: 'scott wagler' <stonecold99@hotmail.com>
CC: "'powerh-l@lists.swau.edu'" <powerh-l@lists.swau.edu>
Subject: RE: insert system date in quiz query
Date: Wed, 25 Sep 2002 11:26:21 -0400

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.




"and i'm a man who loves to play with boys"
-- kurt angle


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