#DateWhereItemComment
704 Nov 2015 @ 01:49 PSTToolsTeradata Python ModuleResolved , after looking at teradata module code csr=session.cursor() for row in csr.execute("""     SEL TOP 10 trim(databasename) db,trim(tablename) tbl from dbc...
604 Nov 2015 @ 12:37 PSTToolsTeradata Python ModuleI 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...
502 Oct 2015 @ 07:27 PDTToolsTeradata Python ModuleHi 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...
425 Sep 2015 @ 10:46 PDTToolsTeradata Python ModuleHi 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...
304 Sep 2015 @ 11:12 PDTToolsTeradata Python ModuleHow 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
231 Jul 2015 @ 03:11 PDTToolsTeradata Python ModuleHi 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...
130 Jul 2015 @ 04:26 PDTToolsTeradata Python ModuleHi 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...