Hi Jeremy,
What version of Cognos are you using?
Is there an error message shown?
I just tried it with CA 11.1.3 and it seems to work fine as a NativeSQL statement, both in FM and Data Module UI
Select startup_time from V$INSTANCE
returns:
Aug 8, 2019 2:18:10 PM
//Henk
------------------------------
HENK CAZEMIER
------------------------------
Original Message:
Sent: Fri August 23, 2019 01:59 PM
From: Jeremy Aude
Subject: Query Oracle System Object
Hi all,
I would like to query our Oracle instance for the time the instance was started. The SQL string I use in SQL Developer is simple: select startup_time from V$INSTANCE
I'm not able to run the same query in FM, even using native SQL. I figure it has to do with the special character but not sure how to get it working. Perhaps needs some macro syntax?
Thanks for the help.
------------------------------
Jeremy Aude
Channell Commercial Corporation
Rockwall TX
------------------------------
#CognosAnalyticswithWatson