show view this is showing some what diffent

Database
Enthusiast

show view this is showing some what diffent

show view ODS_OHR_REP_SOURCE_RECV.HR_PRT_PERSN_EDHR_D_V;

*** Text of DDL statement returned.
*** Total elapsed time was 1 second.

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
REPLACE VIEW ODS_OHR_REP_SOURCE.HR_PRT_PERSN_EDHR_D_V_BKP (
PRT_PERSN_IDN,
PRT_PERSN_TYP_IDN,
PRT_CUST_IDN,
GEO_ADDR_IDN,
PERSN_ID,
PERSN_NBR,
FST_NAM,
MID_NAM,
LST_NAM,
FULL_NAM,
PERSN_NAM_RANGE,
SRC_IDN,
SRC_CRETN_IDN,
SRC_UPD_IDN
)
AS
SELECT
PRT_PERSN_IDN,
PRT_PERSN_TYP_IDN,
PRT_CUST_IDN,
GEO_ADDR_IDN,
PERSN_ID,
PERSN_NBR,
FST_NAM,
MID_NAM,
LST_NAM,
FULL_NAM,
PERSN_NAM_RANGE,
SRC_IDN,
SRC_CRETN_IDN,
SRC_UPD_IDN
FROM ODS_OHR_REP.HR_PRT_PERSN_D;

6 REPLIES
Enthusiast

Re: show view this is showing some what diffent

show view ODS_OHR_REP_SOURCE_RECV*

it is showing

REPLACE VIEW ODS_OHR_REP_SOURCE*

may i know why is it showing like this
WAQ
Enthusiast

Re: show view this is showing some what diffent

What is the difference? What are you expecting from SHOW VIEW statement?
Teradata Employee

Re: show view this is showing some what diffent

Most likely ARC COPY with FROM option was used to restore the database and/or view with another name. But that only changes the "external" name not the definition; and for views, SHOW returns the original DDL.
Enthusiast

Re: show view this is showing some what diffent

hi WAQ
their difference in database name
in show iam giving ODS_OHR_REP_SOURCE_RECV*
--------

but in output it is showing ODS_OHR_REP_SOURCE*
Junior Contributor

Re: show view this is showing some what diffent

Did you check what Fred wrote?
There should be some info in dbc.eventsV about that COPY.

Is the view actually working?
Try a
show QUALIFIED view ODS_OHR_REP_SOURCE_RECV.HR_PRT_PERSN_EDHR_D_V;
to see the actual source code used internally.

Dieter
Enthusiast

Re: show view this is showing some what diffent

ya but it is not ARC COPY?