#DateForumTypeThreadPost
3123 Sep 2015 @ 03:21 PDTDatabaseReplyIssue while converting float to time and inserting to tableHi,   One more dumb question , again I am getting the below issue wrt to type mismatch when I am trying to concatenater a string with time.   As per my understanding , I thought it wo...
3023 Sep 2015 @ 02:53 PDTDatabaseReplyIssue while converting float to time and inserting to tableHi Dieter,   Thanks a lot for your timely help. Yes you are right i had compared TIME with FLOAT . Its working fine now after changing the above code.   Nice day ahead   &nbs...
2923 Sep 2015 @ 01:46 PDTDatabaseReplyIssue while converting float to time and inserting to tableHi Diter and Carlosal,   Thanks for your response and in advance for your help. I have made thechanges and tried  but in where clause there i some typecasting problem and it shows the...
2822 Sep 2015 @ 10:19 PDTDatabaseReplyIssue while converting float to time and inserting to tableHi All,   Would anyone would eb able to help me on the above query. Thanks in advance
2722 Sep 2015 @ 08:41 PDTDatabaseReplyIssue while converting float to time and inserting to tableHi Carlosal,   Thanks for your reply, but I think there is some issue with the site , I am not able to see your reply. Kindly do help in replying back again.
2622 Sep 2015 @ 07:33 PDTDatabaseTopicIssue while converting float to time and inserting to tableHi   I ran on an issue where I am trying to insert the values from DBC.RESUSAGESPMA to a volatile table, but when doing it I am getting an  Error - 5407:  Invalid operation f...
2524 Jul 2015 @ 09:39 PDTDatabaseTopicViewpoint background information through SQLHi Everyone,   Is it possible to understand from which views viewpoint retrieves the data from the background ? I am using Teradata 13.10.   Thanks in advance for your help
2424 Jul 2015 @ 08:01 PDTDatabaseReplyNeed this tricky logic .. Urgent helpHi ,   We can use UNION ALL , as below   select id, name, fav_color, date From Table_A1 union all select id, updated_column, old_value, ...
2324 Jul 2015 @ 07:54 PDTDatabaseReplyFind the list of active running queries through SQLHi Dieter,   Thanks for your response, But I am not able to find the query ID while querying the same. The below columns are only returned. Is it possible to also get the queryid , So it w...
2224 Jul 2015 @ 06:34 PDTDatabaseReplyFind the list of active running queries through SQLHi Vhota,   Thanks for your response.   Just to rephrase my query, I assume that we can get the list of active sessions using MONITOR SESSION function, but I want to get the exact col...
2124 Jul 2015 @ 02:39 PDTDatabaseTopicFind the list of active running queries through SQLHi,   I am using Teradata 13.10, I want to know the list of queries which is executing in Teradata using sql. Thanks for your help
2010 Jul 2015 @ 02:14 PDTDatabaseReplyhow to identify "down" tables in all Teradata systemHi Jiri,   Kindly do clarify what is a down table, so we would be able to help you out
1910 Jul 2015 @ 01:59 PDTDatabaseReplyInstall Teradata on Laptop / VMHi Arpit ,   For personnel educational purpose.   You can get the same within the downloads section http://downloads.teradata.com/    
1810 Jul 2015 @ 01:52 PDTDatabaseReplyTeradata Trainer Hi,   For educational purpose i.e for personnel use Please download the Teradata express for VMWARE and you would be having a full fleged teradata system with viewpoint installed, with whic...
1710 Jul 2015 @ 01:35 PDTDatabaseTopicBest way to add a partition to an existing tableHi,   Kindly do suggest me the best way to add a partition to an existing table   1 way :- 1. rename the existing table 2. create a new table with similiar structure 3. Insert data...
1621 Jun 2015 @ 04:02 PDTDatabaseReplyTperf calculation for my systemHi Dinesh,   Thanks for your response, but it does not answer my question as I want to know how TPERF is being calculated and want ton understand if it matches the value of my system.  
1514 Jun 2015 @ 08:14 PDTDatabaseReplyJoin IndexHi padthai_noodles,   A JI table is hash-distributed, with possibly a different distribution of rows to the AMPs and row ordering on the AMPs from the base table rows    
1413 Jun 2015 @ 04:46 PDTDatabaseReplyTperf calculation for my systemHi Anyone Would be able to help me out here . Thanks in advance for your help. regards, Subramanian kaushik Gurumoorthy
1312 Jun 2015 @ 11:26 PDTDatabaseReplyDynamic calling of stored procedure.I think it can be done but not through sql   Step 1 We can get the stored procedure to be executed at run time in a file and do create a bteq file with call statement as below .LOGON loca...
1212 Jun 2015 @ 11:08 PDTGeneralReplyGood Book/Site for SQL codingTry this blog where you would get some information and examples from the author.   http://sqlfool.com/mssql-dba-guide-to-teradata/   regards Subramanian kaushik Gurumoorthy  
1112 Jun 2015 @ 11:03 PDTToolsTopicis Support utilities with Teradata express or were to download itHi I have downloaded and installed a windows version of Teradata database version 13.10, but found that support utilities are not included within the installtion/   Kindly do inform whethe...
1011 Jun 2015 @ 11:52 PDTDatabaseTopicTperf calculation for my systemHi,   Good morning. We have a 5650H system for which I want tyo understanf onm how to calculate the TPERF value. Browsing over all the posts, I came to know that we can calculate the TPERF...
931 May 2015 @ 11:27 PDTDatabaseReplyDynamic DCL statement executionHi Velunatrajan Thanks a lot. That worked, after I tried creating the procedure within the user to whom access has been provided.   regards, Subramanian kaushik Gurumoorthy
818 May 2015 @ 06:13 PDTDatabaseReplyDynamic DCL statement executionHi Glass,   Thanks a lot for your reply. I tried Implementing the same. But getting the errror. CALL Failed. 5616: RLBASIC :The user is not authorized to grant or revoke role. regards...
712 May 2015 @ 05:24 PDTDatabaseTopicDynamic DCL statement executionHi ,   I am trying to create a procedure to grant role to the users based on the user id inputted. but it is not working .   Kindly do help me in debugging the same Teradata Version...

Pages