59542 | 31 Aug 2016 @ 06:14 PDT | SGIT | Database | Reply | Set multiple variable in one case statement | Could you elaborate on how a SP could do the above?
|
59541 | 31 Aug 2016 @ 04:53 PDT | romanoww | Teradata Studio | Topic | Need to reinstall Studio Express 15.10.1 (last working version): where to find it? | I've read about the Teradata Patch Server but have no idea how to reach it.
Could anyone tell me where to find a version of Studio Express 15.10.1?
Steven
|
59540 | 31 Aug 2016 @ 03:34 PDT | Akshay.Shaha | Database | Reply | Updating second row value to new column first row | Hi,
Is RN column part of your table? If yes, then below query should do :
MERGE INTO tab A USING
(
SELECT id , col2 FROM tab WHERE rn = 2
) B (id,col2)
ON (A.id ... |
59539 | 31 Aug 2016 @ 03:13 PDT | dnoeth | Database | Reply | equivalent function for Month(); DateAdd() | Hi Patrick,
the Standard SQL way would be EXTRACT(MONTH FROM col), but you better avoid functions on both sides of a comparison:
Where Date_attribut between TRUNC(CURRENT_DATE, 'mon... |
59538 | 31 Aug 2016 @ 02:36 PDT | dnoeth | Database | Reply | Why does Teradata Express come only as a VM component? Why not as a standalone software to be installed on physical desktop? | Hi Subhayu,
you simply install the Teradata Client for Windows: TTU - Windows Install
|
59537 | 31 Aug 2016 @ 02:03 PDT | jabbarahmed | General | Topic | Converting varchar into timestamp | Can someone please give me the exact code to convert the following varchar data into a teradata recognised timestamp format. I have searched through existing topics but have not found an ... |
59536 | 31 Aug 2016 @ 12:47 PDT | plechat | Database | Topic | equivalent function for Month(); DateAdd() | Hello,
i want my sql script to automatically query the last month (first to last day) in the database.
Like if i am in august 2016 (the day doesn't matter), the query will pick all datas... |
59535 | 31 Aug 2016 @ 12:02 PDT | vinolin | Connectivity | Reply | how to install teradata express edition on windows 7 | Can anyone clearly say the prerequisites software for installing teradata database in windows 7, 32 -bit and i used use that DB to store xml files inside the DB using java via netbeans is that poss... |
59534 | 30 Aug 2016 @ 11:58 PDT | CarlosAL | Database | Reply | Set multiple variable in one case statement | Hi.
What does it mean "Teradata code"? bteq script? Stored Procedure? Other?
CASE (SQL) won't work this way, maybe a SP will.
Cheers.
Carlos.
|
59533 | 30 Aug 2016 @ 10:36 PDT | Johannes Vink | Tools | Reply | Can TTU 14.10 on Linux connect on a15.10 RDBMS | Informatica 9.6.1 probably? Some story here. TTU 14.10 is 2 versions upward compatible (excluding new features in newer versions ofcourse). So 15.00 and 15.10 are supported, but 16.00 (not out yet)... |
59532 | 30 Aug 2016 @ 09:51 PDT | subhayu | Database | Reply | Why does Teradata Express come only as a VM component? Why not as a standalone software to be installed on physical desktop? | Hi Dieter,
That answers. Thanks! I was not aware that Teradata is not available for Windows.
So what if we have a requirement for handshaking between a MSBI stack and Teradata? Say, TD needs to r... |
59531 | 30 Aug 2016 @ 07:07 PDT | jingguo | Tools | Reply | fastload cannot start with error "The request exceeds the length limit, The maximum length is 1048500." | Hi SteveF,
Thanks for your reply. It works.
Another questions: if I have the delimiter as "DEL" or ^P or 0x10, how do I write "SET RECORD VARTEXT"?
Is there a mapping somewhe... |
59530 | 30 Aug 2016 @ 06:10 PDT | jasonmoore2k | Connectivity | Reply | Teradata JDBC Driver returns the wrong schema / column nullability | Tom, what would be the next steps for this? Is there another system I should be putting this request into? How would I track when it is likely to be resolved and a patch provided?  ... |
59529 | 30 Aug 2016 @ 05:23 PDT | gs | Teradata Studio | Reply | Views the rows being transferred over | Francine,
Looks like you responded to my post but since I am new to the site, I don't see my post.
That is not the case, the file is deleted even when the load fails midway throug... |
59528 | 30 Aug 2016 @ 04:17 PDT | fgrimmer | Teradata Studio | Reply | Views the rows being transferred over | Ravindra, The file is created before loading and if Studio finds no errors then the empty error file is deleted.
|
59527 | 30 Aug 2016 @ 03:55 PDT | gs | Teradata Studio | Reply | Views the rows being transferred over | Francine,
I have similar issue while loading smaller files - I am unable to see the error file in the same directory. As I alluded in my earlier post, it gets created beginning of load and d... |
59526 | 30 Aug 2016 @ 03:35 PDT | gs | Teradata Studio | Reply | Configurer Data Transfer Error Files | Dear All,
Pardon any errors of omission or commission from my first post to a forum. Any help greatly appreciated.
Followed Francine's advice with Teradata Studio version 15.10 - I specified ... |
59525 | 30 Aug 2016 @ 02:41 PDT | Glass | Database | Reply | Replacing table | If emp exists your query will fail.
To replace , drop old first.
Rlgass
|
59524 | 30 Aug 2016 @ 01:51 PDT | Cvinodh | Tools | Topic | TDCH Export from HDFS timestamp issue. | I am loading a file from HDFS into Teradata using Teradata Hadoop connector. All my records are getting rejected due to error code 6760 (invalid timestamp). All the timestamp fields are of format y... |
59523 | 30 Aug 2016 @ 11:40 PDT | SGIT | Database | Topic | Set multiple variable in one case statement | Hello,
I am converting some SAS code to TD : In SAS you can set multiple variables within a single case statement. Can we do the same in TD? Thanks in advance
if RFRL_SRC_CD = ... |
59522 | 30 Aug 2016 @ 11:30 PDT | GNS | Tools | Topic | Can TTU 14.10 on Linux connect on a15.10 RDBMS | Hello,
I am working with an Informatica application where the most recent TTU supported is 14.10.
The Teradata RDBMS will be upgraded to 15.10. Could you let me know if the TTU and ... |
59521 | 30 Aug 2016 @ 11:04 PDT | Ivyuan | Tools | Reply | FastExport Remove Binary/Indicator Values in Outmod | Hi,
There are some sample OUTMOD routines in Teradata FastExport manual(B035-2410) Appendix C.
Thanks!
|
59520 | 30 Aug 2016 @ 10:47 PDT | Ivyuan | Tools | Reply | Error Table Mload | Hi,
Here is related information on 2665:
2665 Invalid date.
Explanation: This error occurs when date arithmetic is attempted on an invalid date.
Generated By: AMP Steps.
For Whom: End User.... |
59519 | 30 Aug 2016 @ 10:33 PDT | SGIT | Database | Topic | Replacing table | Hello,
In SAS if a new table A is created using the table A itself, the new table will overwrite the old. Can you pl let me know if same is the case in TD. -
create volatile ... |
59518 | 30 Aug 2016 @ 10:13 PDT | missgate | Analytics | Reply | IS-NUMERIC functions |
I know is to late.
Regex could be a good option.
Consider the value is not a number then a default value can set and the "SQLSTATE 22023 Invalid character x in number str... |