| 51 | 08 Mar 2016 @ 12:12 PST | keep it simple | Extract and Analyse Database Object Dependencies | Hi 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 ... |
| 50 | 01 Feb 2016 @ 01:05 PST | keep it simple | Extract and Analyse Database Object Dependencies | not 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... |
| 49 | 07 Aug 2015 @ 01:46 PDT | Tools | Teradata 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... |
| 48 | 07 Aug 2015 @ 01:42 PDT | Tools | Teradata Python Module | @eric thanks for the clarification!
The workaround / the solution worked fine.
|
| 47 | 06 Aug 2015 @ 05:59 PDT | Tools | Teradata Python Module | Hi 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... |
| 46 | 06 Aug 2015 @ 12:59 PDT | Tools | Teradata Python Module | Hi Eric,
works like a charm!
Ulrich
|
| 45 | 05 Aug 2015 @ 02:03 PDT | Tools | Teradata Python Module | Solved 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... |
| 44 | 05 Aug 2015 @ 01:41 PDT | Tools | Teradata Python Module | Eric,
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... |
| 43 | 03 Aug 2015 @ 05:24 PDT | Tools | Teradata Python Module | Hi 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... |
| 42 | 29 Jul 2015 @ 01:09 PDT | Tools | Teradata Python Module | Quite 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... |
| 41 | 17 Jul 2015 @ 04:49 PDT | keep it simple | Example Java UDF for Table Hash Calculations | P.S. maybe try also a different browser - it seems some have issues with the developer.teradata.com page...
|
| 40 | 17 Jul 2015 @ 04:42 PDT | keep it simple | Example Java UDF for Table Hash Calculations | At the top of the page where the bog text starts on the right side is a section attachement. I get three files listed there...
|
| 39 | 10 Dec 2014 @ 01:37 PST | UDA | Working with Identity Columns and Unity Director and Loader | Hi 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... |
| 38 | 10 Dec 2014 @ 04:47 PST | UDA | Working with Identity Columns and Unity Director and Loader | Paul,
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... |
| 37 | 02 Dec 2014 @ 05:30 PST | Connectivity | Access External Data - A Table UDF | Where can we find the download?
|
| 36 | 06 Aug 2014 @ 04:48 PDT | Tools | udaSQL - A DevOps Focused SQL Execution Engine | Hi Mike,
I am not able to see the attached udaSQL.zip file.
Is it gone?
Ulrich
|
| 35 | 04 Feb 2014 @ 12:37 PST | amarek's blog | How to capture chained JDBC FastLoad SQLException/SQLWarning messages and stack trace with R | Hi 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()
... |
| 34 | 29 Jan 2014 @ 06:57 PST | keep it simple | Update on copy / move data between systems | Do you use native archive? Or the tool mentioned above?
|
| 33 | 17 Jan 2014 @ 07:21 PST | keep it simple | A wider test case on R JDBC fastload | Hi, didn't tried it so far.
Have you in the mean time?
Maybe I find next week some time to check this...
Ulrich
|
| 32 | 07 Dec 2013 @ 01:09 PST | carrie's blog | Easing Into Using the New AutoStats Feature | Hi 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... |
| 31 | 26 Nov 2013 @ 12:55 PST | amarek's blog | How to use JDBC PreparedStatement batch INSERT with R | Hi 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
|
| 30 | 02 Nov 2013 @ 12:33 PDT | keep it simple | Update on copy / move data between systems | Hi 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 ... |
| 29 | 23 Oct 2013 @ 10:51 PDT | Connectivity | How to use the Teradata JDBC Driver with teradataR | On 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... |
| 28 | 05 Jun 2013 @ 11:16 PDT | Connectivity | How to use the Teradata JDBC Driver with teradataR | I 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?
|
| 27 | 24 May 2013 @ 10:57 PDT | keep it simple | Calculation of Table Hash Values to Compare Table Content | ulrich.arndt@data2knowledge.de - see also last page of the slides ;-)
|