#DateForumTypeThreadPost
5815 Dec 2015 @ 11:12 PSTTeradata StudioTopicData Transfer - Error 1298Hi, when i do a Data Transfer from Teradata System 1 to Teradata System 2, the data is transfered OK, but the Status is Failed. Any solution ? Regards. Dixxie    
5727 Apr 2015 @ 11:09 PDTToolsTopicTTU 14.10 Silent_uninstall return codeHi, I need to automate the installation of TTU 14.10 with silent_install.bat, but i can not capture the return code. Where the status code of the installation is ? Regards.
5628 Jan 2015 @ 10:57 PSTDatabaseReplyView refresh after collect statsNot, you can request the views or make selects from the tables at once. Regards.
5528 Jan 2015 @ 10:44 PSTDatabaseReplyDatabase space issuesFirst you must verify the DB space with this: Select Sum(MaxPerm) - Sum(CurrentPerm) From DBC.DiskSpace Where DatabaseName = 'xxx' Then calculate how many bytes are each row i...
5420 Jan 2015 @ 11:49 PSTGeneralReplyReg : Performance of Coalease in Select StatementHi varanasi, When you write : coalesce(coalesce(s.column2,default_varchar_value), w.column2) The inner coalesce return s.column2 if is not null or default_varchar_value, then never retur...
5318 Nov 2014 @ 10:50 PSTToolsReplyWhere I can find Teradata Tools and Utilites 14.10?If you are a TD Customer you can download them from https://tays.teradata.com/ Regards
5218 Nov 2014 @ 07:55 PSTDatabaseReplySkew Factor of small tablesHi Shardul, The rows always are distributed on the AMPs by the hash of the columns selected for the Primary Index. This is so regardless the table is SET or MULTISET. Regards.  
5118 Nov 2014 @ 07:03 PSTDatabaseReplyWhat is the meaning of this partionHi Sandeep, The +10 is the Time Zone You are defining two partitions, the equal to literal timestamp and all others distinct to the literal. Regards.
5018 Nov 2014 @ 06:44 PSTDatabaseReplyFallback optionSri, The records are storage in the AMPs by the hash of the columns selected for Primary Index, then the same PI = same AMP You no has independent access to the Fallback table, there i...
4918 Nov 2014 @ 06:33 PSTDatabaseReplyMacro default values for where statementsHi Keith, Try this, street and state are optionals: Ex. exec mailing_address('Franklin',)      exec mailing_address(,'CA')      ...
4818 Nov 2014 @ 05:16 PSTDatabaseReplyFallback optionSri, Fallback is an optional, and make one aditional copy of each row. You must remember that these records doubling with RAID 1. Space is not infinite. Regards.
4714 Oct 2014 @ 12:18 PDTConnectivityReplyTeradata Value Analyzer Connectivity Hi, First you must be sure that the login is successful, make a BTEQ and select a known, for example: Sel * From dbc.databases Then test the view with: Sel * From database.V9080_SOLN_AUTH_METHO...
4630 Sep 2014 @ 09:26 PDTDatabaseReplyDisable Updates on specific column.Hi engmalaa, You will Grant Update only on specific columns to a Role or User. GRANT UPDATE("Column_x") ON "Database_x"."Table_x" TO "x_ROLE" Regards...
4521 Aug 2014 @ 07:14 PDTConnectivityReplyodbc driver trace on windows.Hi ricky_ru, To start capturing an ODBC driver manager trace on Windows, first go into the ODBC Administrator, Tracing tab. Under the Log File Path, enter the path and file name you wish for your ...
4421 Aug 2014 @ 07:01 PDTDatabaseReplyLocking AccessHi Sarani, I think you should begin here : http://www.info.teradata.com/ Regards.  
4311 Jul 2014 @ 10:47 PDTDatabaseReplyAll AMP active for Updates based on primary indexAhemmad, The registers will be storaged at the AMP = hash(Column1 , Column2) Your query will update one or more registers (if you define the table as Multiset), but allways in the same...
4220 May 2014 @ 10:11 PDTDatabaseReplyProblem inserting byte dataAnyone can help ?
4116 May 2014 @ 11:22 PDTDatabaseTopicProblem inserting byte dataHi All, In TD 13.10, i need load data from hexa chars to another table in a byte column. CREATE SET TABLE SYSDBA.sample ,NO FALLBACK ,NO BEFORE JOURNAL,NO AFTER JOURNAL, CHECKSUM = DEFAULT,DEFA...
4015 May 2014 @ 10:45 PDTDatabaseReplyTop n FunctionHi, In Teradata don't exists a phisical order of files, you must retrieve the records given the specific order : SELECT TOP 10 * FROM DatabaseName.TableName ORDER BY ColumnName Reg...
3923 Jan 2014 @ 10:12 PSTUDAReplyTaraGuiHi Hillol, The Restore will recreate the same object backuped. The Copy will create a new object with the backuped object. Regards.    
3827 Dec 2013 @ 11:45 PSTDatabaseReplyTable PartitionHi Sharat, In my opinion, this is the problem of Case 1: Here you create a range_n with Date values "AS DATE", but after find with integers "(201201,201202)" Regards.
3722 Oct 2013 @ 11:19 PDTGeneralReplyDIAGNOSTIC Command - Need helpSee this: http://stackoverflow.com/questions/8699777/bteq-the-activity-count-returned-by-dbs-does-not-match-the-actual-number-of-rows Regards.
3622 Oct 2013 @ 11:08 PDTGeneralReplyArcmain Failure 2843:No more room in database.Thanks Dieter.
3518 Oct 2013 @ 09:53 PDTGeneralReplyArcmain Failure 2843:No more room in database.Ok, where is created this subtable ?, in each DB, in DBC ? Regards.
3416 Oct 2013 @ 06:50 PDTGeneralTopicArcmain Failure 2843:No more room in database.Doing a Backup ONLINE, this ends with "Failure 2843:No more room in database." In that database logs are written? Regards.

Pages