#DateForumTypeThreadPost
3421 Aug 2015 @ 01:14 PDTTeradata StudioTopicSQL History Import ErrorI'm trying to import my SQL Assistant (.mdb) history and am receiving an error immediately after choosing the file: [Microsoft].[ODBC Driver Manager] Data source name not found and no default...
3301 Aug 2014 @ 12:36 PDTDatabaseReplyError message with TPT FASTLOAD (Could Not Find Message Catalog opermsgs.cat)Got it by adding the following to our SAS startup scripts: export NLSPATH=/opt/teradata/client/14.10/tbuild/msg64/opermsgs.cat; It would not work without including the opermsgs.cat file.  ...
3201 Aug 2014 @ 06:24 PDTDatabaseReplyError message with TPT FASTLOAD (Could Not Find Message Catalog opermsgs.cat)I'm having a similar issue with SAS 9.2 and TTU 14.10.  TTU is installed on the server and all the tools work fine via command line, but we get the below error when trying to use TPT in SA...
3122 Apr 2014 @ 01:56 PDTToolsTopicTPT/Easy Loader delimiterDo TPT and Easy loader (13.10.00.02, moving to 14.10 later this year) support the use of ASCII control characters as delimiter? If so, how would x01 (Crtl A) be represented in the TPT script/t...
3011 Jun 2013 @ 10:06 PDTToolsReplyTDLOAD error RDBMS Warning: 6813 Numeric overflow in internal counters.Thanks Dieter, next time I will read what the message says rather than freaking out about a warning :)  Thanks again.
2911 Jun 2013 @ 06:36 PDTToolsTopicTDLOAD error RDBMS Warning: 6813 Numeric overflow in internal counters.Hi all, I'm currently testing TTU 14.00 and experienced an issue when using tdload to move a table (5.3b rows, 600gb) from one system to another.  Unfortunately, I'm not sure if the t...
2820 Jun 2012 @ 07:16 PDTDatabaseTopicA better way to pivoting a table? I was wondering if anyone knew of a better way to pivot a table perhaps using recursive sql.  I was able to pivot the table by using dbc.columns to create insert statements.  Any ...
2718 Apr 2012 @ 10:00 PDTToolsTopicInstalling TTU on Viewpoint server Does anyone know of any potential issues with installing TTU on our Viewpoint server?
2606 Dec 2011 @ 07:09 PSTDatabaseReplyMulti-Value compression has increased the table size Thanks Manik, I appreciate your response.
2501 Dec 2011 @ 06:35 PSTDatabaseReplyMulti-Value compression has increased the table size Does a limit exist for the number of charcters stored in the row header?  A user has DDL that fails (CREATE TABLE Failed. 5627:  Column 'VAR28' exceeds system limit f...
2404 Oct 2011 @ 01:56 PDTToolsReplyTPT SelectStmt Use two single quotes as follows: SelectStmt = 'SELECT ''GRANT'' ||rolename|| ''TO USERDAMIN WITH ADMIN OPTION;'' FROM dbc.roleinfo;'
2325 Aug 2011 @ 02:58 PDTConnectivityReplyODBC Client in UBUNTU I was able to get the TD tools running on Ubuntu but haven't had time to work on ODBC.  I used alien to convert the i386 and noarch rpms to deb files and installed, then used strac...
2225 Aug 2011 @ 02:50 PDTDatabaseReplyListing block level compressed tables Thanks Jim, appreciate the response.  It does indeed print the "#".  Here's the condensed output of:  scope table "db.tblnm" 0 > showblocks for a block ...
2119 Aug 2011 @ 05:59 PDTDatabaseReplytable size without indexesHi Dennis, Do you know the command to show all block level compressed tables or how to tell if a table is BLC'd in Ferrett? Thanks.
2018 Aug 2011 @ 12:04 PDTDatabaseTopicListing block level compressed tablesHi all, It's my understanding that the only way you can tell what tables are block level compressed is by using the Ferret utility. Is this true? Does anyone know the Ferret command to list tabl...
1911 Aug 2011 @ 03:32 PDTConnectivityReplyODBC Client in UBUNTUHas anyone gotten this working?
1811 Aug 2011 @ 02:38 PDTToolsReplyWindows versions of BTEQ, Fastload, etc. won't connect after upgradeGot it, if any of the following exist in c:\winnt\system32 after removing old versions of TTU remove them! localisation.dll tdusr32.dll terasso.dll wincli32.dll
1711 Aug 2011 @ 08:05 PDTToolsTopicWindows versions of BTEQ, Fastload, etc. won't connect after upgradeAfter upgrading to TTU 13.10 the TD windows tools won't connect to any database. I tried removing everything and re-installing which didn't help. I also upgraded to the most recent versions of IC...
1628 Jul 2011 @ 08:19 PDTConnectivityReplyName not in HOSTS file error - LinuxThanks for the response. Our DNS entries go in once per month and not for another two weeks. Will adding the cop entries to the servers hosts file serve as a short term fix? I've done this with ...
1526 Jul 2011 @ 10:45 PDTConnectivityTopicName not in HOSTS file error - Linux Hi all, I'm getting an error around names not being in the HOSTS file or names database when trying to connect to a Teradata system using BTEQ or SAS from Linux. This happens when I try to use ...
1412 Jul 2011 @ 12:45 PDTViewpointReplyViewpoint Alert vs. TDManagerThanks, for anyone interested, my issue was that CMIC needed to have network access to communicate with the SNMP server.
1330 Jun 2011 @ 12:37 PDTViewpointReplyViewpoint Alert vs. TDManagerHi, is it possible to send test alerts from SMWeb w/ alert subscriptions enabled? My snmp trap receiver doesn't seem to be getting any alerts or traffic from SMWeb. I've set the subscription to s...
1202 Jun 2011 @ 09:42 PDTDatabaseReplyObject access separationNice, so it's much easier that I thought. Thanks again Dieter.
1102 Jun 2011 @ 07:47 PDTDatabaseTopicObject access separationI need to create a database that gives users the ability to create and then edit/sel on only objects that they created. Users would only have access to objects they created unless another user gra...
1009 May 2011 @ 07:10 PDTDatabaseReplyBlock Level Compression on an existing tableGreat, thank you. Looks like I need to take a look at the ferret utility. Thanks again.

Pages