#DateForumTypeThreadPost
59822 May 2013 @ 08:23 PDTDatabaseReplyACCOUNTING CPU usage fpr UDFWhich TD version do you run? And which UDF language do you use? To my knowledge does 13.10 account for C UDFs but I am not sure about JAVA. At least in the past Java UDF CPU usage was not capture...
59721 May 2013 @ 10:00 PDTToolsReplyTPT: Moving tables from One TD box to other TD box using TPT You are funny. Harpreet given you the right answer and where to lock for the sample scripts. They are also available in the R13.10 TPT documentation. If you just wane play arround with it try htt...
59616 May 2013 @ 04:43 PDTDatabaseReplyImplicit conversion of Integer to VARCHARBut as the explain states it will try to do the coversion for all values of order_key in the table. The message you get is indicating that at least one value of order_key can be converted to a flo...
59515 May 2013 @ 11:33 PDTDatabaseReplySUBSTR without explicitly coding the length parmI can't reproduce the issue. select top 100 substring(myvar from 4), substr(myvar,4), substr(myvar,14,CHARACTER_LENGTH(myvar)) from mytbl; but as you can see abov...
59415 May 2013 @ 04:54 PDTDatabaseReplyGenerating Sequence NumberP.S. read the documentation carefully before using identity columns. There are other issues as well which need to be considered...
59315 May 2013 @ 04:52 PDTDatabaseReplyGenerating Sequence Numberbecaus the increment by 1 is handled vproc local. Identity columns are not guarantee a sequence - they only quarantee unique ids. Each vproc request a range of numbers he can assign next. The siz...
59224 Apr 2013 @ 05:31 PDTDatabaseReplyThere is another way to remove a volatile table?you can simply drop the VT table within the SP
59124 Apr 2013 @ 02:43 PDTAnalyticsReplyTeradataR Question about kemans analysisCan't test it right now as teradataR is not working for R3.0.0 :-( What should work is that you create a view with your two columns and call td.kmeans with this view.
59020 Mar 2013 @ 08:33 PDTDatabaseReplySQL SyntaxIt's like Dieter suggested try  replace view test_db _uli.v_test1 as select a.col1, a.col2, a.col3, b.col4 from ( select calendar_date as col1, mo...
58920 Mar 2013 @ 01:41 PDTConnectivityReplyOnly an ET or null statement is legal after a DDL StatementAs you wanne use the query band setting only for the one sql try BT;   SET QUERY_BAND = 'Project=Example2;Report=0315-17.11;MSTRUser=MSTRPORTAL_EXXXX;' FOR transaction; select * fr...
58820 Mar 2013 @ 01:11 PDTDatabaseReplySQL Syntaxdid you try to create a view like Create view VW2 as SEL a.col1, a.col2, a.col3, b.col4 from ( sel col1, col2, col3 from tab1 where col2 = '...
58719 Mar 2013 @ 12:01 PDTDatabaseReplyRODBC system error 193try  http://forums.teradata.com/forum/analytics/connecting-to-teradata-in-r-via-the-teradatar-package You need to download the JDBC driver and set the correct path. Ulrich    
58614 Mar 2013 @ 05:26 PDTAnalyticsReplyconversion of datatypeThe change might have implicartion on the required space to store the data which need to be considered.
58514 Mar 2013 @ 03:38 PDTToolsReplyTeradata TPT ScriptTry run    tbuild -V   on the command line   if this is not giving you an information at least the installation would be incomplete...
58414 Mar 2013 @ 03:35 PDTAnalyticsReplyconversion of datatypeDon't post many times the same question. Solution was given at Numeric Overflow error in teredata
58314 Mar 2013 @ 03:30 PDTDatabaseReplyNumeric Overflow error in teredatacheck the data types of  data_table_uplink  data_table_downlink data_table_UPLINK data_table_DOWNLINK data_table__DURATION It looks like the sums are exceding the maximum values...
58203 Mar 2013 @ 11:53 PSTGeneralReplyDid anyone store RDF data (Resource Description Framework) data on Teradata ?@Adeel - no it isn't. You can convert it but it is even more generic. All data is represented as subject predicate objects records. And yes, I stored RDF data in Teradata. Question is what you...
58115 Feb 2013 @ 07:08 PSTDatabaseReplyCan you join using wild cards col_a like %col_b%Strange data model: Depends on the use case.  Can be very sufficient for specific problems. For example data quality checks ELT processes. Filter out email addresses containing specific patte...
58014 Feb 2013 @ 03:13 PSTDatabaseReplyCan you join using wild cards col_a like %col_b%try  cards col_a like '%' || col_b || '%'  
57912 Dec 2012 @ 09:59 PSTDatabaseReplyHow to find the associated tables or view in teradata?Check the disclaimer of the post ;-> But so far it looks quite complete in the cases I worked with it - which I do regularly.  
57812 Dec 2012 @ 09:56 PSTDatabaseReplynumeric overflow occurrence SELECT cast(0 as integer) AS a from (select 'X' as DUMMY) as X UNION ALL SELECT -9999 AS a from (select 'X' as DUMMY) as X The first selects defines the datatype. Try alsoe ...
57705 Dec 2012 @ 01:57 PSTDatabaseReplyUnion vs Group byThe standard answer is that it can depend on your data, the PI and configuration. So easiest is to run the different options and check the DBQL. You also forgot the set option of a temp table. Or...
57605 Dec 2012 @ 01:49 PSTDatabaseReplyHow to find the associated tables or view in teradata?are you looking for this? http://developer.teradata.com/blog/ulrich/2011/11/extract-and-analyse-database-object-dependencies
57504 Dec 2012 @ 10:42 PSTDatabaseReplyWork around to simulate a variable Partition in RANGE_NCan you provide a DDL and some test data as inserts? And explain with the given data your expected results.
57403 Dec 2012 @ 10:49 PSTAnalyticsReplyConnecting to Teradata in R via the teradataR packageJust to avoid future problems tdConnect("10.33.2.136","my_uid","my_pwd","EDEE_POC"," jdbc ") is not getting a connection due to the blanks in &qu...

Pages