#DateForumTypeThreadPost
1621 Jun 2016 @ 07:18 PDTToolsReplyTPT Load Operator error table being loaded?Hello, is there a way I can identify tables in load pending state?
1521 Jun 2016 @ 07:03 PDTDatabaseReplyTeradata Table Naming Thanks Tom. I also just found the "length" function usefull about doing a bit of googling. sel * from dbc.tablesv where length(tablename) > 30
1421 Jun 2016 @ 06:31 PDTDatabaseReplyTeradata Table Naming Hi all, whats the SQL to find list of table names longer than 30 characters?
1303 Mar 2014 @ 08:44 PSTToolsTopicTPT_INFRA: TPT03586: Warning: the rightmost 63990 characters (bytes) of the values of column Col1 will be truncated on aHi, can anyone help with this issue. User's job is failing with the following warnings. TPT_INFRA: TPT03586: Warning: the rightmost 63990 characters (bytes) of the values of column Col1 will b...
1221 Nov 2012 @ 07:21 PSTDatabaseTopicAltering a table to extend partition range fails with error 3732Hi, I'm getting following error when I run alter table statement to add/extend partition range: 3732: The facility of altering the partitioning of a non-empty table by adding/droppin...
1108 Nov 2012 @ 09:24 PSTTeradata ApplicationsReplyExperience of TRSHi Gut - have you got an update on the designs for bulk deletes and updates? Thanks in advance 
1016 Jun 2011 @ 07:34 PDTDatabaseReplyGrant one or more roles to one or more users using shell script that calls bteqIt interprets it as one input, i.e. "user1 user2". But entering just user1 works.
915 Jun 2011 @ 08:50 PDTDatabaseTopicGrant one or more roles to one or more users using shell script that calls bteqHi Folks, I have the following piece of code for granting 1 or more roles to 1 or more users. The code(function) below works for 1 user but I find it difficult to get it working when specifyin m...
818 Jan 2011 @ 07:53 PSTDatabaseReplyI’m wanting to subtract days from date fieldsCarlos, That seems to hv done the trick - thanks a lot.
718 Jan 2011 @ 04:15 PSTDatabaseReplyI’m wanting to subtract days from date fieldsOn the last comment, meant to say even tried to change the where clause to..."and (current_date - logdate)
618 Jan 2011 @ 03:55 PSTDatabaseTopicI’m wanting to subtract days from date fieldsHi folks, I have the below query that I'm tryin to run via BTEQ but it fails with following error: Failure 5407 Invalid operation on an ANSI Datetime or Interval value. Statem...
505 Oct 2010 @ 01:24 PDTToolsReply<Internal Session> blocking users and causing deadlockWe had the same problem beginning of the year, and Teradata support created a patch for us. We r also in v 12. So other than getting the patch, you'll still experience the problem. I'm suprised ...
420 May 2010 @ 03:27 PDTCloud ComputingReplyCreating a user through EMB portlet (in Viewpoint) errors with space issueAfter much investigation, identified that the issue was down to DB_Sandbox_Admin requiring "select" access on DBC tables. Though the user gets created on Teradata, a window pops up when clicking ok...
318 May 2010 @ 06:47 PDTCloud ComputingTopicCreating a user through EMB portlet (in Viewpoint) errors with space issueHi, I have installed Elastic Marts Builder and added the Portlet to my viewpoint desktop, but when I try to create a user through EMB portlet (in Viewpoint), I get error "Not Enough Space Availa...
218 May 2010 @ 06:32 PDTCloud ComputingReplySetting up Elastic Marts Builder to access different TD databaseThanks for the reply - so I am clear on what you saying... you mean will have to install separate EMB for each user >
114 May 2010 @ 05:01 PDTCloud ComputingTopicSetting up Elastic Marts Builder to access different TD databaseHi all, I'm installing Elastic Marts Builder (EMB) - but as per installation guide, it seems you can only assign it to one Teradata database. Is there a way I can set it up so users can create ...