|669||21 Jan 2014 @ 01:06 PST||Aster||Reply||Aster without a SYS_CALENDAR?||I guess there exists different use cases for a calendar table where system calendar is usually a starting point as it is part of TD default installations.
1. Check if date is a workingdate weekday... |
|668||16 Jan 2014 @ 10:35 PST||Analytics||Reply||Help with SQL to deal with overlapping date range||which release are you on?
|667||14 Jan 2014 @ 11:46 PST||Database||Reply||Connection problem with TD14||They are all on the same machine but quite different - the VM looks like a different computer to your laptop and therefore you need to enable that the VM can be reached from you laptop...
Did you ... |
|666||14 Jan 2014 @ 01:06 PST||Database||Reply||Connection problem with TD14||Did you try to logon with Nexus Chameoleon from the same machine as with Teradata Studio?
Is ODBC installed? Teradata Studio uses JDBC
|665||16 Dec 2013 @ 11:38 PST||Database||Reply||Extractin a QUERY TEXT from a Column and using this output we need to insert the data into another table.||you can export the SQLs (as full Insert/selects) with bteq and can import and call these generated SQLs in the same job.
Check http://forums.teradata.com/forum/general/bteq-script-to-read-and-exec... |
|664||16 Dec 2013 @ 11:31 PST||Analytics||Reply||Fast Load Vs Multiload||Not sure that above answers the orig question.
I guess the number of phases are irrelevant. Usually total time to get things done is what matters.
But both utilites come with limitations.
|663||16 Dec 2013 @ 11:11 PST||Database||Reply||RESERVED WORDS:Query to find Views and macros that reference a particular table or view||check
|662||10 Dec 2013 @ 07:40 PST||Database||Reply||Rewriting the Self join||This should create also the same output an would do the self join only once but comes with a smal prod join
case when c.id = 1 then A.MERGE_ID else B.REM_ID end,
case when c.id = 1 th... |
|661||10 Dec 2013 @ 07:33 PST||Database||Reply||Rewriting the Self join||
hm, try and check the differences in explain and run times
|660||06 Dec 2013 @ 06:40 PST||Tools||Reply||generating sequention number during mload||inmods can do that but would require additional programing - check the manuals
|659||03 Dec 2013 @ 12:32 PST||Database||Reply||Teradata equivalent function to FROM_TZ in Oracle||
REPLACE FUNCTION mydb.FROM_TZ (ts_str char(19),tz_str char(6) )
RETURNS timestamp(0) with time zone
RETURNS NULL ON NULL INPUT
|658||03 Dec 2013 @ 07:32 PST||Database||Reply||Teradata equivalent function to FROM_TZ in Oracle||wouldn't it be just a cast?
select cast('2012-12-12 23:12:59+03:00' as timestamp(0) with time zone);
If you need FROM_TZ with two inpurt parameter you could create a SQL udf
where yo... |
|657||02 Dec 2013 @ 01:20 PST||Analytics||Reply||teradataR package and R 3.0.0||Hi,
great!!! It's working fine.
I used git clone https://github.com/Teradata/teradataR/ to download it.
The package required RODBC package to be installed but it works also fine with JDBC on... |
|656||24 Nov 2013 @ 11:32 PST||Database||Reply||Automate my Teradata queries||Calling the SQLs from BTEQ and schedule the BTEQ calls with a scheduler, cron etc....
|655||21 Nov 2013 @ 02:37 PST||Tools||Reply||Export to delimited file||you can also run with -s 1 option
|654||21 Nov 2013 @ 02:09 PST||Tools||Reply||Export to delimited file||Your second job is a restart. What happend at the first start? Did you changed the script?
Can you run the SQL itself in SQL assitent or BTEQ or TD Studio?
|653||21 Nov 2013 @ 12:47 PST||Database||Reply||fetching data by joining 2 tables in a view||Ok, in this case it is too big to transform it into a SQL UDF.
You facing here the problem of an de-normalized design which leads to komplex queries.
CREATE MULTISET TABLE DB_TEST.T1
A DECI... |
|652||21 Nov 2013 @ 12:35 PST||Database||Reply||Performance tuning of a Fast Load Script-||correct - at least if the AVG varchar length is < char length -2. As varchar will add up to additional 2 bytes for the actual length of the varchar (e.g. it need to know how long the value is to... |
|651||20 Nov 2013 @ 08:53 PST||Marketing & CRM||Reply||Business solution without Technology||I don't get it - in this case you can answer you question yourself.
But what will be the value of the question of this generic question and an yes to others?
|650||20 Nov 2013 @ 08:50 PST||Database||Reply||Need help in understanding Teradata's behaviour||it is very difficult to answer you these questions on your pseudo code - the first query is syntax whise incorrect as columns names are missing. Not a big deal but it means it is manual pseudo code... |
|649||20 Nov 2013 @ 06:44 PST||Database||Reply||CASE STATEMENT||Hi MBR,
what do you exptect others to do?
You don't share DDL and data (as inserts!!!). So how could you expect that syntactially correct code is posted?
And even now you don't sha... |
|648||20 Nov 2013 @ 06:41 PST||Database||Reply||Need help in understanding Teradata's behaviour||you don't have at some point an where on B.x = something?
This would convert the outer to an inner join and would filter out rows.
|647||20 Nov 2013 @ 02:35 PST||Database||Reply||fetching data by joining 2 tables in a view||how many rows has your table t2?
|646||20 Nov 2013 @ 12:44 PST||Marketing & CRM||Reply||Business solution without Technology||What do you expect with this kind of Twitter questions? Will yes or no answer help???
|645||19 Nov 2013 @ 12:43 PST||Database||Reply||fetching data by joining 2 tables in a view||But this might be done more efficiently with an aggregation T2 before joining to T1.
But again if you can not share some example DDLs and example data (please as insert statements) it will b... |