All forum activity

#DateUserForumTypeThreadPost
5053330 Jun 2015 @ 06:33 PDTGreyghostToolsTopicInstalling TTUI have tried several times to download and install the TTU software from the Download page.  Eeverytime I get a message the SQL Assistant did not install properly.  What am I missing?&nbs...
5053230 Jun 2015 @ 02:16 PDTdbillingsleaDatabaseReplyReplace NULL Values in Table with Most Recent NOT NULL valueswould the old_cust_acct_id always be 3 for cust_acct_id = 33?  could you just coalesce the value in the partition?   i.e.   SELECT cust_acct_id ,effect_dt ,expiry_dt ,LAST_...
5053130 Jun 2015 @ 01:22 PDTdeepanker.anandAnalyticsTopic"Query is Invalid"errorHi All,   When i execute following sql query using ODBC (Teradata SQL Assistant), it tells me query is invalid, but i am not sure what is incorrect here. please help.   view table tab...
5053030 Jun 2015 @ 12:12 PDTIndyanDatabaseReplyReplace NULL Values in Table with Most Recent NOT NULL valuesI had tried using LAST_VALUE in DEV and that was working. Unfortunately, in PROD we still use TD 14.0, and the upgrade to TD 15.0 is still a few months away. So I was stumped. Thanks for the tip ab...
5052930 Jun 2015 @ 12:06 PDTRoopaliniDatabaseReplyHow to get total IO for a systemHello - I am looking for something similar too. I want to calculate the IO usage of the queries/users on the system. Could anyone point out the resusage tables/columns  that we need to go for?
5052830 Jun 2015 @ 10:25 PDTastocksToolsTopicTPT: Target Database different than Working Database with LOAD operatorHow can I use a different target database (not TdpId) than what I declare in WorkingDatabase?  I want the log and error tables to go to a work database, but the target table is in a different ...
5052730 Jun 2015 @ 09:44 PDTdnoethDatabaseReplyHow to use dervied table in another derived table using with cluase in SQL?It's not your fault, it's Teradata's implementation of WITH which is simply not correct, see: Using WITH Statement Modifier instead of Temp Tables?  
5052630 Jun 2015 @ 09:38 PDTdnoethDatabaseReplyReplace NULL Values in Table with Most Recent NOT NULL valuesYou need to put tabular data as a "code snippet". Regarding your question, this has been asked several times during the last day :-) Problem with history table Compare current row with...
5052530 Jun 2015 @ 09:24 PDTdnoethToolsReplyBTEQ Import/Export of decimals does not workFor your import you define DEC_VALUE as DECIMAL which defaults to DECIMAL(5,0). Change to DECIMAL(22,8).
5052430 Jun 2015 @ 08:43 PDTIndyanDatabaseReplyReplace NULL Values in Table with Most Recent NOT NULL valuesI'm sorry. I am new to the forum. The sample data above looks all messed up. I'm not sure how to publish it with correct formatting.
5052330 Jun 2015 @ 06:56 PDTmanib0907DatabaseReplyGenerating Rank value for each SET of flagsJus a small edit to my code , its SUM(CHANGE_FLG)OVER PARTITION BY MARKET,PRODUCT ORDER BY STARTDT,ENDDT rows unbounded preceding)   Cheers, mani
5052230 Jun 2015 @ 06:10 PDTJhansi Y BDatabaseReplyGlobal Tempoary Table ErrorThanks Dieter... Its working...
5052130 Jun 2015 @ 05:37 PDTyuvaevergreenDatabaseReplyHow to use dervied table in another derived table using with cluase in SQL? http://www.info.teradata.com/htmlpubs/DB_TTU_14_10/index.html#page/SQL_Reference/B035_1146_112A/ch01.034.132.html#ww13804885 In TD, the scope of a derived table is limited only to the select sta...
5052030 Jun 2015 @ 03:33 PDTNewbieTDDatabaseReplyHow to use dervied table in another derived table using with cluase in SQL?Hi Yuva, Thanks for your reply. The derived table tmp has a big query with multiple joins and used in many places. if i repalce tmp table by sub query, it will be very big. I can achieve t...
5051930 Jun 2015 @ 03:29 PDTsh_oneToolsTopicBTEQ Import/Export of decimals does not work Hello experts,   I have a problem using import and export with bteq. I have the following simple table in DB1 and DB2: CREATE SET TABLE DB1.MY_TABLE ( ID INTEG...
5051830 Jun 2015 @ 03:20 PDTyuvaevergreenDatabaseReplyHow to use dervied table in another derived table using with cluase in SQL? SEL TMP.* FROM (SEL 1 AS A,2 AS B) TMP  
5051730 Jun 2015 @ 03:10 PDTpoonam patelHadoopTopicBig Data Governance – What is it? How to get started?Security concerns are key for organizations in many industries today. Data governance can feel like a daunting prospect with organizations unsure of where to start and put off by the every increasi...
5051630 Jun 2015 @ 02:58 PDTyuvaevergreenDatabaseReplyGenerating Rank value for each SET of flagsUse recursive...
5051530 Jun 2015 @ 02:30 PDTNewbieTDDatabaseTopicHow to use dervied table in another derived table using with cluase in SQL? TD: with tmp as (select 1 as a,2 as b), tmp2 as (Select * from tmp) select * from tmp2; Output: select failed, object tmp doesn't exist. Db2: with tmp as (select 1 as a,2 as b fro...
5051430 Jun 2015 @ 02:27 PDTIndyanDatabaseTopicReplace NULL Values in Table with Most Recent NOT NULL valuesI have a table with the following layout cust_acct_id (PK)| effect_dt | expiry_dt | curr_rec_ind | field_a | field_b | field_c | field_d I have to populate any NULL values in field_a, fie...
5051330 Jun 2015 @ 12:30 PDTSuSeSiToolsReplyIssues during Importing pipe delimited vartext file using MLOADYou are not able to load using ".table" command because there is/are some columns that is/are not "VARCHAR" data type(s). Delimited data that are given as input with VARTEXT for...
5051229 Jun 2015 @ 10:59 PDTbrian_mToolsReplyTPT UTF8 Import of "no valid unicode character" - need helpThank you. I think, we can not load the data without preparing the file.
5051129 Jun 2015 @ 05:13 PDTkaran2353ToolsTopicCompare current row with previous NOT NULL row in Teradata.Hi,   I need to implement a logic in which i need to compare my current row with previous NOT NULL row. I am using PRECEDING function but didn't get the desired results. Please fin...
5051029 Jun 2015 @ 12:18 PDTToddAWalterDatabaseReplyOptimizing Stats CollectionPerhaps you could clarify your next to last sentence: If a new event_dt(new records) is inserted in the table, it should be available in the system, without actually capturing the full st...
5050929 Jun 2015 @ 11:27 PDTPaviTeradata ApplicationsReplyExport multiple SQL's results into single excel sheet by sheetHi, Can anyone please help me ASAP.I want to export a excel file  using bteq export comand im using .EXPORT DIF FILE="$DATADIR/business_email.csv". but still im facing some formatt...

Pages