#DateForumTypeThreadPost
1130 Jan 2009 @ 12:19 PSTDatabaseReplyRevoking All Access Rights For UsersThere's no such stmt. An alternative: drop user; then recreate the user.
1016 Jan 2009 @ 01:44 PSTDatabaseReplySQL error code 3807 when inserting data into a newly created tableTry to qualify with the databasename
914 Jan 2009 @ 03:13 PSTDatabaseReplySelecting multiple rows using Stored ProcYes, DYNAMIC RESULT SETS is a new feature in TD12.
812 Jan 2009 @ 12:51 PSTToolsReplyLoading multiple tables with Fastload only logging in onceOne of Fastload's restrictions is that it Only loads 1 empty table with 1 FastLoad job. Also, it does not support .RUN
712 Jan 2009 @ 12:37 PSTToolsReplyImport/Export in BTEQ Interactive modeYes, syntax is the same.
618 Jan 2008 @ 08:35 PSTToolsReplyregarding MLOADDepending on the size of the target table, the activities happen in the system, the transactions/jobs that affect the target table, and priority of the requested load job, those default parameters ...
516 Jan 2008 @ 05:21 PSTTrainingReplyits possibleYes, associate each lable with each file.
414 Jan 2008 @ 03:51 PSTToolsReplyCollect Stats on Join Index.Yes.--Collecting stats on column f1 of ji:collect stats on test.ji column f1;--Collecting stats on ji:collect stats on test.ji;
314 Jan 2008 @ 03:38 PSTDatabaseReplyHow do we find the data dictionary tables and views in Teradata?--For Views:select TableName from Dbc.TablesV where DataBaseName='Dbc' and TableKind='V' order by 1;--For tables:select TableName from Dbc.TablesV where DataBaseName='Dbc' and TableKind='T' order b...
214 Jan 2008 @ 03:19 PSTDatabaseReplyAMP DownThis is a design consideration: data protection vs performance.
109 Jan 2008 @ 04:16 PSTToolsReplyReconfiguration program (a Teradata Database support utility)Additional comment:Reconfiguration is the second step of the configuration and reconfiguration process. One needs to modify or redefine the current configuration of the system via the configuratio...