#DateForumTypeThreadPost
8325 Sep 2012 @ 04:45 PDTDatabaseReplyCode ConversionIn Teradata TRIM LEADING '1' will also replace leading 1 from your string and rest of the string will remain same.
8225 Sep 2012 @ 04:37 PDTGeneralReplyForum email notifications temporarily disabledForgot to mention, I am using firefox.
8125 Sep 2012 @ 03:20 PDTGeneralReplyForum email notifications temporarily disabledI can't see email notifications either. All I see is the RSS feed icon. As far as the profile setting is concerned, I opted for email notifications, but I am not getting any email what so ever...
8019 Sep 2012 @ 06:19 PDTGeneralReplyTeradata V14 CertificationAnd what about TD-13? There should be TD-13 before going to TD-14. And secondly right now TD-12 certification is available, so I don't think that one can do TD-14. Was that email came from Te...
7919 Sep 2012 @ 03:51 PDTGeneralReplyForum email notifications temporarily disabledOk thanks, yes I'll report the issue.
7814 Sep 2012 @ 06:19 PDTGeneralReplyForum email notifications temporarily disabledYeah I changed the settings in my profile and enabled it to recieve the emails but still I don't recieve any email. So for example, will I get an email, if someone reply on this particular post...
7714 Sep 2012 @ 03:19 PDTGeneralReplyForum email notifications temporarily disabledDoes this email notification allow me to recieve email, whenever someone respond to my forum post? Does it also work if someone respond to the forum post which is not posted by me, but I participa...
7614 Sep 2012 @ 02:42 PDTGeneralReplyTeradata Procedure DoubtOr use the following query to convert your input parameters to year and month select extract(year from cast('Jan2012' as date format 'mmmyyyy')) as ur_year ,extract(month from c...
7513 Sep 2012 @ 05:54 PDTGeneralReplyTeradata Procedure Doubt You need to convert your input parameters in DATE format in your procedure and then probably you can use EXTRACT function to get the month and year out of it and compare if with your table.
7404 Sep 2012 @ 07:32 PDTDatabaseReplyproduction data It varies from project to project. Most of the customers do not share the data due to security reasons (as in your case). Some of them provide encrypted data. So in many cases, development a...
7304 Sep 2012 @ 03:43 PDTGeneralReplyWish list for forum development Agree. In addition to this, there should be an option to enable email alerts on the responses/replies on forum posts.
7230 Aug 2012 @ 06:55 PDTDatabaseReplyBetween Times not working As mentioned by Ulrich you need to cast the time to make it time (type) before comparing it. Similarly, you also need to do the same with your dates in WHERE clause (assuming ASKME_CREAT_DT ...
7129 Aug 2012 @ 01:57 PDTDatabaseReplyBetween Times not working The CASE syntax in your given query is not correct. It should be like this: Case When ASKME_CREAT_DT Between ('2012/08/29') and ('2012/08/30') Then 'AM'   ...
7028 Aug 2012 @ 02:19 PDTDatabaseReplyWould the results differ if the last condition was: WHERE employee.last_name = 'Brown' ? What do you mean by "last condition was"? If you asking that the condition will change your result set, then yes.
6924 Aug 2012 @ 03:00 PDTDatabaseReplyBasic Teradata Command and Connectivity Hi, 1. For connection, it uses ODBC connection to connect to the database. You need to have client software installed on the machine (in case of network attached client). 2. You can use ...
6822 Aug 2012 @ 01:55 PDTToolsReplyAlter table to add column after specific column Hi Prabhakar, Just curious to know that why you are interested in the poistion of the new column? The position of the column in the table is irrelevant because you can always access them in ...
6722 Aug 2012 @ 01:38 PDTDatabaseReplyODI and Teradata Repositories Hi, I found one source for setting up the topology while googling. Though its using oracle but I hope that this would give you what you were looking for. http://www.oracle.com/webfolder/...
6617 Aug 2012 @ 03:17 PDTDatabaseReplyODI and Teradata Repositories Hi, You need to define the data server and physical schema in physical architecture tab of the topology. And then define logical schema and context to use that. You can search for the st...
6513 Jul 2012 @ 07:11 PDTDatabaseReplyInsert statement in stored procedure I cannot check this either but I think that's possible. Otherwise you can check DBC.SYSEXECSQL
6413 Jul 2012 @ 07:07 PDTDatabaseReplyFastLoad Error when trying to import... Its always good to post the solution, so that it can be helpful for others as well.
6313 Jul 2012 @ 03:38 PDTDatabaseReplyFastLoad Error when trying to import... Can you post the logs please?
6213 Jul 2012 @ 03:18 PDTGeneralReplyDeclaring Variable in Teradata Stored procedure DECLARE variable_name VARCHAR(20); SELECT col_name INTO variable_name...
6113 Jul 2012 @ 03:15 PDTGeneralReplyDeclaring Variable in Teradata Stored procedure What about SELECT col_name INTO variable_name
6006 Jul 2012 @ 02:33 PDTDatabaseReplyHow to run queries dynamically in the procedure wchic are stored in table. Try DBC.SYSEXECSQL. I think this will solve your problem.
5905 Jul 2012 @ 10:39 PDTGeneralReplyHow to find the parent and child relationship between tables in Terdata by using Dictonary tables? From parent persective: select * from DBC.All_RI_Children where ParentTable = '<ur_parent_table>' select * from DBC.All_RI_Parents where ParentTable = '<ur_paren...

Pages