All forum activity

#DateUserForumTypeThreadPost
5791621 Jun 2016 @ 12:01 PDTau185006Teradata Database on VMWareReplyConfused over which VM to downloadCommunity edition is available for download at http://downloads.teradata.com/download/database/teradata-virtual-machine-community-edition-for-vmware
5791521 Jun 2016 @ 11:26 PDTsrivigneshknToolsTopicTPT RestartabilityHi,    I would like to know if there is a way in which i can disable TPT restartability, each time TPT executes i would like to run it from the beginning and it should not restart from ...
5791421 Jun 2016 @ 11:25 PDTToddMcCDatabaseReply9804: Response Row Size/Constant Row Size overflowI received this error after installing Teradata SQL Assistance 15.0.  My Connection is "Teradata.Net".  I fixed the problem by changing the connection settings as follows: ...
5791321 Jun 2016 @ 11:07 PDTshiboo18AsterTopicERROR: SQL-MR function TEXT_PARSER failed: Loading stop word file /stopwords_en.txt failed.Hi guys,   I am new to Aster. Only like 3 weeks into it. I am using TEXT_Parser analytic function. I want to use my own stop word file. I have loaded the file from my local into AFS using ...
5791221 Jun 2016 @ 10:38 PDTfgrimmerTeradata StudioReplyTeradata Studio does not show all of my authorized tables-Mitch, Some areas that may affect the tables list: Have you changed the Teradata Datatools Preference to use VX views to load the tables lists? Are you using the cache option on your database where...
5791121 Jun 2016 @ 10:35 PDTNetFxConnectivityReplypython / odbc connection to TDWindows or Linux? This might help: http://developer.teradata.com/blog/odbcteam/2016/02/python-with-teradata-odbc  
5791021 Jun 2016 @ 10:28 PDTNetFxConnectivityReplyCommand line installation for ODBC Driver for Windows 15.00.00.00http://www.info.teradata.com/templates/eSrchResults.cfm?prodline=&txtpid=&txtrelno=&txtttlkywrd=TTU15.10.04&rdsort=Title&srtord=Asc&wNew=True&nm=Teradata+Tools+and+Utili...
5790921 Jun 2016 @ 10:13 PDTmikeyb100Teradata StudioTopicIssue Downloading Studio even After Java installedI'm on a mac OS X Yosemite version 10.10.5. I've been trying to download the mac version of studio express and it prompts me to download Java 1.7 or later. So I do, then install it, test it...
5790821 Jun 2016 @ 09:23 PDTfeinholzToolsReplyTPT API C program usage64K.
5790721 Jun 2016 @ 08:31 PDTamoyyangDatabaseReplycreate mutiple tables from an existing table with while loopHave not got any follow up! As an alternative, if possible, can some one guide me to textbooks or references that can help resolve this issue! Thanks a lot!
5790621 Jun 2016 @ 08:15 PDTSunny445DatabaseTopicBteq-import- Error Handling Not working Hi, i have a bteq which uses repeat function to load a file into a table. we have a parameter for the input file. if the parameter is not available, the script is failing with a Return code 0, i...
5790521 Jun 2016 @ 07:46 PDTpushkarcseDatabaseTopicCOLUMNAR TABLE- SELECT TOP N* FROM COLUMNAR TABLE NOT GIVING OUTPUTHi, I am facing one issue with the columnar table. I am unable to fetch records using TOP N* command from a columnar table with 256 columns. SELECT TOP 10* FROM COLUMNAR TABLE --Return...
5790421 Jun 2016 @ 07:18 PDTplentyfishToolsReplyTPT Load Operator error table being loaded?Hello, is there a way I can identify tables in load pending state?
5790321 Jun 2016 @ 07:03 PDTplentyfishDatabaseReplyTeradata 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
5790221 Jun 2016 @ 06:38 PDTtomnolanDatabaseReplyTeradata Table Naming select databasename,tablename from dbc.tablesv where characters(tablename) > 30;  
5790121 Jun 2016 @ 06:31 PDTplentyfishDatabaseReplyTeradata Table Naming Hi all, whats the SQL to find list of table names longer than 30 characters?
5790021 Jun 2016 @ 05:46 PDTstami27ToolsReplyTPT Work/error Tables always protected (FALLBACK) ? CREATE SET TABLE dbp_etl_log.frprg_t16e3a6294b63ea1fb21_L ,FALLBACK ,      NO BEFORE JOURNAL,      NO AFTER JOURNAL,      CHECKSUM =...
5789921 Jun 2016 @ 05:35 PDTstami27ToolsTopicTPT Work/error Tables always protected (FALLBACK) ?Hi, can anyone tell me if I can affect on tptstream that the work or error  tables could be created as NO FALLBACK? Currently in the version tptstream1500 (15.00.00.04-1) the work tables a...
5789821 Jun 2016 @ 04:50 PDTJok3rGeneralTopicRetrieve columns having a specific valueHi, I have 100+ columns. I need to retreive columns having a specific value [Say 'ABC'] in any of the rows.  Please help. 
5789721 Jun 2016 @ 04:43 PDTaklopisDatabaseReplyError handling from DBC.SysExecSQL in my own procedureHi Dieter. I can't drop the database first. I tried that but the procedure is used by many users and sometimes the user don't have access to drop the database. That's why the better so...
5789621 Jun 2016 @ 02:10 PDTarchana_2016ToolsReplyTPT API C program usageHi Steve, As you have mentioned in the above comments, Using GetBuffer we can retrieve 64K buffer of rows. what is the maximum buffer of rows that can be retrieved? Thanks.
5789521 Jun 2016 @ 12:46 PDTjohnpaulDatabaseReplyLOBs are not allowed to be hashed issue in Recursive queryHi Harshit, This was a limitation. we dropped proceeding after this issue.    Regards, John
5789420 Jun 2016 @ 11:57 PDTdnoethGeneralReplyAssign values based on dates by groupFor each groupid? case datecol when min(datecol) over (partition by groupid) then 'initial' when max(datecol) over (partition by groupid) then 'recent' else 'inte...
5789320 Jun 2016 @ 11:54 PDTdnoethUDAReplyHow to create a Macro passing table names as the parameterhttp://www.info.teradata.com/HTMLPubs/DB_TTU_15_10/SQL_Reference/B035_1148_151K/ch03.108.114.html#ww11214369   Of course you should always be aware of possible SQL Injection: https://en.wik...
5789220 Jun 2016 @ 11:40 PDTPriti_KanalUDAReplyHow to create a Macro passing table names as the parameterHi Dieter, I am having requirement where I want to use database_name and table_name as parameterized in stored procedure. In procedure I will be performing below DML operations :   INSERT ...

Pages