All forum activity

#DateUserForumTypeThreadPost
5844214 Jul 2016 @ 08:51 PDTvenkata_k01DatabaseTopicHow to calculate minimum & maximum values based on a column only if the records are continuousHi, I have data as below col1 col2 begindate enddate A  100  '2016-01-01' '2016-02-18' A   100 '2016-03-01' '2016-04-07' A   101 &...
5844114 Jul 2016 @ 08:29 PDTdnoethDatabaseReplyhow to make Stored Procedure with dynamic SQL to display the records?You forgot to add WITH RETURN ONLY to the cursor definition: DECLARE cur1 CURSOR WITH RETURN ONLY FOR S1;  
5844014 Jul 2016 @ 07:55 PDTArpan.RoyToolsReplyNeed Help regarding TPT ODBC Operator Hi Steve,   Using TPT ODBC Operator and DATA CONNECTOR Operator we are trying to fetch data from Oracle table. But the performance is not that much exciting it seems. In the existin...
5843914 Jul 2016 @ 07:52 PDTdnoethDatabaseReplydate variable not parsing proerly in Stored ProcedureThis is the resulting string: SELECT '2016-02-01' AS max_avail_date, 'create multiset volatile table ttt as (select '||cast(max_avail_date as date format 'yyyy-mm-dd')...
5843814 Jul 2016 @ 07:29 PDTHanCDatabaseTopicdate variable not parsing proerly in Stored ProcedureHi, can anyone please help? I'm expecting to get the same date '2016-02-01' displaying with below code, instead I got number 2013. so, it's doing the math: 2013 = 2016-2-1 By ...
5843714 Jul 2016 @ 07:14 PDTHanCDatabaseTopichow to make Stored Procedure with dynamic SQL to display the records? Can anyone please help? Below code can finish running with no error, but how to make it to display the records, just so I know I'm getting what I want. Thanks!   replace PROCEDU...
5843614 Jul 2016 @ 07:07 PDTM.Saeed KhurramDatabaseReplyAdvice on ELT process pleaseHi, If you already have SQL scripts prepared, the best & quick way is to use BTEQ scripts. You can simply embed the existing SQL scripts in BTEQ, use BTEQ Conditional logic & error handlin...
5843514 Jul 2016 @ 06:42 PDTKbosTeradata StudioReplyUnable to connect to the database using Teradata Studio Express.Hi, The way how it worked for me:   1. Run your VM. 2. Click on Computer (look at the low corner left) 3. Click on Network Wired 4. Choose Traditional Method with ifup 5. Verify the opt...
5843414 Jul 2016 @ 06:17 PDTToddAWalterDatabaseReplyAvoid all-row scan in driving table using NUSIIt is not ever possible to test NUSI usage on small data. If the data is only a block or two on each AMP, it is always cheaper to read the data blocks directly than to read the index structure...
5843314 Jul 2016 @ 05:16 PDTPinky_JainGeneralTopicConverting Time stamp in UTC including Day light SavingHi All,   Please can anybody help me out with below query. We are receving timestamp values from our server which is located in UK right now.We need to convert all the timestamp values in U...
5843214 Jul 2016 @ 04:40 PDTvenkata_k01ToolsReplyTeradata tptHi, I am giving the below select statement in job variable file but eventhough there are around 2K records present in the source table, when i am doing the data copy from source to target table us...
5843114 Jul 2016 @ 02:23 PDTindra91ToolsTopicTeradata Tool and Utilities package for LinuxI wanted to install Teradata Tool and Utilities for Red-Hat Linux from the teradata site  https://downloads.teradata.com Although I could find the binary for Teradata Tools and Utilites-Windo...
5843014 Jul 2016 @ 02:13 PDTM.Saeed KhurramToolsReplyTeradata SQL Assistnat 15.10.1.4: Tab colorsThank you for sharing the workaround. 
5842914 Jul 2016 @ 02:02 PDTM.Saeed KhurramDatabaseReplyNOT IN and nested queryTry this: Sel distinct col1 from table1 where col1 NOT IN (Sel col11 from table11 where col11 is not null group by 1);  
5842814 Jul 2016 @ 01:58 PDTM.Saeed KhurramDatabaseReplyNeed to generate a row number like column SELECT LOCATION, ORDER_ID, CLASS, DATE, ROW_NUMBER() OVER (PARTITION BY LOCATION, ORDER_ID ORDER BY DATE) AS RANK FROM TABLE_NAME  
5842714 Jul 2016 @ 01:55 PDTM.Saeed KhurramDatabaseReplyALTER_PPIHi Katei, Just create a new table with new partition layout, and do insert select into new table. It will not take much time. Khurram
5842614 Jul 2016 @ 01:52 PDTM.Saeed KhurramDatabaseReplyAvoid all-row scan in driving table using NUSIHi, To use NUSI, the indexed column should be used in WHERE condistion. Since you have placed no restrcition on any of the tables, it will obviously go for full table scan. Khurram
5842514 Jul 2016 @ 01:31 PDTvenkata_k01ToolsReplyTPT deadlock Issue. Hi All, I am also facing deadlock issue when i am trying to load the target table using tdload. The target table is a temporary table created by the script before running tdload. So, there won&#...
5842414 Jul 2016 @ 01:25 PDTRonaldBrayanDatabaseReplyALTER_PPINo, you are trying to modify the PPI of a populated table. Rows are already distributed in this case and you can not redistribute.   
5842314 Jul 2016 @ 01:19 PDTRonaldBrayanDatabaseReplyAvoid all-row scan in driving table using NUSIIts the Optimizer to choose the best cost effective plan. However, there are maultiple conditions underwhich SI will not be used. You may need to read more of USI/NUSI selection criteria.
5842214 Jul 2016 @ 01:18 PDTsharonnConnectivityReplyCan not connect from host to TDE 14 40G - IP address is not set.I found out was actually using TDE 15 40G, so i downloaded the 14 40G and everything is OK. but i still cant connect using 15 40G. any idea? thanks...
5842114 Jul 2016 @ 01:12 PDTRonaldBrayanDatabaseReplyRegarding Teradata MigrationKaushik, From your post I understand that, you are migrating from 15.00 to 15.10(the versions for source and target Tearadata is close), then it would be a minor upgrade.  It may be a patch u...
5842014 Jul 2016 @ 12:37 PDTyuvaevergreenDatabaseReplyNeed to generate a row number like columnCan you post the expected result?
5841914 Jul 2016 @ 12:15 PDTCarlosALDatabaseReplyNOT IN and nested queryHi. If you get NULLs from table11.col11 the NOT IN will not work. You can try NOT EXISTS instead or filter the NULLs in the subquery. BTW: the DISTINCT is irrelevant for the subquery. HTH. Che...
5841814 Jul 2016 @ 12:03 PDTMartijnToolsReplyFastload - Error on piom GET ROW: 64Hi, Thanks for the quick response! The version of the Teradata Data Connector is 15.00.00.01. I will get the latest version and retry. Thanks!

Pages