Are the various 'JDBC Connection Properties' options and allowed values listed anywhere? I have searched here, on the Teradata manuals page and through the 'Teradata jdbc reference' manual but I can't find anything.
Some of them I know (charset, tmode etc), some of them I have found in otehr posts (e.g. I found one that said 'tnano' is now ignored and was only for the fastload connection), but it would be really useful if they were all listed in one place.
I'm assuming that list is available, but if someone could point me to it that would be very helpful.
The entire Teradata JDBC Driver Reference is available here on Developer Exchange.
And here is a direct link to the relevant section covering all the Teradata JDBC Driver connection properties.
>>> I found one that said 'tnano' is now ignored and was only for the fastload connection
That is incorrect. The opposite is true. The TNANO connection parameter is used for SQL connections, and is ignored for JDBC FastLoad and FastExport connections. Here is a link to the documentation:
That's brilliant, tnaks very much.