#DateForumTypeThreadPost
11610 Feb 2012 @ 12:07 PSTDatabaseReplyit seems teradata doesn't support != as not equal, right? from the documentation   <> ^= NE NOT=   Tests for inequality.
11509 Feb 2012 @ 11:58 PSTPrivate Forum
11409 Feb 2012 @ 11:53 PSTDatabaseReplyUnexpected syntax error 3706 when using CASE IN with timestamp values It would be nice if you would share the message text as well - at least I don't know all the error codes out of my mind and it takes time to check the manuals ;-)... are timestamp1,....,...
11309 Feb 2012 @ 11:47 PSTDatabaseReplyShortcut in Group by clause... I am not aware of this kind of short cut - and would event not advise to use it in production code if it would exists ;-)
11209 Feb 2012 @ 11:42 PSTDatabaseReplyit seems teradata doesn't support != as not equal, right? try <> instead of !=  
11109 Feb 2012 @ 06:27 PSTConnectivityReplyExcel Connector for Teradata I never did this this way. I know it is possible to modify the ODBC SQL and do joins there.  I would expect that there exists ways to do it like you want but can't help you there.
11008 Feb 2012 @ 11:32 PSTDatabaseReplyTranspose Rows to Column I think this will work... select s.c1, s.c2, s.c3, case when c.id = 1 then c5 when c.id = 2 then c9 ...
10908 Feb 2012 @ 08:15 PSTConnectivityReplyExcel Connector for Teradata the normal ODBC connect from Excel to TD is not suffient for you?
10808 Feb 2012 @ 08:11 PSTDatabaseReplyEnd of line in a string you would end up in someting like   substring(x, position('yourstring' in x) + characters('yourstring'), case when position('nextstring' in x) > 0 then po...
10708 Feb 2012 @ 08:06 PSTDatabaseReplyEnd of line in a string so you mean that sometimes 'nextstring' does not exists? And you want to select the rest of the string in this case?
10608 Feb 2012 @ 08:04 PSTDatabaseReplyError 3706 while creating TRANSACTIONTIME Temporal Table And this is from 13.1 release summary document:   You may not use the Temporal Table Support capability without a separate license. The license is included in the Teradata E...
10508 Feb 2012 @ 08:02 PSTDatabaseReplyError 3706 while creating TRANSACTIONTIME Temporal Table no it will only work from 13.1 onwards but need activated there as well
10408 Feb 2012 @ 07:05 PSTDatabaseReplyEnd of line in a string Hi   position gives you the position when the string starts. so you need something like substring(x, position('yourstring' in x) + characters('yourstring'), ...
10308 Feb 2012 @ 06:10 PSTDatabaseReplyError 3706 while creating TRANSACTIONTIME Temporal Table I guess you run 13.1 - otherwise it will not supported from the release. On 13.1 it need to be activated and maybe charged and it is not a standard DBS controll field where you can switch it...
10208 Feb 2012 @ 06:06 PSTDatabaseReplyImport Problem - Date field Which tool do you use?
10108 Feb 2012 @ 02:05 PSTDatabaseReplyWhat is mean by DBS Control Record field?? DBS controll controlls different database settings and changes should only be done if you know what you are doing. Can only be done from admins. Read the manuals (utilitys Volume 1 A-K, ...
10006 Feb 2012 @ 01:19 PSTToolsReplyTBUILD log file hm, you need to know the job id of the run. You can use the $JOBID parameter (see http://developer.teradata.com/tools/articles/access-to-the-job-identifier-in-teradata-pt-job-scripts) ...
9906 Feb 2012 @ 01:10 PSTDatabaseReplyGenerate Character Sequences I think a UDF which converts integer to this kind of char will do best. But I think you would need to code this on your own or pay somebody to do so.  
9806 Feb 2012 @ 01:07 PSTDatabaseReplyError Running Merge Statement Hi, yes, this was what I meant. I think you need also remove the coalesce(a.gu_id,'x')=coalesce(t.gu_id,'x') and use a.gu_id = t.gu_id as the coalesce might cause a pro...
9706 Feb 2012 @ 12:46 PSTDatabaseReplyGenerate Character Sequences do you mean something like select 'ADG' !! trim(calendar_date - current_date) from sys_calendar.calendar where calendar_date - current_date between 1 and 9 ; ?
9606 Feb 2012 @ 10:46 PSTDatabaseReplyError Running Merge Statement I am not 100 sure as I can't check it right know but I guess the problem is that you want to change the value of one field in the PK. You set  STAT_IN = 'A' in the Inser...
9506 Feb 2012 @ 07:43 PSTDatabaseReplyError Running Merge Statement it is much easier to comment on these questions of you share the code and ddls - change names if you need. Otherwise it is just a lot of guessing...
9405 Feb 2012 @ 11:32 PSTDatabaseReplyDBC tables/views to extract Table, View and Macro, etc definitions you can run  select 'show ' !! case when tablekind = 'm' then 'macro' when tablekind = 't' then 'table' when tablekind = 'v' then 'vi...
9303 Feb 2012 @ 10:16 PSTToolsReplyCan ANSI transaction mode be set in TPT script? dbs controll field “DefaultCaseSpec” Determines whether character string comparisons consider character case and whether character columns are considered case specific by default...
9203 Feb 2012 @ 08:33 PSTToolsReplySpeed up imports in BTEQ or SQL Assistant There are different things to notice. 1. When I run your code I get much higher load rates.    *** Starting Row 0 at Fri Feb  3 17:10:39 2012  .....

Pages