All forum activity

#DateUserForumTypeThreadPost
5130601 Aug 2015 @ 02:09 PDTFredDatabaseReplyViews and LocksIf your session is using ANSI mode, your understanding is correct. The READ lock for "Type 1" scenario will be held until you stop retrieving rows and COMMIT, so will block ETL ...
5130501 Aug 2015 @ 08:46 PDTsharatbalajiDatabaseTopicViews and LocksCan some tell me if my understanding on the views and locks are correct based on the below example.   I have created a view as below --View Definition Type 1 (Implicit Read Lock) CREATE VI...
5130431 Jul 2015 @ 03:18 PDTbrennanbConnectivityTopicTDAT ODBC and Windows 10I've been trying to use the TTU 15 tools iwth Windows 10, and while SQL Assistant ("Queryman") in native Teradata mode works fine, I can't get it to work in ODBC; nor will Teradat...
5130331 Jul 2015 @ 02:46 PDTpadhiaDatabaseReplyHow to ensure atomic nature of multiple table actions?Let me take a stab at providing the answers.  Atomicity isn't unique to Teradata, all major databases support "Transactions", which are atomic (https://en.wikipedia.org/wiki/ACI...
5130231 Jul 2015 @ 02:39 PDTDanBToolsReplyConvert date format m/d/yyyy to mm/dd/yyyy in TPT select cast( REGEXP_REPLACE( REGEXP_REPLACE( REGEXP_SUBSTR(trim('11/5/2002 12:00:00 PM ....blah'), '^([0-9]{1,2}\/){1,2}[0-9]{4}'), '^([0-9])\/', '0\1/'), &...
5130131 Jul 2015 @ 11:37 PDTgrybackViewpointReplySet a Maintenance WindowWhy not just disable the system in Viewpoint and then re-enable when the Teradata system is back on-line? 
5130031 Jul 2015 @ 11:20 PDTgrybackViewpointReplyMigrating to new Viewpoint serverAs you probably know, you can copy the alerts between Teradata DB systems on the same Viewpoint instance but we don't currently offer a alerts export / import between Viewpoint instances. 
5129931 Jul 2015 @ 10:39 PDTsdcDatabaseReplyHow to ensure atomic nature of multiple table actions?31 views and no replies.  Can I ask the question in a better way?  Is something unclear?  Too long of a post?  I can do something with incomplete answers if people don't wan...
5129831 Jul 2015 @ 09:48 PDT31_resuToolsReplySQL Inserter Help with TPT and CLOB Data LoadI've gone through the Web info and it primarily covers BLOB. Does anyone have any sample BTEQ or TPT run through SQLA that loads CLOB? I namely need to see how the control file deals with the C...
5129731 Jul 2015 @ 06:47 PDTtomnolanDatabaseReplyFASTLOADCSV Error JAVAYour program needs to iterate through and print the entire SQLException chain, by calling getNextException. Please refer to our JDBC FastLoad sample programs for how to do this. All JDBC sample pro...
5129631 Jul 2015 @ 06:43 PDTtomnolanConnectivityReplyCalling a macro via JDBCPreparing a SQL request is a completely different operation from executing an EXEC macro SQL request.   For the Teradata Database, parsing can and often does occur when preparing a SQL ...
5129531 Jul 2015 @ 06:14 PDTnealvennaDatabaseReplyREGEXP_REPLACE does not replace all occurrences, even when setting occurence_arg=0This works though   select 'abcde12x34f5' as vat, REGEXP_REPLACE(VAT,'[^0-9]+','',1,0,'I')
5129431 Jul 2015 @ 04:51 PDTLUCASConnectivityReplyCalling a macro via JDBCAbout SQL PRPEPARE and MACRO: i had in mind that macros allow one parsing step only (with the first execution) , avoiding parsing at each execution of the request. I have no idea of what SQL PR...
5129330 Jul 2015 @ 11:31 PDTer.vipinViewpointReplySession CPU,IO SkewHow Heatmap portlet calcultes AMPCPUSkew and AMPIOSkew ? I would like to get similar information from Resusage table. I could figure out that viewpoint is fetching data from ResusageSVPR, but coul...
5129230 Jul 2015 @ 08:31 PDTAbhishek_RCDatabaseReplyCumulative BITOR  Minor correction in the output ...sorry about that.. SR value  BITOR_OP 1    1      BITOR(1,0)=1             1    6 ...
5129130 Jul 2015 @ 08:30 PDTAbhishek_RCDatabaseTopicCumulative BITOR Hi, I want to write a sql which will help me find cumulative bitwise OR values as shown below - Most of the cumulative functions use SUM, AVG, MIN, MAX but I could not find a proper so...
5129030 Jul 2015 @ 03:24 PDTFredDatabaseReplyHow to convert column character set in Teradata table.No. You cannot ALTER an existing column in a manner that requires rewriting the data rows. For non-indexed columns, you can use ALTER to rename existing columns and/or add new columns (e.g. ALTER ...
5128930 Jul 2015 @ 01:39 PDTfgrimmerTeradata StudioReplyHow to load data from a csv file into a table using Teradata StudioFabio, Please refer to the Teradata Studio article (http://developer.teradata.com/tools/articles/teradata-studio) and the section on Data Transfer Wizard and Load and Extract Data.
5128830 Jul 2015 @ 10:56 PDTsdcDatabaseTopicHow to ensure atomic nature of multiple table actions?I am working on an application which generates a result that I want to store in a Teradata database.  The database consists of several tables and the application's result will span multipl...
5128730 Jul 2015 @ 10:49 PDTzioliTeradata StudioTopicHow to load data from a csv file into a table using Teradata StudioHi everybody,  someone here may help me on that? I have to load data from a csv file into a table but I have no idea how.  There are about 12 million records into the csv file. thanks
5128630 Jul 2015 @ 08:00 PDTecamagna76ViewpointReplyMigrating to new Viewpoint serverHi gryback, Is there a way to export and import only the alerts from one viewpoint to another?  
5128530 Jul 2015 @ 07:45 PDTTDFUserDatabaseTopicHow to convert column character set in Teradata table.Hi , My Requirement is that i want to change character set of a column. For some tables, i want to change columns character set  from Latin to Unicode and for some other tables from Unic...
5128430 Jul 2015 @ 07:42 PDTzioliDatabaseTopicFASTLOADCSV Error JAVAHi Everybody,  I  am having problem on using the FastLoad protocol. I am tryng to insert data, based on a csv file,  into a Teradata (V.14) table using the JDBC Teradata driver. Her...
5128330 Jul 2015 @ 06:40 PDTdnoethDatabaseReplyHOw to join on nearest lower value in teradata sqlHi Deepak, the join is like this: select t2.*, t1.* from table2 as t2 join table1 as t1 on t1.i = (select max(t3.i) from table1 as t3 where t3.i <=t2.i) But this result in a product ...
5128230 Jul 2015 @ 06:13 PDTDeepakAsuleDatabaseReplyHOw to join on nearest lower value in teradata sqlsorry    I have 425709 records in first table and 1916 records in second table.   Deepak  

Pages