PyTd
PyTd copied to clipboard
A Python Module to make it easy to script powerful interactions with Teradata Database in a DevOps friendly way.
'select ?;' crashed with seg fault with both Teradata 15.10 and 16.0 ODBC drivers. This can be reproduced on OS X as well as CentOS. Script to reproduce: ``` import...
Hi , I am getting below while connecting Teradata using Python. Traceback (most recent call last): File "C:\Python27\Lib\site-packages\hello.py", line 5, in session = udaExec.connect(method="odbc", system="xxx",username="xxx", password="xxx!"); File "C:\Python27\Lib\site-packages\teradata\udaexec.py", line 183,...
I think it's best to keep all result sets. For example if one runs a parameterized select statement using the `executemany` method, he definitely wants to keep all results rather...
The need to escape `$` sign has caused confusions. Why not enforce parameters to be of the form ${param} and drop the need to escape `$` sign?
Hi Team, I am seeing a typical problem in execution on Teradata queries from Python pertaining to ODBC driver. The same script is working fine with root user. Error Message:...
I am having problems with bteqsplit() when semicolons are included inside comments. The bteqsplit is finding the semicolon and producing an invalid sql statement. Some of the examples I have...
Python DB API standards defines [here](https://www.python.org/dev/peps/pep-0249/#description) what values a DB API compliant driver can return via `cursor.description`. From what I observed: - `precision` and `scale` are wrong. The actual `scale`...
This is probably related to #49. When that is fixed, hopefully this one will be fixed as well -- but just wanted to put his one out for tracking. ```...
Leading spaces seem to be always removed when running queries using `teradata.tdrest` module. For example, following code returns a result set with spaces removed from the first column but the...
Version: 15.10.0.16 Python 3.5.32 Line 31 in the setup.py should use open(os.path.dirname(os.path.realpath(**file**)) + '\teradata\version.py' ) instead of just 'teradata/version' Line 42 should follow this as well. The setup.py also does...