#DateForumTypeThreadPost
67806 Feb 2014 @ 12:38 PSTConnectivityReplyLoad Nulls with R & JDBC Fastload ProblemUnfortunatly it does not help. Error message is now: Fehler in .jcall(ps, "V", "setNull", as.integer(3), 4) :   method setNull with signature (ID)V not found
67706 Feb 2014 @ 12:44 PSTGeneralReplyCreate 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))...
67605 Feb 2014 @ 11:51 PSTConnectivityReplyLoad Nulls with R & JDBC Fastload ProblemHi,  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...
67505 Feb 2014 @ 07:54 PSTConnectivityTopicLoad Nulls with R & JDBC Fastload ProblemHi 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 ...
67405 Feb 2014 @ 07:46 PSTDatabaseReplyUse of NOT IN for a fact joinWhat is the PI of the fact table  
67305 Feb 2014 @ 12:46 PSTDatabaseReplyUse of NOT IN for a fact joinI don't get fully what you wanne achive Can you explain with some data? also not exists shows better performance select * from fact o where date_col / 100 + 190000 = 201310 and not exi...
67223 Jan 2014 @ 11:58 PSTDatabaseReplyUrgent : Latin to Unicode character conversion- Please helpwhat is your session setting of your BO query? It has to be unicode as well.
67123 Jan 2014 @ 04:44 PSTDatabaseReplyUrgent : Latin to Unicode character conversion- Please helpCan 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?
67022 Jan 2014 @ 05:54 PSTConnectivityReplytd wallet for jdbcHi, on http://developer.teradata.com/tools/articles/introducing-teradata-wallet At present, only logon processing that is initiated through Teradata CLIv2 for Network Attached Systems utiliz...
66921 Jan 2014 @ 01:06 PSTAsterReplyAster 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...
66816 Jan 2014 @ 10:35 PSTAnalyticsReplyHelp with SQL to deal with overlapping date rangewhich release are you on?
66714 Jan 2014 @ 11:46 PSTDatabaseReplyConnection problem with TD14They 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 ...
66614 Jan 2014 @ 01:06 PSTDatabaseReplyConnection problem with TD14Did you try to logon with Nexus Chameoleon from the same machine as with Teradata Studio? Is ODBC installed? Teradata Studio uses JDBC
66516 Dec 2013 @ 11:38 PSTDatabaseReplyExtractin 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...
66416 Dec 2013 @ 11:31 PSTAnalyticsReplyFast Load Vs MultiloadNot 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. Fastlo...
66316 Dec 2013 @ 11:11 PSTDatabaseReplyRESERVED WORDS:Query to find Views and macros that reference a particular table or viewcheck http://developer.teradata.com/blog/ulrich/2011/11/extract-and-analyse-database-object-dependencies
66210 Dec 2013 @ 07:40 PSTDatabaseReplyRewriting the Self joinThis should create also the same output an would do the self join only once but comes with a smal prod join SELECT case when c.id = 1 then A.MERGE_ID else B.REM_ID end, case when c.id = 1 th...
66110 Dec 2013 @ 07:33 PSTDatabaseReplyRewriting the Self join  hm, try and check the differences in explain and run times   select A.MERGE_ID, A.REM_ID, A.EFF_DT, A.FIRST_MERGE_DT , A.CURR_CUST_MERGE...
66006 Dec 2013 @ 06:40 PSTToolsReplygenerating sequention number during mloadinmods can do that but would require additional programing - check the manuals
65903 Dec 2013 @ 12:32 PSTDatabaseReplyTeradata 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 SPECIFIC mydb.FROM_TZ RETURNS NULL ON NULL INPUT LANGUAGE SQL CONTAINS SQL DE...
65803 Dec 2013 @ 07:32 PSTDatabaseReplyTeradata equivalent function to FROM_TZ in Oraclewouldn'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...
65702 Dec 2013 @ 01:20 PSTAnalyticsReplyteradataR package and R 3.0.0Hi, 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...
65624 Nov 2013 @ 11:32 PSTDatabaseReplyAutomate my Teradata queriesCalling the SQLs from BTEQ and schedule the BTEQ calls with a scheduler, cron etc....
65521 Nov 2013 @ 02:37 PSTToolsReplyExport to delimited fileyou can also run with -s 1 option
65421 Nov 2013 @ 02:09 PSTToolsReplyExport to delimited fileYour 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?

Pages