|68||31 Aug 2016 @ 05:02 PDT||Tools||Teradata Python Module||@Radsubra1 - Here is a simple example that writes the string representation of the row to a file named "result.txt".
with open ('result.txt', 'w') as file:
|67||26 Jul 2016 @ 09:56 PDT||Tools||Teradata Python Module||@eo186005 - Can you e-mail me the log file with DEBUG enabled? Also, what OS are you running on, and what session character set is being used? If you change the session character set ... |
|66||07 Jul 2016 @ 02:54 PDT||Tools||Teradata Python Module||@aagrawal - If you're building python from source, make sure you are building it with SSL support. For Python to be built with SSL support, the openssl header files need to be installed ... |
|65||07 Jul 2016 @ 09:34 PDT||Tools||Teradata Python Module||@aagrawal - Looks like you are missing the setuptools module. Instructions to install it can be found here: https://pypi.python.org/pypi/setuptools
|64||06 Jul 2016 @ 06:28 PDT||Tools||Teradata Python Module||@dn186005 - The Teradata Python module looks for the config file relative to the working directory and not the directory the script is located in. Try changing to the directory where your sc... |
|63||13 Jun 2016 @ 09:40 PDT||Tools||Teradata Python Module||@Ali - The reason the results of SHOW TABLE were not displayed properly on the terminal is because the newline characters in the result were most likely carriage returns instead of line feeds.... |
|62||30 May 2016 @ 08:59 PDT||Tools||Teradata Python Module||@nani - Move the line "udaExec = teradata.UdaExec(..." above the "for" loop. udaExec should only be initializd once. Its not that the query is being executed... |
|61||02 May 2016 @ 12:03 PDT||Tools||Teradata Python Module||@privet3711 - Whenever these non-sense error codes/messages come back from the ODBC driver manager, it usually means the Teradata ODBC driver was not found. This could be either bec... |
|60||21 Apr 2016 @ 09:56 PDT||Tools||Teradata Python Module||Here is a simple example of creating and calling a SQL Stored Procedure with both an input and output parameter. Note that Teradata REST and ODBC do not support creating non-SQL based Stored... |
|59||01 Feb 2016 @ 10:42 PST||Tools||Teradata Python Module||@Asim - I've engage the ODBC support team and support for streaming output parameters is not currently available in the Teradata ODBC driver. However, there are several workarounds y... |
|58||28 Jan 2016 @ 09:47 PST||Tools||Teradata Python Module||Hi Asim,
Regarding question 1, there are several ways to go about it. One suggestion would be to organize your logic into functions and then call those functions within the "with"... |
|57||27 Jan 2016 @ 08:20 PST||Tools||Teradata Python Module||@davidtzoor - I'm working on a fix to improve fetch performance. Progress can be tracked here: https://github.com/Teradata/PyTd/issues/29
|56||13 Jan 2016 @ 01:14 PST||Tools||Teradata Python Module||@stk8806 - From the stack trace, it appears the connection was successful but the python modules call to "SELECT SESSION" to get the session ID for logging purposes is not returning any d... |
|55||13 Jan 2016 @ 01:02 PST||Tools||Teradata Python Module||@ankitp - Try changing
session = udaExec.connect(method="odbc", system="TeradataPY",
session = ud... |
|54||07 Jan 2016 @ 11:52 PST||Tools||Teradata Python Module||@blackpf77 - I believe the LD_LIBRARY_PATH is what is used to load libraries. You could try setting this environment variable to the path of the Teradata ODBC driver libraries. E... |
|53||07 Jan 2016 @ 10:34 PST||Tools||Teradata Python Module||@blackpf77 - On my test Linux systems, the Teradata ODBC driver install creates a softlink that points to the Teradata installed driver manager:
ls -l /usr/lib/libodbc.so
lrwxrwxrwx. 1 ... |
|52||02 Jan 2016 @ 03:43 PST||Tools||Teradata Python Moduleemail@example.com - The OutParam object takes a size argument, which is the size of the buffer to allocate to receive the value of the output parameter. Try setting this value to a value gr... |
|51||17 Dec 2015 @ 02:15 PST||Tools||Teradata Python Module||@blackpf77 - I am not an ODBC expert but I believe the Linux Teradata ODBC package includes a DataDirect ODBC driver manager. It is this driver manager that should be used and not unixOdbc. ... |
|50||16 Dec 2015 @ 11:40 PST||Tools||Teradata Python Module||@amentro - The Python module hasn't been tested on AIX, however the module is 100% python so its possible it will just work. You'll have to give it a try to know for sure.
|49||11 Dec 2015 @ 04:45 PST||Tools||Teradata Python Module||@hkkanuru - I haven't tried using Jython. I've read though that support for the ctypes module in Jython is incomplete. The tdodbc implementation in the python module uses c... |
|48||11 Dec 2015 @ 04:29 PST||Tools||Teradata Python Module||@blackpf77 - You only specify host when using REST, this value is suppose to be the hostname of the Teradata REST Service. When using ODBC, you only need to specify system which should be th... |
|47||10 Dec 2015 @ 01:52 PST||Tools||Teradata Python Module||@blackpf77 What is the system value you are providing? It should be the tdpid of the system (e.g. the value of DBCName in odbc.ini terms).
|46||07 Dec 2015 @ 05:39 PST||Tools||Teradata Python Module||@lnsaf - Can you provide Python version and OS you are running with? Are there any non-ascii characters that you know of as part of your configuration/environment (e.g. Application Name, OS u... |
|45||21 Nov 2015 @ 01:26 PST||Tools||Teradata Python Module||@nani255 - Can you provide the last few lines of output of "setup.py install" E.g. ("Installed /usr/lib/python3.4/site-packages/teradata-220.127.116.11-py3.4.egg").
Is the version o... |
|44||19 Nov 2015 @ 06:42 PST||Tools||Teradata Python Module||@nani255 - Your errors look like python environment issues. Did you run "pip install teradata"? This will install the Teradata Python Module so that it is available... |