#DateForumTypeThreadPost
4408 Jun 2016 @ 12:16 PDTToolsReplyInstalling tools on UbuntuUnfortunately 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...
4318 Feb 2016 @ 10:04 PSTDatabaseReplyError compare timeslocation 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...
4227 Jan 2016 @ 04:59 PSTToolsTopicTPT Export to a Data Connector questionI'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...
4117 Dec 2015 @ 02:46 PSTToolsReplyBTEQ 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 ...
4013 Nov 2015 @ 11:40 PSTToolsReplyError 9128 : Transaction exceeds max. number of Row Hash locksSimply 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...
3913 Nov 2015 @ 11:29 PSTToolsReplyBTEQ TPTOk, 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;')  ...
3812 Nov 2015 @ 08:00 PSTToolsReplyhow can i remove the extra spaces when using bteq to export data into a flat txt fileIf 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...
3712 Nov 2015 @ 07:44 PSTToolsReplyBTEQ TPTif 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...
3612 Nov 2015 @ 06:56 PSTToolsReplyScheduling Stored Procedures in TeradataFirst 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...
3512 Nov 2015 @ 06:24 PSTToolsReplyTTU (linux) silent installation or chef recipeThe 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...
3423 Aug 2015 @ 02:18 PDTTeradata StudioReplySQL History Import Erroryour 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...
3319 Aug 2015 @ 02:52 PDTToolsReplyLoad 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...
3228 May 2015 @ 01:10 PDTDatabaseReplyseparate the column valueThe 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 ...
3128 May 2015 @ 12:35 PDTDatabaseReplyFinding last character of a stringSubstr 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...
3028 May 2015 @ 12:15 PDTDatabaseReplyimport data from file in to teradata tableIf 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...
2924 May 2015 @ 01:09 PDTToolsReplyTDGeoimport on LinuxTDGeoimport 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.  
2817 Apr 2015 @ 12:41 PDTDatabaseReplyIs 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...
2724 Jan 2015 @ 10:58 PSTGeneralReplyTeradata Packdisk Job Scheduleyou 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) ...
2624 Jan 2015 @ 09:41 PSTToolsReplyOracle.Net Not under Connection DialogueSQL 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?
2524 Jan 2015 @ 09:32 PSTToolsReplyTeradata 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...
2424 Jan 2015 @ 09:27 PSTToolsReplyNumber of Utility Load SlotsIt 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...
2324 Jan 2015 @ 08:58 PSTDatabaseReplyCapture Query transfer volumeSteven, 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...
2224 Jan 2015 @ 07:33 PSTDatabaseReplywanted to get interval time in the format of Hour:Minute:SecondsI 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...
2124 Jan 2015 @ 06:51 PSTDatabaseReplyCreate 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...
2024 Jan 2015 @ 06:32 PSTDatabaseReplyEncryption in TeradataIf 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...

Pages