FWIW
I have used Oracle Views before with great success.
James
To: James A. Wilson@ANDERSEN WO
cc:
[email protected] Date: 04/24/2002 02:47 PM
Sent by: Subject: Re: Oracle View
[email protected]
Message Mailed On Behalf Of --->
[email protected]
Please respond to jdelist
Thanks Adrian:
I had tried this process previously wihout any success.
OW would never see the ojects.
This time, I tried it using SqlServer 2000 as a test.
Everything worked as expected except, since I created the underlying table
and view from SS's Enterprise Manager (first), it created them with an
owner of "dbo".
Once I changed SS object owners to match the OW Database Data Source's
userid, everything worked.
..Create the object in SS, create the spec in OW, set-up the OCM, and
presto... OW thinks its a table when it really a view. No generation in OW
needed at all (except for business views).
Thanks for your help.
..now on to Oracle and the "real' view I'm trying to access.
--------------------------
http://www.jdelist.com/ubb/showthreaded.php?Cat=&Board=OW&Number=33367
+ - - - - - - - - - - - - - - - - - - - - - - - -+
This is the JDEList One World® / XE mailing list / forum.
Archives and information on how to SUBSCRIBE, and
UNSUBSCRIBE can be found on the JDEList Forum at
http://www.JDEList.com
JDEList is not affiliated with JDEdwards®
+ - - - - - - - - - - - - - - - - - - - - - - - -+