![]() |
Hi,
10 Feb 2015
,
|
![]() |
I am looking for a way to quickly retrieve all macro, view and stored procedure text. People on this thread have already recommended using the show procedure/view/marcro commands, but that would require calling everything sequentially.
02 Mar 2012
| 1 comment
,
|
![]() |
Hi, Does Teradata make use of "Query Caching" for the fast retrieval of tactical query results? If so, which tables in the data dictionary are used for this purpose? What are the pros and cons of making use of this concept in data warehouse?
04 Dec 2011
| 2 comments
,
|
![]() |
Hi All I would like to find out the dependency between Stored procedures and the associated tables using data dictionary tables. I have tried my best to find out but went in vain. Please suggest me a way to find out using teradata only.
03 Nov 2011
| 1 comment
,
|
![]() |
I have the following SQL to create a view REPLACE VIEW PRSN_GLOBAL_V.LSS_PRD_RSN
19 Jan 2011
| 5 comments
,
|
![]() |
I’ve mentioned it before, Marcio has blogged about it, customers have brought it up at the Partners Conferences. It’s cheap, fast, risk-free, with immediate results. But some of you are still not getting it. Or it could be you’re one of the few who truly don’t need it.
24 May 2010
| 22 comments
,
|
![]() |
Hi all, I am the author of a documentation tool for all major DBMS on the market, and I recently added support for Teradata. I have tried it on the sample dbs that Teradata 13 ships with, as well as the system catalog itself (DBC). What I'd really like though are some beta testers to run it against some real world databases. The tool is called SqlSpec. You give it a connection string to your database, and it generates comprehensive documentation for your db, with PK/FK graphs, dependency graphs, and lots more.
18 May 2010
,
|