#DateForumTypeThreadPost
3518 Aug 2016 @ 05:30 PDTDatabaseReplyDeclaring variables in Terdata SQL AssistantDECLARE VARIABLE is an embedable, non-excutable statement meant for pre-processor (or stored-procedures). See http://www.ibm.com/support/knowledgecenter/SSEPEK_10.0.0/sqlref/src/tpc/db2z_sql_d...
3418 Aug 2016 @ 05:20 PDTTeradata Database on VMWareReplyHow to change i.p of a TD VM ImageIt is strange that you are getting the same IP address assigned to both VM. Teradata VM images use dhcp to obtain IP addresses from VMWare. You may try generating a new MAC address for one of the V...
3301 Jun 2016 @ 12:35 PDTToolsReplyUsing TPT templates to copy more than one table in a script.Hello Steve,   Were you able to reproduce the error with above script? Any idea if this is a TPT bug or a script error?   Thanks
3227 May 2016 @ 07:28 PDTToolsReplyUsing TPT templates to copy more than one table in a script.Steve,   Thank you for the prompt reply. Your version of the script indeed works. In my zeal to provide only the minimum needed script for diagnosis, I in fact supplied a script that's n...
3126 May 2016 @ 02:33 PDTToolsTopicUsing TPT templates to copy more than one table in a script.I am using following TPT script to load two tables from another Teradata system.  DEFINE JOB TPTLoad ( SET TargetWorkingDatabase = 'TGTDB'; SET LoadErrorLimit ...
3020 May 2016 @ 07:03 PDTToolsReplyNeed help in using SQL AssistantWhat I found helpful is, setting default role for my ID to ALL in development environments, but in production I set it to something that is less destructive. It is slightly annoying to have to...
2902 May 2016 @ 04:24 PDTConnectivityReplyCan not connect to TD from SQLA over home network, but can connect using BTEQ!If you specified /DBC as part of server name, remove that. In BTEQ you use / as separator followed by the username (which is DBC). In SQLA, you have separate fields for server name, user name and p...
2812 Feb 2016 @ 07:59 PSTToolsTopic$LOAD: TPT10507: CLI Error 302: CLI2: BADBUFRQ(302): Invalid buffer size.Using TPT loader and DataConnector version 15.10.01.00 produce above error. I am using following script to load about 100M rows   DEFINE JOB test_tbl ( SET TargetWorkingDatabase ...
2729 Jan 2016 @ 07:44 PSTConnectivityReplyIs it possible to connect to Teradata from Excel without installing Teradata drivers?Have you looked at Teradata REST Services (http://www.teradatamagazine.com/v15n01/Tech2Tech/Driverless-Connectivity/)? This solution will still requires Teradata REST services to be configured and ...
2615 Jan 2016 @ 06:08 PSTCloud ComputingReplyTeradata Express VMWare 15.10.0.7 with ViewpointThis might help someone in future. The second ID (viewpoint) that I added needed monitor privileges. It was somewhat catch22 - the GRANT button that would have generated the needed DCLs wasn't ...
2512 Jan 2016 @ 06:06 PSTCloud ComputingTopicTeradata Express VMWare 15.10.0.7 with ViewpointI don't know what I am doing wrong, but I am unable to register Teradata Express System as "monitored system" within viewpoint. I fill out all the required fields, the two required lo...
2423 Dec 2015 @ 12:17 PSTTeradata StudioReplyEXPLAINing a query using variablesYou are correct! I do have JRE 1.8. Is JRE 1.8 planned to be supported in near future? If so and if there are no other major issues reported, I'll just use SQL assistant workaround when I need ...
2321 Dec 2015 @ 06:15 PSTTeradata StudioReplyEXPLAINing a query using variablesI upgraded to 15.10.01 and I still get the same error (ArrayIndexOutOfBoundException:0).   Since you cannot reproduce the results, there might be something wrong with my configuration. Maybe...
2216 Dec 2015 @ 08:43 PSTTeradata StudioReplyEXPLAINing a query using variablesFrancine, Thanks for checking. I did try the "Execute All" as a work-around and received the same error that you did. Strangely, SQL Assistance (15.10.0.2) for me has no problem running ...
2115 Dec 2015 @ 11:17 PSTTeradata StudioTopicEXPLAINing a query using variablesFollowing runs fine in SQL Assistant and BTEQ, but Studio (15.10.4) throws generic "Parse Error splitting statement" error. explain using (infokey varchar(30)) select * from DBC.D...
2009 Oct 2015 @ 05:16 PDTGeneralReplyDocker Teradata ClientThanks. That should come in handy for running ODBC client on Linux flavors other than officially supported RHEL and SUSE. Another useful addition would be containerized Teradata REST API Servi...
1912 Sep 2015 @ 07:23 PDTConnectivityReplyInstalling Teradata ODBC Driver in CYGWINWindows ODBC driver works just fine under Cygwin. but you need to install pyodbc from pypi. Since pypi doesn't host binaries for Cygwin (or Linux for that matter), make sure you install toolcha...
1831 Jul 2015 @ 02:46 PDTDatabaseReplyHow to ensure atomic nature of multiple table actions?Let me take a stab at providing the answers.  Atomicity isn't unique to Teradata, all major databases support "Transactions", which are atomic (https://en.wikipedia.org/wiki/ACI...
1707 Jul 2015 @ 03:14 PDTDatabaseReplySET table with PPI - optimizer planYes. The uniqueness values exist just to make ROWKEY unqiue, which is partition+rowhash+unique. So it is possible for the same rowhash value to have same uniqueness value as long as they are in dif...
1602 Jul 2015 @ 01:53 PDTDatabaseReplySET table with PPI - optimizer planFor two rows to be exact duplicates, they would have to have the same partitioning column(s) values too. That means optimizer would need to check rows with the same rowhash in only one partition.
1509 Jun 2015 @ 12:49 PDTDatabaseReplyAnalyzing DBQL I haven't figured out a simpler way either. If you know some basic coding, you might try parsing XML explain and look at locking information at the begining of explain for more accurate answers...
1405 Jun 2015 @ 01:38 PDTDatabaseReplyImport Null ValuesDieter,   Since NULLable column require a presence bit, are NULL values not compressed automatically? If not, what value is stored in the physical row when a column does have a NULL value? ...
1321 Jan 2015 @ 09:01 PSTDatabaseReplySeeking ideas: need to grab next available UPI for insertsThat's pretty slick!
1221 Jan 2015 @ 08:34 PSTDatabaseReplySeeking ideas: need to grab next available UPI for insertsIf the gaps are truly random, then it's going to be difficult to use INS-SEL without using a fancy UDF.   Assuming the gaps are created by DELETEs, you can have a trigger that captures t...
1118 Jun 2014 @ 02:23 PDTConnectivityReplyConnecting Python to Teradata over ODBCTeradata ODBC driver comes with its own driver manager and does not support unixODBC. On openSUSE 13.1 these steps worked: a) uninstall unixodbc 2) build pyodbc from source. 

Pages