#DateForumTypeThreadPost
1221 Nov 2013 @ 02:32 PSTToolsReplyExport to delimited fileI only took out the top 20 after the select statement and then ran it again copying from the command line.  The sql code runs fine in sql assist.  I keep running into the error of the num...
1121 Nov 2013 @ 01:40 PSTToolsTopicExport to delimited fileI have created a tpt export job from a sample script and if I limit the records to a small number the job run fine.  When I take out the record number constraint the job doesnt run.  Time...
1008 Nov 2013 @ 09:43 PSTDatabaseReplyDelete or Drop a table if it already existsThis code works great in SQL Assistant.  Any suggestions in making it work in a Teradata odbc connected gui like alteryx?     
908 Sep 2010 @ 05:34 PDTDatabaseTopicBTEQ script helpI am not familiar with bteq and scripting capabilities. I need to write a teradata script that is invoked by a unix shell under cron and checks to see if the data has been updated in a specific ta...
812 May 2010 @ 11:08 PDTAnalyticsReplyOLAP functionsI figured it out by doing some testing. the one that works is row_num() over(partition by customer id order by customer id, date field) as rownum at the end of the query you include.... qual...
711 May 2010 @ 05:41 PDTAnalyticsTopicOLAP functionsI am trying to utilize the olap functions to speed up a large query. In particular, a person can show up more than one time in a day across several days. It looks like this: day1 abc day1 a...
618 Sep 2009 @ 05:43 PDTDatabaseReplyconvert char timestamp to TD timestampI figured it out.select cast(substr(datetime,1,11) as date format 'ddbmmmbyyyy'),cast(substr(datetime,13,8) as time(0))
518 Sep 2009 @ 01:25 PDTDatabaseTopicconvert char timestamp to TD timestampI have to convert this character timestamp to be able to extract date parts and or time parts for calculations. The fields look like this. I have tried casting the field in various ways and nothi...
412 Nov 2008 @ 01:55 PSTToolsTopicmask part of a numeric fieldI have to mask the last 4 digits of a numeric field with xxxx within a sql statement. What is the easiest way to do that?
320 Oct 2008 @ 03:01 PDTToolsTopicFast Load errorI keep getting this message when I try to run fast load from the unix command line. The code runs fine if I "cut and paste" into the command line but I need to get it to run from the command line....
203 May 2006 @ 12:16 PDTDatabaseTopiccast a timestamp value as a time valueI have a timestamp field that I want to cast as a time value.The data in the field values look like this:2005-12-07 09:32:39I just want the HH:MM portion of the timestamp. I tried different varian...
128 Apr 2006 @ 03:59 PDTDatabaseTopicextract text string from text field in columnI have a table with email addresses and I need to extract out the name before the @ in the address. Data looks likes this in the column.joenoname@noname.com?jillnoname@noname.combob.k.noname@nonam...