#DateForumTypeThreadPost
3808 Sep 2016 @ 12:19 PDTToolsReplySQL Assistant 15.00 TD 14.11.0.1 Doesn't Properly read first Parameter KeyBump - No one has seen or heard of this?  Update, seems to random, some queires it not an issue, others it is. I have tried things like retype it, but also copy/pate into Notepad to strip off ...
3701 Sep 2016 @ 09:38 PDTToolsTopicSQL Assistant 15.00 TD 14.11.0.1 Doesn't Properly read first Parameter KeyHi TD Forum, I am running on TD Ver 14, and have SQL Assistant 15.00, and when I run a query that has a prompt for two dates to be inout bythe user, the paramter promts of something like: where d...
3623 Jun 2016 @ 11:32 PDTDatabaseReplyError 7547 on UpdateThey both work, I see what you're saying about using defined alias and not original table name, I like the EXISTS as it's cleaner. Thank you very much Dieter
3523 Jun 2016 @ 09:22 PDTDatabaseReplyError 7547 on UpdateI see that product join,and I have made many joins after the set statement and still cant get past the spool
3423 Jun 2016 @ 09:10 PDTDatabaseReplyError 7547 on UpdateHere it is with datbase/table names changes to be like the example   UPDATE DA FROM DATABASENAME.DIG_ADOPT AS DA ,     (SELECT     DISTINCT(CG.ACCT_NBR) &nb...
3323 Jun 2016 @ 08:04 PDTDatabaseTopicError 7547 on UpdateHello, I'm running an update, and as I develop it, from updating everything incorrectly, to error 7547's, to spool space, and collecting stats on tables invloved, distinct, with and withou...
3215 Apr 2016 @ 03:29 PDTToolsReplyTPT Error loading CSV as Double QuotesI have change the numbers of 8 instances to 1, changed the operator type from INSERT to LOAD, eliminated the 3 lines about about optional double quotes just in case, and have expande...
3114 Apr 2016 @ 06:23 PDTToolsReplyTPT Error loading CSV as Double QuotesTTU15 and Teradata Platform 14. I'm using the Inserter operator as this is being used as a insert only, like a FastLoad. If this is not needed, I'd change to something more apropriate.&nbs...
3014 Apr 2016 @ 04:26 PDTToolsReplyTPT Error loading CSV as Double QuotesHi Steve, I do not want the header loaded, I alreayd do have the skiprows =1 in place.  Though this data file may not have double quoted text fields, I have it set as Optional', and test...
2914 Apr 2016 @ 02:41 PDTToolsTopicTPT Error loading CSV as Double QuotesHello, I'm loading a set of CSV files, some of which will have an occational double quoted text field, with a header. With this examples below, I keep getting a TPT error: DataConnection Error,...
2809 Mar 2016 @ 06:50 PSTDatabaseReplyLoading SQL Server TimeStamp Varchar to Teradata Table via TPTThank you Dieter, if I can't get a timestamp format change to the exported data, I'll use the vardate in/out method you mentioned.  
2709 Mar 2016 @ 06:44 PSTDatabaseReplyLoading SQL Server TimeStamp Varchar to Teradata Table via TPTCarlos, my apologies if I came off as ranting, clearly I'm frustrated, caused by perhaps doing this to get time: CAST((CASE WHEN (TRIM(SUBSTR(TRIM(TaskStartTime),INDEX(TaskStartTime,'...
2608 Mar 2016 @ 02:43 PSTDatabaseReplyLoading SQL Server TimeStamp Varchar to Teradata Table via TPTIf I'm stuck with only loading a date timestamp to a varchar(30), then my next question is: how can I convert a Varchar(30) date that looks like:   2/1/2016 11:54:01 AM -06:00 &n...
2508 Mar 2016 @ 01:30 PSTDatabaseReplyLoading SQL Server TimeStamp Varchar to Teradata Table via TPTI thought one of the so-called beauties of using TPT in place of FASTLOAD was that you didn't have to make all columns to load a varchar only, and had to make sure not to load a NULL, etc... bu...
2408 Mar 2016 @ 08:35 PSTDatabaseTopicLoading SQL Server TimeStamp Varchar to Teradata Table via TPTI have a flat file produced by SQL Sever, and it has a timestamp column as character in format: 2/1/2016 11:54:01 AM -06:00 I have a target temp table to load with: Timestamp(0) In TPT Descriptio...
2316 Feb 2016 @ 06:29 PSTDatabaseReplyDynamically name a file with date in fileanme within BTEQA note to add: I am currently using outside the BTEQ script and using OS shell commands to change the file name to add date, but I'm looking to do it within BTEQ to make it seeming easier. Also...
2215 Feb 2016 @ 11:37 PSTDatabaseTopicDynamically name a file with date in fileanme within BTEQIs there a way to name a file in BTEQ, when creating/writing out the file to a location, and have the current days date as a part of the filename?
2109 Feb 2016 @ 01:03 PSTDatabaseReplyBTEQ Export - Odd File OutputAnd finally, I cat'd as a single varchar all the columns, and gave it a name, and it writes the file without all the extra unwanted spaces. What a chore. After a lot of code and re-code, to arr...
2009 Feb 2016 @ 12:03 PSTDatabaseReplyBTEQ Export - Odd File OutputI've also tried to clear out extra space from the VT with the query used to write to the flat file, with the same double spaced results in the flat file.   SEL   CAST(date_col AS&...
1909 Feb 2016 @ 11:19 PSTDatabaseReplyBTEQ Export - Odd File OutputIve tried quite a nubmer of format variations, including writing to  local drive opposed to a share drive, and even created the query as a volitile table, and casted the columns to eliminate v...
1808 Feb 2016 @ 02:44 PSTDatabaseTopicBTEQ Export - Odd File Output .run FILE c:\some_dir\logon.txt .SET WIDTH 2000 .SET Titledashes OFF .SET Separator '|' .SET RECORDMODE OFF .EXPORT REPORT FILE=\\share_drive\file_name.dat SEL   A.date...
1704 Feb 2016 @ 09:07 PSTDatabaseReplyRDBMS error 3813: The positional assignment list has too many valuesA few more things to add, I added in this to the DEFINE to skip the 1st row header of the flat file: , VARCHAR SkipRowsEveryFile    = 'Y' , Integer SkipRows    &...
1603 Feb 2016 @ 02:52 PSTDatabaseTopicRDBMS error 3813: The positional assignment list has too many valuesHello, I'm building a TPT script to load a flat file to a table. I'm running it from the command line: tbuild -f c:\some_dir\tpt_load.txt My Teradata platform system is: VERSION &nbs...
1528 Jan 2016 @ 08:25 PSTDatabaseReplySubstr - End of Line, Count backwards onText and NumbersMakes sense, it's where to start the count, count the starting position of 0 as 1, out for 5 collects 6 spaces total. Thank you
1428 Jan 2016 @ 07:10 PSTDatabaseReplySubstr - End of Line, Count backwards onText and NumbersThank you Dieter, I was able to make this work. Oddly enough, to properly bring back a backwards count of 6, I had to use 5, 6 would still bring back a count of 7 spaces from the the end sel custn...

Pages