#DateForumTypeThreadPost
1317 Sep 2014 @ 09:33 PDTDatabaseReplyerror handler for CAST FAILED BAD CHARACTER IN FORMAT OF DATAAnd i forgot to mention that i cannot use UDF's.
1217 Sep 2014 @ 09:27 PDTDatabaseReplyend of month datesthanks for your replies. It worked with a little tweaks according to my requirement.
1117 Sep 2014 @ 08:51 PDTDatabaseTopicerror handler for CAST FAILED BAD CHARACTER IN FORMAT OF DATAHi all, I have a scenario where i have to CAST most of the columns and create and create a view. Now the issue i am having is some CASTS fail because of bad format in data. In this case i have to...
1015 Sep 2014 @ 12:21 PDTDatabaseReplyError LogsYou might be working on a client server. May be the admin can grant you the rights(not possible in many cases).
915 Sep 2014 @ 12:16 PDTDatabaseReplyValidate integers that can be converted into dateHi Glass, The above solution may not be possible in my case because the values of intgers that can be converted are not of this century. And the Sys_calendar has dates only of this century. Cheer...
815 Sep 2014 @ 12:13 PDTDatabaseReplyExpire PasswordHi, UPDATE DBC.SysSecDefaults SET ExpirePassword=10; you can put any no of days provided you have admin access.   Cheers, Subbu
715 Sep 2014 @ 12:03 PDTDatabaseReplyError LogsFor Linux   /var/log/boot.msg This log contains messages produced during the current system boot. You can also display the informat...
615 Sep 2014 @ 11:55 PDTDatabaseReplyError LogsIf you are running into problems getting Teradata started, the first place to check for clues is in the log file: 1 ...
515 Sep 2014 @ 11:43 PDTDatabaseReplyCrash Dump Errors in Teradatahttp://www.info.teradata.com/HTMLPubs/DB_TTU_14_00/Database_Management/B035_1093_111A/ch16.035.02.html
415 Sep 2014 @ 11:36 PDTDatabaseReplyError LogsHi, This may help. While using a utility(say Fast load), in the script itself u can mention the error logs. ex : Drop table emp_er1; Drop table emp_er2; Drop table emp;   ...
315 Sep 2014 @ 10:35 PDTDatabaseReplyValidate integers that can be converted into dateHi Glass, thanks for you reply and i have tried this post by Dnoeth and it works in my case   CASE   WHEN   (d / 10000 BETWEEN 1900 AND 9999)  -- correct ye...
215 Sep 2014 @ 10:28 PDTDatabaseTopicend of month datesHi all, I have a column(EFFECTIVE_START_DATE) which has to be transformed to INFOMATION_DATE as the last date of the month. ex : if my source dates are 26th jan 2014, 26th feb 2014 and 26 march 2...
115 Sep 2014 @ 09:21 PDTDatabaseTopicValidate integers that can be converted into dateHi all, I have a column(say date_col) which is integers and contains values which can or cannot be converted into date type. now i have to select the NOT-CONVERTABLE values as "NULL" and...