13 | 17 Sep 2014 @ 09:33 PDT | Database | Reply | error handler for CAST FAILED BAD CHARACTER IN FORMAT OF DATA | And i forgot to mention that i cannot use UDF's.
|
12 | 17 Sep 2014 @ 09:27 PDT | Database | Reply | end of month dates | thanks for your replies. It worked with a little tweaks according to my requirement.
|
11 | 17 Sep 2014 @ 08:51 PDT | Database | Topic | error handler for CAST FAILED BAD CHARACTER IN FORMAT OF DATA | Hi 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... |
10 | 15 Sep 2014 @ 12:21 PDT | Database | Reply | Error Logs | You might be working on a client server. May be the admin can grant you the rights(not possible in many cases).
|
9 | 15 Sep 2014 @ 12:16 PDT | Database | Reply | Validate integers that can be converted into date | Hi 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... |
8 | 15 Sep 2014 @ 12:13 PDT | Database | Reply | Expire Password | Hi,
UPDATE DBC.SysSecDefaults SET ExpirePassword=10;
you can put any no of days provided you have admin access.
Cheers,
Subbu
|
7 | 15 Sep 2014 @ 12:03 PDT | Database | Reply | Error Logs | For Linux
/var/log/boot.msg
This log contains messages produced during the current system boot.
You can also display the informat... |
6 | 15 Sep 2014 @ 11:55 PDT | Database | Reply | Error Logs | If you are running into problems getting Teradata started, the first place to check for clues is in the log file:
1
... |
5 | 15 Sep 2014 @ 11:43 PDT | Database | Reply | Crash Dump Errors in Teradata | http://www.info.teradata.com/HTMLPubs/DB_TTU_14_00/Database_Management/B035_1093_111A/ch16.035.02.html
|
4 | 15 Sep 2014 @ 11:36 PDT | Database | Reply | Error Logs | Hi,
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;
... |
3 | 15 Sep 2014 @ 10:35 PDT | Database | Reply | Validate integers that can be converted into date | Hi 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... |
2 | 15 Sep 2014 @ 10:28 PDT | Database | Topic | end of month dates | Hi 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... |
1 | 15 Sep 2014 @ 09:21 PDT | Database | Topic | Validate integers that can be converted into date | Hi 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... |