|50533||30 Jun 2015 @ 06:33 PDT||Greyghost||Tools||Topic||Installing TTU||I 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... |
|50532||30 Jun 2015 @ 02:16 PDT||dbillingslea||Database||Reply||Replace NULL Values in Table with Most Recent NOT NULL values||would the old_cust_acct_id always be 3 for cust_acct_id = 33? could you just coalesce the value in the partition?
|50531||30 Jun 2015 @ 01:22 PDT||deepanker.anand||Analytics||Topic||"Query is Invalid"error||Hi 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... |
|50530||30 Jun 2015 @ 12:12 PDT||Indyan||Database||Reply||Replace NULL Values in Table with Most Recent NOT NULL values||I 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... |
|50529||30 Jun 2015 @ 12:06 PDT||Roopalini||Database||Reply||How to get total IO for a system||Hello - 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?
|50528||30 Jun 2015 @ 10:25 PDT||astocks||Tools||Topic||TPT: Target Database different than Working Database with LOAD operator||How 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 ... |
|50527||30 Jun 2015 @ 09:44 PDT||dnoeth||Database||Reply||How 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?
|50526||30 Jun 2015 @ 09:38 PDT||dnoeth||Database||Reply||Replace NULL Values in Table with Most Recent NOT NULL values||You 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... |
|50525||30 Jun 2015 @ 09:24 PDT||dnoeth||Tools||Reply||BTEQ Import/Export of decimals does not work||For your import you define DEC_VALUE as DECIMAL which defaults to DECIMAL(5,0).
Change to DECIMAL(22,8).
|50524||30 Jun 2015 @ 08:43 PDT||Indyan||Database||Reply||Replace NULL Values in Table with Most Recent NOT NULL values||I'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.
|50523||30 Jun 2015 @ 06:56 PDT||manib0907||Database||Reply||Generating Rank value for each SET of flags||Jus a small edit to my code , its SUM(CHANGE_FLG)OVER PARTITION BY MARKET,PRODUCT ORDER BY STARTDT,ENDDT rows unbounded preceding)
|50522||30 Jun 2015 @ 06:10 PDT||Jhansi Y B||Database||Reply||Global Tempoary Table Error||Thanks Dieter...
|50521||30 Jun 2015 @ 05:37 PDT||yuvaevergreen||Database||Reply||How to use dervied table in another derived table using with cluase in SQL?||
In TD, the scope of a derived table is limited only to the select sta... |
|50520||30 Jun 2015 @ 03:33 PDT||NewbieTD||Database||Reply||How 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... |
|50519||30 Jun 2015 @ 03:29 PDT||sh_one||Tools||Topic||BTEQ Import/Export of decimals does not work||
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... |
|50518||30 Jun 2015 @ 03:20 PDT||yuvaevergreen||Database||Reply||How to use dervied table in another derived table using with cluase in SQL?||
SEL TMP.* FROM
(SEL 1 AS A,2 AS B) TMP
|50517||30 Jun 2015 @ 03:10 PDT||poonam patel||Hadoop||Topic||Big 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... |
|50516||30 Jun 2015 @ 02:58 PDT||yuvaevergreen||Database||Reply||Generating Rank value for each SET of flags||Use recursive...
|50515||30 Jun 2015 @ 02:30 PDT||NewbieTD||Database||Topic||How to use dervied table in another derived table using with cluase in SQL?||
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.
with tmp as (select 1 as a,2 as b fro... |
|50514||30 Jun 2015 @ 02:27 PDT||Indyan||Database||Topic||Replace NULL Values in Table with Most Recent NOT NULL values||I 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... |
|50513||30 Jun 2015 @ 12:30 PDT||SuSeSi||Tools||Reply||Issues during Importing pipe delimited vartext file using MLOAD||You 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... |
|50512||29 Jun 2015 @ 10:59 PDT||brian_m||Tools||Reply||TPT UTF8 Import of "no valid unicode character" - need help||Thank you.
I think, we can not load the data without preparing the file.
|50511||29 Jun 2015 @ 05:13 PDT||karan2353||Tools||Topic||Compare 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... |
|50510||29 Jun 2015 @ 12:18 PDT||ToddAWalter||Database||Reply||Optimizing Stats Collection||Perhaps 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... |
|50509||29 Jun 2015 @ 11:27 PDT||Pavi||Teradata Applications||Reply||Export multiple SQL's results into single excel sheet by sheet||Hi,
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... |