insert system date in quiz query

[Darren Reely]

The problem is Powerhouse does not allow you to pass special RDBMS items 
through the cursor to the database engine.  If it matters, I'm on 
Solaris 2.6 (SunOS 5.6) , PH 8.13.D1, and Oracle 7.3.4.4.

I'd like to use the DECODE() function in Oracle, but get the following 
error.
DMS-E-RGE_BIFNA, Builtin function DECODE is not available.

Scott would like to use the SYSDATE function in Oracle but receives the 
following error.
DMS-E-RBI_COLUMN, Column SYSDATE was not found.

The use of cursors in Powerhouse is limited, though still useful at times.

Darren


Edis, Bob wrote:

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