#DateForumTypeThreadPost
624 Nov 2009 @ 11:07 PSTToolsReplyCan I rollback in ANSI mode without Transient Journel?Hi"What exactly I'm looking at is...is there any alternative method to perform ROLLBACK operation if transient Journels are not taken on target table... "In Teradata, Transient Journal is not optio...
524 Nov 2009 @ 04:21 PSTToolsReplyany one plz give me brief explain about this errorCan you post the actual error message you are getting...
420 Nov 2009 @ 12:04 PSTToolsReplyList of views created on a tableThanks Arun KumarThis one helped me... :)For other users... the exact answer would be..SELECT TableNameFROM DBC.TablesWHERE Tablekind = 'V'AND requestText LIKE '%The table name%'GROUP BY 1ORDER BY ...
318 Nov 2009 @ 02:31 PSTToolsTopicList of views created on a tableHiI would like to the list of view names that are created on a particular table.For example, there are 2 views view1 and view2 that are created on a table Table1. Is there any query by which i can ...
214 Apr 2009 @ 04:09 PDTDatabaseReplyvariable in a SAMPLE clause in a stored procedureHiCan I get the exact CREATE PROCEDURE statement you entered.Because stored procedures accept variables.for example,creat procedure input_variables(IN variable1 INTEGER)beginupdate table_1 set sala...
114 Apr 2009 @ 03:51 PDTDatabaseReplyHow do we find the typical/average space occupied by column on disk?May be you can try this functionselect avg(character(trim(column_a))) from table_name;Though the column_a here is a VARCHAR type, character(trim(column_a) gives the exact length it occupies.