#DateForumTypeThreadPost
70311 Apr 2010 @ 02:42 PDTDatabaseReplyHow to automate commands?Oops, this doesn't look like a demo system. Of course you could automate that vprocmanager script, but this will not eliminate the cause of that problem. You should better contact your Teradata ...
70211 Apr 2010 @ 02:36 PDTDatabaseReplyDoes Teradata restart after a node reboot?I hope you're talking about a demo system running in a VMWare, because "whenever I reboot" scares me. A production system is usually setup to start after the node booted. How do you initializ...
70111 Apr 2010 @ 02:21 PDTDatabaseReplyinput needed in sql designHi Subhash, there's no need for any kind of loop, you just compare the "current" start_dt to the "previous" end_dt: CASE WHEN (start_dt --current - MIN(end_dt) --previous OVER (PARTITIO...
70008 Apr 2010 @ 01:11 PDTToolsReplyFast Load Error - Record is too long by n byte(s)Hi Joe, 1: CSV means readable character data, thus all fields must be defined as VARCHAR. 2: You didn't specify SET RECORD VARTEXT, thus it defaults to FORMATTED Dieter
69908 Apr 2010 @ 01:06 PDTDatabaseReplyQCD (Query Capture Database) in Visual explain Plan...Hi Lavakumar, did you read the appropriate chapter in the manuals? SQL Request and Transaction Processing: Query Capture Facility SQL Data Manipulation Language: Query and Workload Analysis DM...
69808 Apr 2010 @ 12:55 PDTDatabaseReplyTERADATA TRIM FUNCTIONHi Richard, put the function as a column into the select list to see the calculated data. Btw, without any information about the actual data it's hard to know what's "not working". Dieter
69705 Apr 2010 @ 06:59 PDTDatabaseReplyStored procedure with select on table that is creatde in runtimeIf an object doesn't exists, there should be a *warning* message, but the SP is created. The create will only fail if there's an *error* message. Dieter
69604 Apr 2010 @ 06:59 PDTDatabaseReplyDELETE query is taking too long time in the production....Some remarks: According to your post the PK of tables seems to be: AGG_DLY_STR_PROD - ( DATE_KEY ,STORE_KEY ,PRODUCT_KEY ) INC_ETL_CUR_DAYS - (DATE_KEY) But it's defined as NUPI instead of ...
69504 Apr 2010 @ 02:30 PDTGeneralReplyBTEQ Import Data file errorValues (:EmpNo, :Name, :DeptNo, :JobTitle, :Salary, :YrsExp
69404 Apr 2010 @ 02:24 PDTUDAReplyjoining table A to table B only once where condition satisfiedHi Chris, i wouldn't call that genious, it's just your conditions put into a SP, which is actually not that complicated :-) The order by in the volatile table should'n change the result, it's j...
69304 Apr 2010 @ 01:34 PDTUDAReplyTeradata - Oracle - Query Rewrite - Qualify & RankHi Adeel, oif course you're right, it's working on Teradata. But the original poster wanted to port it to Oracle :-) Select frm_crncycd,to_crncycd,exch_rate from (Select frm_crncycd,to_cr...
69229 Mar 2010 @ 01:49 PDTToolsReplyinsert into problem in BTEQINSERT INTO tableName (col1, col2, col3) SELECT :next_var + row_number () over (order by ???) col2, col3 FROM tableName; Dieter
69129 Mar 2010 @ 01:36 PDTUDAReplyjoining table A to table B only once where condition satisfiedHi Chris, only SPs with Dynamic SQL (not in this case) or DDL statements must be created within the creator (this limitation is lifted in TD13). So for a first try you might to drop/create the Vo...
69027 Mar 2010 @ 04:56 PDTToolsReplyusage of check point in fastloadIf Teradata restarts during a FastLoad it just waits for the DBMS to recover and then finishes the load, without resending data. If the FastLoad job has to be restartet (e.g. FastLoad crashes or...
68926 Mar 2010 @ 07:29 PDTUDAReplyjoining table A to table B only once where condition satisfiedHi Chris, sorry, i lost that thread during the forum migration and later i was busy. I don't think there's a set based solution, so the only solution is a loop in a Stored Procedure. This is ...
68826 Mar 2010 @ 06:14 PDTToolsReplyError while loading data using fastload utilityJust change the layout definition to match the actual size of 2 characters: newlinechar(char(2)) Or change the input definition to SET RECORD TEXT and remove the newlinechar. Dieter
68725 Mar 2010 @ 01:26 PDTToolsReplyError while loading data using fastload utilityA newline in windows is actually two characters CR/LF. Dieter
68625 Mar 2010 @ 01:20 PDTGeneralReplyCreate UDF user- password too shortCheck your password policy: Control Panel - Administrative Tools - Local Security Policy Decrease the Minimum password length before setup and reset it afterwards. Dieter
68525 Mar 2010 @ 01:10 PDTDatabaseReplyWhat does this index doing in the select statementINDEX(b,a) is outdated Teradata SQL for POSITION(a in b) Strange logic, i would rewrite sum(index('R',mail_retail_cde)) to sum(case when mail_retail_cde = 'R' then 1 else 0 end) Dieter
68421 Mar 2010 @ 02:06 PDTDatabaseReplyAlternative to count(*) in TeradataIt's faster because it's no longer doing a Full Table Scan. Instead of reading all datablocks only the cylinder indexes are accessed (which include the number of rows per datablock). Of course th...
68317 Mar 2010 @ 08:53 PDTDatabaseReplyAlternative to count(*) in TeradataNo. But the table's statistics will show the row count from the time when the stats where collected. Thus this is only approximate, but afaik the count returned by SQL Server is not guaranteed to ...
68217 Mar 2010 @ 12:48 PDTDatabaseReplyIs the mapping of Account String to Performance Group name case sensitive?No, the accountstring is automatically changed to UPPERCASE (at least it's always retrieved/stored like that if you check AmpUsage/DQBL/PMon). Dieter
68110 Mar 2010 @ 07:20 PSTDatabaseReplyMonitoring Daily Spool space usage.It's just like any other history: Use a scheduled job to insert/select from dbc.diskspace or (preferred on TD12) syslib.monitorsessions. Of course Viewpoint already collects spool space metric...
68010 Mar 2010 @ 12:10 PSTDatabaseReplyUsing the FLEX application to pass variables to Teradata SQLHi Pat, you should be glad that it doesn't work, because that query is (how shall i put this? ahem...) totally stupid: It's a CROSS JOIN between two potentially large answer sets, followed by a G...
67909 Mar 2010 @ 09:24 PSTDatabaseReplyvarchar concatenation 2 sec ago What's the datatype of m.pla_rw_place_number? CAST(substr(e.pla_rw_place_number_,char(e.pla_rw_place _number_)-3,4) as integer) in the recursive part will fail if the previous pl...

Pages