|7||04 Nov 2015 @ 01:49 PST||Tools||Teradata Python Module||Resolved , after looking at teradata module code
for row in csr.execute("""
SEL TOP 10 trim(databasename) db,trim(tablename) tbl from dbc... |
|6||04 Nov 2015 @ 12:37 PST||Tools||Teradata Python Module||I would like to manipulate the external parameters on the fly , instead of passing the external parameter on the command line , in the udaexec.ini file. I can achieve this by using a string Te... |
|5||02 Oct 2015 @ 07:27 PDT||Tools||Teradata Python Module||Hi
How would I simulate the following bteq
INSERT INTO .....
.IF ERRORCODE <> 0 THEN .QUIT 1
.IF ACTIVITYCOUNT = 0 THEN .QUIT 1
I know how to catch the error code with th... |
|4||25 Sep 2015 @ 10:46 PDT||Tools||Teradata Python Module||Hi
I am calling a stored procedure which has a big var chars , and I am getting the following error
teradata.api.DatabaseError: (9804, '[HY000] [Teradata][ODBC Teradata Driver][Teradata Datab... |
|3||04 Sep 2015 @ 11:12 PDT||Tools||Teradata Python Module||How do I find out what the error code is returned from executed sql statement. I dont want python to exit when a sql statement returns an error but I want to do some processing when a error occurs
|2||31 Jul 2015 @ 03:11 PDT||Tools||Teradata Python Module||Hi Eric
Found the issue , it does work perfectly. It is the way the print command behaves when printing to screen. When I redirect to file its perfect.
I am going to re-write a gcfr export enviro... |
|1||30 Jul 2015 @ 04:26 PDT||Tools||Teradata Python Module||Hi Eric
This is great . It looks like a great dba utility language.
One question . I extract show table statements in bteq and export to files. It would nice to be able to do this... ||