0 - 15 of 15 tags for views

Is there a way to get the SchemaLoader results?
The cmd prompt it opens closes immediately and I cant seem to pause it to read what it output. 
I cant tell what went wrong or what went right.
 
 
Also if there is an alternative way to get the views into the EDMX please let me know.

Hi Guys, thanks for reading the post. I did do a search for "view on view" and there was no result.

This presentation teaches you how to design effective semantic view layers on Teradata. After briefly explaining the mechanics of how the Teradata Parser processes views, it dissects a number of semantic view examples that have been successfully implemented in production environments to help you understand what works and what constructs are problematic. The emphasis is upon practical issues from understanding how to design a single view to design patterns appropriate for virtual star schemas.

Hi,
Can some one please tell me, between Volatile table and view, which is better in terms of efficiency, accessbility and use?
What is the difference between them??
Also, can I create a volatile table with same name but using different user ID?

Has anyone successfully Reverse Engineered Teradata Views using MS Visio 2010?
When I try "Reverse Engineering" the Views check box is grayed out and not selectable. Is there a dbc table or view I need additional rights to?
 

Hi,
I have the following tables EMPLOYEE& DEPT.
I am writing the following query :
 
validtime as of date '2001-01-01'
select *
from SANDBOX.TEMPORAL_EMPLOYEE AS EMP
join SANDBOX.TEMPORAL_DEPT as dept
on emp.dept_id=dept.dept_id;
 
 

Hi.

 

I have a problem.

I have a cursor with a select statement.

The select statement returns 5 rows.

Row 1-- Select col 1

Row 2 --,col2

Row3---,col3

Row4---,col4

Row5--- From table A;

 

Is it possible to put a common table expression within a view?

The following SQL works fine

WITH myCTE (account_number) AS
(
SELECT account_number
FROM dbname.tablename
WHERE columnname = 'somevalue'
)

SELECT account_number
FROM myCTE;

However when I try to put this into a view . . .

CREATE VIEW myCTE_VIEW AS
(

WITH myCTE (account_number) AS
(
SELECT account_number
FROM dbname.tablename
WHERE columnname = 'somevalue'
)

SELECT account_number
FROM myCTE

)

I have a recursive query that begins with the text "WITH RECURSIVE".

The query works fine. When I try to use the exact query within a view, while creating the view I receive an error that says "REPLACE VIEW Failed 6926: definitions, views, triggers or stored procedures". I simply prefix the query with this text: REPLACE VIEW DB.VIEW_NAME AS LOCKING ROW FOR ACCESS and I get the error.

I can successfullly get the recursive view created if I use this text instead: REPLACE RECURSIVE VIEW DB.VIEW_NAME, and if I also remove the syntax "WITH RECURSIVE".

The commonly known technique to pass parameters to SQL statements at the system or session level utilizes tables (permanent or global temporary tables).
In this blog post, I'll show better performing techniques for system and user level variables using views and QueryBanding.
These solutions are based on TD13, but can also be used pre-TD13, although performance might be worse.

One of the biggest benefits of Query Banding is the ability to pass parameters into an SQL script.

Establishing an associative security table lookup between a userid and allowable company codes may allow easy access to the base data tables.  

Hi All,

Is there a way to systematically refresh all Database Views? Is there some type of Bteq I can write, or something built into Teradata that will help me accomplish this?

Thanks!

Paul

Hi,

I am new to Terra Data. I have complex queries that are retrieving data from different tables and using different joins. Also, i have to apply some conditions to clean the duplicates and time period checks.

Hey,

Anyone know how to create a table using a view (Structure & Data)?

Also, is there anyway to retrieve the DDL for the tables or views we have access to?

Thanks,

-Ayyad

This book provides information about Teradata MultiLoad, a product that provides an efficient way to deal with batch maintenance of large databases. Teradata MultiLoad is a command-driven utility for fast, high-volume maintenance on multiple tables and views in a Teradata Database.