44 | 08 Jun 2016 @ 12:16 PDT | Tools | Reply | Installing tools on Ubuntu | Unfortunately Ubuntu is not a support platform for the Teradata Utilities so your trying to install in a disto that is not supported. SUSE and RedHat are the only two supported distros (cent... |
43 | 18 Feb 2016 @ 10:04 PST | Database | Reply | Error compare times | location shouldn't affect that. Time is time no matter where you are.
What version of the database are you running? I see the same results as what Carlos is showing.
&nbs... |
42 | 27 Jan 2016 @ 04:59 PST | Tools | Topic | TPT Export to a Data Connector question | I'm trying to setup a generic macro to generate TPT Exports that write to a DataConnector to generate delimited flat files. The issue i'm running into is that the Export operator appe... |
41 | 17 Dec 2015 @ 02:46 PST | Tools | Reply | BTEQ Problem when reporting column that has a UDF that returns varchar(80) | I believe the regex functions converts the data to max size varchar in unicode, you will need to cast your result back to latin if you want to use varchar. It works with char because char is ... |
40 | 13 Nov 2015 @ 11:40 PST | Tools | Reply | Error 9128 : Transaction exceeds max. number of Row Hash locks | Simply stated...the database will abort your job to keep it from consuming all available row locks which will prevent all other users from being able to use the system. There are a finite nu... |
39 | 13 Nov 2015 @ 11:29 PST | Tools | Reply | BTEQ TPT | Ok, so here is a sample script to do make TPT do what you would do in BTEQ...
DEFINE JOB BTEQ_INS_SEL
(
APPLY ('insert into mytable select * from thistable;')
 ... |
38 | 12 Nov 2015 @ 08:00 PST | Tools | Reply | how can i remove the extra spaces when using bteq to export data into a flat txt file | If you want to output data in bteq and get the data without the spaces between the delimiters, then you wouldn't be able to use 'Sel TOP 10 *...' You would have to list the column... |
37 | 12 Nov 2015 @ 07:44 PST | Tools | Reply | BTEQ TPT | if your wanting to move data from a set of tables in the database using an insert/select with some complex logic. You could do this with either TPT or BTEQ.
However, you would not us... |
36 | 12 Nov 2015 @ 06:56 PST | Tools | Reply | Scheduling Stored Procedures in Teradata | First off, do you need to schedule this from your desktop? Can you (or are you allowed to) build a bteq job from a linux server where you could use cron?
If not, then you can actually... |
35 | 12 Nov 2015 @ 06:24 PST | Tools | Reply | TTU (linux) silent installation or chef recipe | The newer versions of the TTU for Linux are supposed to allow for silent install, however, for our shop I built a wrapper script to allow for passing the variables to the install in order to ensure... |
34 | 23 Aug 2015 @ 02:18 PDT | Teradata Studio | Reply | SQL History Import Error | your using the 64 bit Studio/Studio Express...SQL Assistant is a 32 bit application, you can't import into the 64bit versions, it can only be imported using the import method in the 32bit versi... |
33 | 19 Aug 2015 @ 02:52 PDT | Tools | Reply | Load file | @feinholz, if you want folks to move to TPT, you really need to fix it so it can consume standard input like BTEQ, Fastload, FastExport, Mload so that tool can be more flexible in how it can be use... |
32 | 28 May 2015 @ 01:10 PDT | Database | Reply | separate the column value | The count you got is correct based on how your returning the data. You grouped by Name and Domain_Name, So in this case,
Name = a
Domain_Name = gmail.com
is not the same as
... |
31 | 28 May 2015 @ 12:35 PDT | Database | Reply | Finding last character of a string | Substr is really about the only function that lets you pull a single value out, especially depending on what version of the database you are on. I guess you could build a UDF that might do so... |
30 | 28 May 2015 @ 12:15 PDT | Database | Reply | import data from file in to teradata table | If your clob is only 25k, then change the definition to varchar(25000), then you could load using mload. If you want to load data as a clob, then you can only use bteq with deferred or tpt st... |
29 | 24 May 2015 @ 01:09 PDT | Tools | Reply | TDGeoimport on Linux | TDGeoimport is a windows only tool. It is using some libraries that only work in windows, so there isn't a version that I am aware of that will run in Linux.
|
28 | 17 Apr 2015 @ 12:41 PDT | Database | Reply | Is it possible to catch inserted varibles in logging? | prior to Teradata database version 15.00, no there isn't an easy way to capture values from parameterized queries. In Teradata database version 15.00 there is a new dbql table called DBQL... |
27 | 24 Jan 2015 @ 10:58 PST | General | Reply | Teradata Packdisk Job Schedule | you can write a script to look at your system to see if you need to run packdisk and then only trigger it if you need to run it.
you can run these from a script on the PDN (primary node)
... |
26 | 24 Jan 2015 @ 09:41 PST | Tools | Reply | Oracle.Net Not under Connection Dialogue | SQL Assistant is still a 32bit application i believe (even with version 15) i'm not sure it can use the 64bit .NET is there a 32bit .Net from Oracle you try?
|
25 | 24 Jan 2015 @ 09:32 PST | Tools | Reply | Teradata SQL Assistant (SQL to highlight columns in results) | i'm pretty sure what your asking for isn't doable inside SQL Assistant. It doesn't provide facilities to do that with-in SQL Assistant like you might be able to do inside Excel or... |
24 | 24 Jan 2015 @ 09:27 PST | Tools | Reply | Number of Utility Load Slots | It can be difficult to determine how many "loads" could be run at a time to not impact other production work. For example a single large mload could have more impact than several sm... |
23 | 24 Jan 2015 @ 08:58 PST | Database | Reply | Capture Query transfer volume | Steven,
as far as being able to see volume of data being produced by a query, no, that isn't doable that I have seen. You can look at the resusage tables to see overall volume of data be... |
22 | 24 Jan 2015 @ 07:33 PST | Database | Reply | wanted to get interval time in the format of Hour:Minute:Seconds | I took your example and it works for me.
Select
cast(cast(timestamp '2005-03-18 15:50:04.000000' as varchar(19)) as timestamp(0)) as A1,
cast(cast(timestamp '20... |
21 | 24 Jan 2015 @ 06:51 PST | Database | Reply | Create a table with a date column that has a default lenght (8) | what does your data actually look like for your insert statement? (at least format-wise). Is the issue that the date your trying to insert isn't working or that when you try to insert for... |
20 | 24 Jan 2015 @ 06:32 PST | Database | Reply | Encryption in Teradata | If your asking if Teradata has native functions to provide data encryption outside of the password fields in DBC and a few other system tables, then the answer is no. Generally, you would hav... |