This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C264B1.932500E0 Content-Type: text/plain; charset="iso-8859-1" Christina, I think you'll find that you can only select columns that exist in a table. The only time you can use SYSDATE is in the where clause. What are you doing that requires SYSDATE inserted on each input row? regards, Robert W.Mills Systems Development Manager Windsong Services (01689) 870622 x3005 scott wagler wrote: > 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 > > > = = = = = = = = = = = = = = = = = = = = = = = = = = = = > 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. ------_=_NextPart_001_01C264B1.932500E0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">RE: insert system date in quiz query Christina,
I think you'll find that you can only select columns = that exist in a table. The only time you can use SYSDATE is in the = where clause.
What are you doing that requires SYSDATE inserted on = each input row?
regards,
Robert W.Mills
Systems Development Manager
Windsong Services
(01689) 870622 x3005
scott wagler wrote:
------_=_NextPart_001_01C264B1.932500E0--
> 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
>
>
> =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D = =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D
> 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
>
>
> =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D = =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D
> 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.