|677||06 Feb 2014 @ 12:44 PST||General||Reply||Create a macro that chooses from teo different select staments depending on a given parameter.||SP might be the better way but in case there are limitations on SP and both SQLs deliver the same column lists and data types you can try something like
replace macro con_test (test_val char(1))... |
|676||05 Feb 2014 @ 11:51 PST||Connectivity||Reply||Load Nulls with R & JDBC Fastload Problem||Hi,
no thats not the issue.
is.na(x) checks for NA and NaN.
You can change j[i1] <- NA and the error is the same.
The message is
"Fehler in .jcall(ps, "V&qu... |
|675||05 Feb 2014 @ 07:54 PST||Connectivity||Topic||Load Nulls with R & JDBC Fastload Problem||Hi all,
I try to load some data from R directly to Teradata 14.10 via JDBC Fastload.
The data contains some Nulls for numeric values and I have not been able to load this data so far.
The ... |
|674||05 Feb 2014 @ 07:46 PST||Database||Reply||Use of NOT IN for a fact join||What is the PI of the fact table
|673||05 Feb 2014 @ 12:46 PST||Database||Reply||Use of NOT IN for a fact join||I don't get fully what you wanne achive
Can you explain with some data?
also not exists shows better performance
from fact o
where date_col / 100 + 190000 = 201310
and not exi... |
|672||23 Jan 2014 @ 11:58 PST||Database||Reply||Urgent : Latin to Unicode character conversion- Please help||what is your session setting of your BO query? It has to be unicode as well.
|671||23 Jan 2014 @ 04:44 PST||Database||Reply||Urgent : Latin to Unicode character conversion- Please help||Can you explain how you managed to store the unicode data in the latin columns?
Did you check the WITH ERROR option of the translate function?
|670||22 Jan 2014 @ 05:54 PST||Connectivity||Reply||td wallet for jdbc||Hi,
At present, only logon processing that is initiated through Teradata CLIv2 for Network Attached Systems utiliz... |
|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... |