35 | 18 Aug 2016 @ 05:30 PDT | Database | Reply | Declaring variables in Terdata SQL Assistant | DECLARE 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... |
34 | 18 Aug 2016 @ 05:20 PDT | Teradata Database on VMWare | Reply | How to change i.p of a TD VM Image | It 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... |
33 | 01 Jun 2016 @ 12:35 PDT | Tools | Reply | Using 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
|
32 | 27 May 2016 @ 07:28 PDT | Tools | Reply | Using 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... |
31 | 26 May 2016 @ 02:33 PDT | Tools | Topic | Using 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 ... |
30 | 20 May 2016 @ 07:03 PDT | Tools | Reply | Need help in using SQL Assistant | What 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... |
29 | 02 May 2016 @ 04:24 PDT | Connectivity | Reply | Can 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... |
28 | 12 Feb 2016 @ 07:59 PST | Tools | Topic | $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 ... |
27 | 29 Jan 2016 @ 07:44 PST | Connectivity | Reply | Is 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 ... |
26 | 15 Jan 2016 @ 06:08 PST | Cloud Computing | Reply | Teradata Express VMWare 15.10.0.7 with Viewpoint | This 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 ... |
25 | 12 Jan 2016 @ 06:06 PST | Cloud Computing | Topic | Teradata Express VMWare 15.10.0.7 with Viewpoint | I 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... |
24 | 23 Dec 2015 @ 12:17 PST | Teradata Studio | Reply | EXPLAINing a query using variables | You 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 ... |
23 | 21 Dec 2015 @ 06:15 PST | Teradata Studio | Reply | EXPLAINing a query using variables | I 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... |
22 | 16 Dec 2015 @ 08:43 PST | Teradata Studio | Reply | EXPLAINing a query using variables | Francine,
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 ... |
21 | 15 Dec 2015 @ 11:17 PST | Teradata Studio | Topic | EXPLAINing a query using variables | Following 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... |
20 | 09 Oct 2015 @ 05:16 PDT | General | Reply | Docker Teradata Client | Thanks. 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... |
19 | 12 Sep 2015 @ 07:23 PDT | Connectivity | Reply | Installing Teradata ODBC Driver in CYGWIN | Windows 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... |
18 | 31 Jul 2015 @ 02:46 PDT | Database | Reply | How 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... |
17 | 07 Jul 2015 @ 03:14 PDT | Database | Reply | SET table with PPI - optimizer plan | Yes. 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... |
16 | 02 Jul 2015 @ 01:53 PDT | Database | Reply | SET table with PPI - optimizer plan | For 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.
|
15 | 09 Jun 2015 @ 12:49 PDT | Database | Reply | Analyzing 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... |
14 | 05 Jun 2015 @ 01:38 PDT | Database | Reply | Import Null Values | Dieter,
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?
... |
13 | 21 Jan 2015 @ 09:01 PST | Database | Reply | Seeking ideas: need to grab next available UPI for inserts | That's pretty slick!
|
12 | 21 Jan 2015 @ 08:34 PST | Database | Reply | Seeking ideas: need to grab next available UPI for inserts | If 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... |
11 | 18 Jun 2014 @ 02:23 PDT | Connectivity | Reply | Connecting Python to Teradata over ODBC | Teradata 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.
|