I have a table T204 and the AR SYSTEM automatically creates a view on top of it
called "TEIS_SURVEY_TEXT"
I need to create a view and need to know the ramifications of creating a view
of a view.
I could create my view like this:
CREATE OR REPLACE VIEW "ARADMIN"."TYCO_ADR_SURVEY_TYPE_V" ("REQUEST_ID",
"STATUS", "LANGUAGE") AS
SELECT REQUEST_ID , STATUS, LANGUAGE
FROM TEIS_SURVEY_TEXT;
Which would be a view of a view.
Or should I create it like this:
CREATE OR REPLACE VIEW "ARADMIN"."TYCO_ADR_TEIS_TYPE_V" ("REQUEST_ID",
"STATUS", "LANGUAGE") AS
SELECT T204.C1,C8,C536870918
FROM T204;
What are everyone's thoughts?
Lisa Kemes
AR System Developer
Tyco Electronics
717-810-2408 tel
717-602-9460 cell
[email protected]
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
