37 | 08 Mar 2016 @ 02:38 PST | UDA | Topic | Data Mover Email Notification | Is there a way or option in datamover to send email notification on job completion (failure/cancelled/successful)?
|
36 | 15 Jul 2015 @ 02:18 PDT | Tools | Topic | Teradata Query Scheduler multiple Servers/Services on single PC? | Hi,
I installed TQS Client and Server on one of my windows server (Windows 2008 Server R2 Enterprise).
I have multiple Teradata Systems (like DEV, QA, PROD). How can I run TQS for all three diff... |
35 | 24 Apr 2015 @ 01:28 PDT | Database | Reply | Change based threshold option for collect stats | if your scenario is to delete data and reload (turncate and load) threshold part will be skipped since data is deleted and for Teradata all data is changed and insertion again will not be calculate... |
34 | 21 Jan 2015 @ 09:29 PST | Database | Reply | Replace View ( DDL ) inside a Stored Procedure Teradata | Hi Karthik,
DDL can be used in Macro with these limitations:
Only ONE DDL in a macro
DDL should be the last statement in Macro
So, you can replace one view in one macro as last st... |
33 | 04 Feb 2014 @ 07:48 PST | Tools | Topic | Convert HostData to actual record from Error Table | Hi,
We have some jobs loading data from TPT which creates ET for duplicate records.
Does anyone know how to convert Hostdata values into actual record from ET? I have limitations, can not user fa... |
32 | 17 Dec 2013 @ 03:01 PST | Database | Reply | two similar tables - very different import speed | What utility you are using?
|
31 | 12 Dec 2013 @ 03:24 PST | Database | Topic | How to grant UPDATE to DBC on DBC.IDCol Tables? | I was reading an older post (http://forums.teradata.com/forum/database/reset-identity-column-counter) and concluded that somehow Update is possible for DBC tables (DBC.IdCol).
I've come-... |
30 | 11 Dec 2013 @ 08:23 PST | Database | Reply | SQL to transpose (row to column) any level (nth level) of data |
Here is your solution.
I am placing full code so other gurus can correct it if one finds error or better solution.
CREATE TABLE myDB.SrcTgtMap
(
TgtCol VARCHAR(100),
Sr... |
29 | 10 Dec 2013 @ 09:25 PST | Database | Reply | How long it will take to insert 20 million rows to teradata table from java using jdbc drivers TYPE=FASTLOADCSV | This might be helpful too.
http://developer.teradata.com/doc/connectivity/jdbc/reference/current/jdbcug_chapter_2.html#BABFGFA2
|
28 | 10 Dec 2013 @ 09:22 PST | Database | Reply | How long it will take to insert 20 million rows to teradata table from java using jdbc drivers TYPE=FASTLOADCSV | I don't think there is an absolute answer of this, you might need to look at some bench marking results for this but still it will be highly dependent upon I/O and network/communication capacit... |
27 | 09 Dec 2013 @ 10:25 PST | Database | Reply | Foreign Keys | This is something about implementing hard RI and soft RI. I am trying to find some reference why Teradata is creating "_0" table but for the time being I can tell you ... |
26 | 06 Dec 2013 @ 02:11 PST | Database | Reply | Default date column not aligning in xcel | Excel doesn't support date before 1900 and considering this value as text value.
See for further details : http://exceluser.com/formulas/earlydates.htm
|
25 | 06 Dec 2013 @ 10:12 PST | Database | Reply | Script to compare two databases (Tables and Views definitions) | If you have access on DBC then you can write SQL statement to compare text for TVM.CreateText.
You might need to join dbc.TVM with dbc.dbase to get appropriate result.
|
24 | 06 Dec 2013 @ 09:00 PST | Database | Reply | need a associated select query defined from view table in teradata? | Its pretty strange, did you try same thing using BTEQ? Which provider you are using to connect SQLA? Is it ODBC or .Net Provider?
|
23 | 04 Dec 2013 @ 09:06 PST | Database | Reply | Error 2618 Invalid Calculation Division by Zero | Did it work fine for you?
|
22 | 04 Dec 2013 @ 08:49 PST | Database | Reply | Storing result set as a variable in a procedure | A variable can only store one value at a time, not multiple values. You can consider using cursor in SP to get recordset and pass it thru loop one by one.
|
21 | 04 Dec 2013 @ 08:42 PST | Database | Reply | Error 2618 Invalid Calculation Division by Zero | Let me look at this SQL, meanwhile can you try following sql and let me know if still getting same error?
SELECT I.REPL_GROUP_NBR AS DMDUNIT
,'-' AS DMDGROUP
, 'US_WMT_ST_'|... |
20 | 04 Dec 2013 @ 07:39 PST | Database | Reply | Error 2618 Invalid Calculation Division by Zero | I think we need to look at complete SQL Statement and it's logic. Seems this filter is causing 'return zero' somehow.
|
19 | 03 Dec 2013 @ 02:30 PST | Database | Reply | Need guidance | As Dieter already mentioned, more details are needed to pin point the exact problem. specially Spool size, spool allocation, table structure, Merge Statement and Number of AMPs.
At a glance, it lo... |
18 | 03 Dec 2013 @ 02:20 PST | Database | Reply | need a associated select query defined from view table in teradata? | Can you please elaborate what exactly you are looking for?
If you just want to see the SQL (View DDL) then why don't you use SHOW VIEW?
SHOW VIEW View1;
|
17 | 03 Dec 2013 @ 02:14 PST | Database | Reply | Split the dates bi-weekly | Following might solve your issue or help you to solve this query.
SELECT Start_Date, End_Date
FROM
(
SELECT calendar_date End_Date, ROW_NUMBER() OVER(ORDER BY calendar_date) RowNum
FROM sy... |
16 | 03 Dec 2013 @ 01:30 PST | Database | Reply | Count the number of words in a phrase using Teradata SQL | Sree,
This might help you to resolve your issue.
SELECT COUNT(*)+1
FROM
(
SELECT SUBSTR(SENT,POS,1) SINGLE_CHAR
FROM
(SELECT 'COUNT WORDS FROM THIS SENATANCE FOR ME' SENT) A, ... |
15 | 03 Dec 2013 @ 12:54 PST | Database | Reply | Error 5505 Column data types cannot be specified with a WITH [NO] DATA clause. | Thanks Khurram for the compliments. I sent you invite on linkedin, stay in touch there.
|
14 | 03 Dec 2013 @ 11:29 PST | Database | Reply | Re-writing a query interms of performance | If you have option to revise PI, you can improve performance of this query. You might need to implement following in CUST_T table. This will help to maintain uniquness, support to other queries usi... |
13 | 03 Dec 2013 @ 10:01 PST | Database | Reply | Error 5505 Column data types cannot be specified with a WITH [NO] DATA clause. |
I tested this scenario using same statements, and it is working fine for me.
Versions details:
SQL Assistant : 14.0.0.1
Database : 13.00.00.12
Provider : Teradat... |