can files be created from views

Analytics

can files be created from views

1.can we create files using views in teradata? if yes how?

2. can we merge two views to create a third view?
3 REPLIES
Fan

Re: can files be created from views

1. What do you mean by Creating Files from View. If you mean exporting results, then yes we can.

2.Yes we can merge two views to create a third view. like this EXAMPLE:

REPLACE VIEW DATABASE.VIEW3 AS
sel a.ACOL1
,a.ACOL2
,b.BCOL1
FROM DATABASE.VIEW1 a
JOIN
DATABASE.VIEW2 b
ON a.ACOL = b.BCOL
Enthusiast

Re: can files be created from views

Hi,
Files can not be created from views. For file creation use BTEQ or
fast export.

Regds,
sachin
Enthusiast

Re: can files be created from views

I believe you could have 64 joins that TD RDBMS can perform (I have never seen anything above 10).
That means you could potentially have 64 views used in a view DDL.

Thanks,
Vinay Bagare