#DateWhereItemComment
5108 Mar 2016 @ 12:12 PSTkeep it simpleExtract and Analyse Database Object DependenciesHi Ali, I guess it will become a challange to do what you want based on DBC infos. You might check the infos in the DBQL object view. But this requires that DQBL object logging is on and that you ...
5001 Feb 2016 @ 01:05 PSTkeep it simpleExtract and Analyse Database Object Dependenciesnot sure that I understand your requirement correctly. For views and tables you can get the column information from dbc.columnsV. But I guess this is not what you are looking for... If you want c...
4907 Aug 2015 @ 01:46 PDTToolsTeradata Python Module@eric question - is native JDBC support also on the roadmap? Would have some advantages as it only requires JDBC driver distribution and not ODBC installation for clients who don't use the Rest...
4807 Aug 2015 @ 01:42 PDTToolsTeradata Python Module@eric thanks for the clarification! The workaround / the solution worked fine.
4706 Aug 2015 @ 05:59 PDTToolsTeradata Python ModuleHi Eric,   minor question: Can the Working Dir be configiured? No parameter is specified for this. As this holds the checkpoint files some admins might prefer not use the source cod...
4606 Aug 2015 @ 12:59 PDTToolsTeradata Python ModuleHi Eric, works like a charm! Ulrich
4505 Aug 2015 @ 02:03 PDTToolsTeradata Python ModuleSolved the logging issue :-) import logging logger = logging.getLogger(__name__) rc = 0 with session: for row in session.execute(""" MY SELECT which should return 0 rows...
4405 Aug 2015 @ 01:41 PDTToolsTeradata Python ModuleEric, I want to log the output of an query into the application log. " If you create a logger in your script, your custom log messages will also be logged along with the UdaExec log me...
4303 Aug 2015 @ 05:24 PDTToolsTeradata Python ModuleHi Eric, yes, the issue with the comments is fixed. Also git is working nicely - my question was not related to git usage itself but on how go get the git info into the logs. I was not sure if ad...
4229 Jul 2015 @ 01:09 PDTToolsTeradata Python ModuleQuite interesting module! I was able to install it and get it running via the RestAPI from a mac. One questions on the sql files option. How can I place comments in these files? -- seems to wor...
4117 Jul 2015 @ 04:49 PDTkeep it simpleExample Java UDF for Table Hash CalculationsP.S. maybe try also a different browser - it seems some have issues with the developer.teradata.com page...
4017 Jul 2015 @ 04:42 PDTkeep it simpleExample Java UDF for Table Hash CalculationsAt the top of the page where the bog text starts on the right side is a section attachement. I get three files listed there...
3910 Dec 2014 @ 01:37 PSTUDAWorking with Identity Columns and Unity Director and LoaderHi Paul, I have to admit that I missed the possible impact of the trigger and the current_timestamp when you load the data with TPUMP or TPT Stream. But if you use the szenario for insert/selects...
3810 Dec 2014 @ 04:47 PSTUDAWorking with Identity Columns and Unity Director and LoaderPaul, the syslib.UUID() is clearly not usable as a UUID generator. The number of synonyms is fare to high. With select id, count(0) from ( select calendar_date, syslib.UUID() as id...
3702 Dec 2014 @ 05:30 PSTConnectivityAccess External Data - A Table UDFWhere can we find the download?
3606 Aug 2014 @ 04:48 PDTToolsudaSQL - A DevOps Focused SQL Execution EngineHi Mike, I am not able to see the attached udaSQL.zip file.  Is it gone? Ulrich
3504 Feb 2014 @ 12:37 PSTamarek's blogHow to capture chained JDBC FastLoad SQLException/SQLWarning messages and stack trace with RHi Amarek, thanks for that! Was a great help. I would not figured this out myself. in line 33 it seems need to be  ex = .jgetEx() # save exceptions from PreparedStatement.executeBatch() ...
3429 Jan 2014 @ 06:57 PSTkeep it simpleUpdate on copy / move data between systemsDo you use native archive? Or the tool mentioned above?
3317 Jan 2014 @ 07:21 PSTkeep it simpleA wider test case on R JDBC fastloadHi, didn't tried it so far. Have you in the mean time? Maybe I find next week some time to check this... Ulrich
3207 Dec 2013 @ 01:09 PSTcarrie's blogEasing Into Using the New AutoStats FeatureHi Carrie, thanks for sharing this! I was not able to find the orange book "Automated Statistics Management" by searching the tays knowledge search. Can you give me a hint where to find...
3126 Nov 2013 @ 12:55 PSTamarek's blogHow to use JDBC PreparedStatement batch INSERT with RHi Amarek, good post. But it would be even nicer of the code section could be copied and would not require a complete retyping for the validation ;-). Ulrich
3002 Nov 2013 @ 12:33 PDTkeep it simpleUpdate on copy / move data between systemsHi Suhail, yes, as stated in the text ;-) "To avoid data landing on file we implemented it with a named pipe solution which means the backup writes to a named pipe and the restore read from ...
2923 Oct 2013 @ 10:51 PDTConnectivityHow to use the Teradata JDBC Driver with teradataROn http://www.teradata.com/News-Releases/2013/Teradata-Offers-First-Fully-Parallel-Scalable-R-Analytics/ This is very interesting but also very different to teradataR as it requires separate licen...
2805 Jun 2013 @ 11:16 PDTConnectivityHow to use the Teradata JDBC Driver with teradataRI support this question! Are there plans to support R 3.0.0? Or if there are no plans to work on this - why not release the source code as open source?  
2724 May 2013 @ 10:57 PDTkeep it simpleCalculation of Table Hash Values to Compare Table Contentulrich.arndt@data2knowledge.de - see also last page of the slides ;-)

Pages