insert system date in quiz query

[Edis, Bob]

Scott

What about creating a view in the database and reading that as a table?  In
the view you could get the system date but it would be seem by PowerHouse as
just another table column.

E.g. 
in Oracle
CREATE VIEW v_myview AS 
SELECT portfolio, sysdate AS curdate FROM pf_secs

in PowerHouse
SQL DECLARE sec_pos CURSOR FOR &
  SELECT portfolio, curdate FROM v_myview

Regards,
Blue

-----Original Message-----
From: scott wagler
To: powerh-l@lists.swau.edu
Sent: 9/25/2002 2:20 PM
Subject: RE: insert system date in quiz query


hi blue,

i'm on SunOS 5.7 , PH 8.13.D1, and querying an Oracle database.  i've
tried 
some database functions and havent been having luck with them either.

scott.

----Original Message Follows----
From: "Edis, Bob" <BEdis@usbnc.org>
To: "'powerh-l@lists.swau.edu'" <powerh-l@lists.swau.edu>
Subject: RE: insert system date in quiz query
Date: Wed, 25 Sep 2002 12:05:06 -0500

G'day Scott

You don't say what environment you are working in, and that would be
helpfull.

I will assume you are reading the data from a RDBMS.  In that case you
will
probably have to use the appropriate database function to return the
system
date rather than use the PowerHouse system date syntax.

E.g. (if souce is MS SQL Server)

SELECT portfolio, getdate() FROM pf_secs

Regards,
Blue

-----Original Message-----
From: scott wagler
To: powerh-l@lists.swau.edu
Sent: 9/25/2002 10:20 AM
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.

= = = = = = = = = = = = = = = = = = = = = = = = = = = =
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.




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


_________________________________________________________________
MSN Photos is the easiest way to share and print your photos: 
http://photos.msn.com/support/worldwide.aspx


= = = = = = = = = = = = = = = = = = = = = = = = = = = =
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.