#DateWhereItemComment
4316 Nov 2015 @ 11:02 PSTToolsTeradata Python Module@ejeff1275 - The "Keywords for SQLDriverConnect" section of the Teradata ODBC user guide cover the keywords that can be set via argument or external configuration to the Python module'...
4206 Nov 2015 @ 02:30 PSTToolsTeradata Python Module@Kanda - Can you make sure that ODBCINST or ODBCINI environment variables exist and if not, set them like below assuming you are running on 64-bit Linux?  These environment variables tell...
4104 Nov 2015 @ 09:51 PSTToolsTeradata Python Module@cw171001 - Setting external variables programatically is covered in the External Configuration section of the documentation.   There is a simpler way to set these variables, I've updated ...
4022 Oct 2015 @ 01:34 PDTToolsTeradata Python Module@vkrmsv - Can you make sure that ODBCINST or ODBCINI environment variables exist and if not, set them like below assuming you are running on 64-bit Linux?  These environment variables tell the...
3916 Oct 2015 @ 06:23 PDTToolsTeradata Python Module@gabnash - The way you get column names is defined as part of the Python Database API 2.0 specification.  Here is an example: cursor = conn.execute("SELECT * FROM Whatever") ...
3808 Oct 2015 @ 09:47 PDTToolsTeradata Python Module@alpanchino -  I see you are using REST.   This is actually a limitation of the current Teradata REST interface.  There is an open JIRA (REST-310) to add this support in its next rel...
3707 Oct 2015 @ 10:34 PDTToolsTeradata Python Module@rlobera - The Python module expects a decimal point to be used in decimals instead of a comma when retreiving numbers from the ODBC driver.   Can you try updating your data source to specify ...
3607 Oct 2015 @ 09:24 PDTToolsTeradata Python Module@alpanchino - I am unable to reproduce the error you are experiencing and can successfully insert and update clob values of multiple MBs using the python module.   Can you first make sure you ...
3506 Oct 2015 @ 03:11 PDTToolsTeradata Python Module@rlobera - Could you clarify the issue you are having with a simple example?
3406 Oct 2015 @ 01:57 PDTToolsTeradata Python Module@sunnysteve - Here is how the connect method should look in the Hello World example if using REST: session = udaExec.connect(method="rest", host="resthost.example.com", syste...
3305 Oct 2015 @ 02:10 PDTToolsTeradata Python Module@pwspann - A new version of the module has been released that fixes the escape issue you encountered.    The 15.10.00.09 version also includes a couple other fixes/enhancements.
3202 Oct 2015 @ 01:12 PDTToolsTeradata Python Module@pwspann - I will investigate a fix but in the meantime escaping it twice when its in the config file (e.g. "$$$$") should work.
3102 Oct 2015 @ 07:55 PDTToolsTeradata Python Module@cw171001 - As per the Python DB API specification, the Cursor object provides a rowcount attribute that should provide the count you're are looking for.  E.g.   cursor = session.exe...
3002 Oct 2015 @ 07:05 PDTToolsTeradata Python Module@pwspann - If your username or password includes a "$", you need to escape it using "$$", otherwise the Python module thinks you are referring to an external configuration varia...
2901 Oct 2015 @ 05:57 PDTToolsTeradata Python Module@yottadata - If you go to the http://www.info.teradata.com web site and search for Teradata REST Services, you will find the Teradata REST Services installation guide which covers how to downl...
2801 Oct 2015 @ 10:23 PDTToolsTeradata Python Module@rlobera -  Is the "TERADATA" system you are referring to its TDPID or is it an ODBC DSN?    If its the TDPID,  then make sure TERADATA or TERADATAcop1 is resolveable...
2728 Sep 2015 @ 10:35 PDTToolsTeradata Python Module@cw171001 -  I created an SP with the same signature that returns output parameters with the maximum number of characters but I am unable to reproduce the error you are hitting.    C...
2624 Sep 2015 @ 11:38 PDTToolsTeradata Python ModulePython3.4 is suppose to include setuptools and pip so not sure why those modules cannot be found.  Can you try executing the following command? python3.4 -m ensurepip  
2522 Sep 2015 @ 10:56 PDTToolsTeradata Python Module@Roopalini - Give one of the following a try: python3.4 setup.py install or python3.4 -m pip install teradata
2418 Sep 2015 @ 09:38 PDTToolsTeradata Python Module@eo186005 - Unfortunately no, the connectivity methods supported by the Python module (ODBC and REST) do not support deploying external UDF code at this time.  I've opened feature req...
2317 Sep 2015 @ 02:05 PDTToolsTeradata Python Module@seabull - Your example works for me.  Please try upgrading your Teradata Python Module to the latest version as I belive there was a bug that has since been fixed that may be causing the issu...
2213 Sep 2015 @ 07:26 PDTToolsTeradata Python Module@ryanv -  Yes, the query timeout parameter only supports integers.  Fractional second timeouts are not supported by ODBC.  
2110 Sep 2015 @ 11:27 PDTToolsTeradata Python Module@seabull - You can import it using "from teradata.udaexec import UdaExecConnection", but I would not recommend it as its not part of the interface exposed by UdaExec and could change at a...
2005 Sep 2015 @ 08:29 PDTToolsTeradata Python Module@psobczak - Good suggestion.  I created an enhancement request on github for this feature.
1904 Sep 2015 @ 12:24 PDTToolsTeradata Python Module@cw171001 - Here is an example: try: session.execute("INVALID") except teradata.DatabaseError as e: print(e.code)  

Pages