#DateForumTypeThreadPost
7326 May 2016 @ 11:12 PDTConnectivityTopicPerl to TERADATA connection via DBD::Teradata using kerberosHi ,  I need to connect to teradata from perl without using password [ kerberos ] via the module DBD::Teradata . I have acheived it via ODBC but didnt have a clue for  DBD::Teradata ...
7212 Feb 2016 @ 08:30 PSTConnectivityReplyParameters in JDBC Connector for Kereberos Connection Thanks a lot Tom .  The second link says  Verify Login Configuration Information Kerberos requires the following Login Configuration information: com.sun.security.jgss.initiate {...
7112 Feb 2016 @ 09:55 PSTConnectivityTopicParameters in JDBC Connector for Kereberos Connection Hi All ,  Could you please help me with parameters in JDBC connection that helps Kerberos Authentication and settings that need to changed in JDBC drivers ?    
7012 Feb 2016 @ 09:52 PSTTeradata StudioTopicDoes Teradata Studio Express allows Kerberos Authentication / Active Directory Authentication / SSO to Teradata ?Similar to Teradata SQLA , does Teradata Studio Express allows Kerberos Authentication / Active Directory Authentication / SSO to Teradata ?
6916 Jan 2016 @ 11:43 PSTConnectivityTopicsqoop import to teradata via kerberos authenticationHi all , I am able to connect to teradata rdbms via sqoop below query : sqoop import --connect jdbc:teradata://hostname/database=dbname --username xxxxx --password yyyyy --table tbname --split...
6815 Jan 2016 @ 05:48 PSTDatabaseTopicteradata 15 vm wareHi All,  I have installed teradata 15 vmware . How can i connect to Hadoop using Query grid ? also , i am not able to use internet connect  in vm ware . Please let me know if i can downl...
6708 Jan 2016 @ 11:32 PSTDatabaseTopicTTU 15.10 for Linux / Centos6Hi All , Please help me to download Teradata Tools and Utilities 15.10 for Linux / Centos6 . Please give me a link .      
6630 Nov 2014 @ 08:15 PSTDatabaseReplyStored Procedure for storing the DDL of Table in a variableThank you very much dieter . But this will not work for tables with identity column , right ? Please help me in that scenario as well .
6530 Nov 2014 @ 05:30 PSTDatabaseTopicStored Procedure for storing the DDL of Table in a variableHi ,  Please help me to create a SP which should get tablename as INPUT variable and store the DDL of the object and drop the table and recreate the same from the variable . I need to use thi...
6417 Nov 2014 @ 06:27 PSTDatabaseTopicAccess inbetween databasesHi , 1. Please help me with the GRANT statement :- An owner referenced by user does not have SELECT access to 'DATABASE' 2. also , what is the DBC table to verify if the access has been ...
6313 Nov 2014 @ 07:59 PSTDatabaseTopicSQLServer - Teradata Timestamp IssueHi , When i migrate Date/Timestamp/Time Data from SQL Server to Teradata , I can see 6 hours of difference among the dates where teradata date/Timestamp is behind . Please help me on this .  ...
6212 Nov 2014 @ 02:02 PSTDatabaseReplyHow to find FLOAD/MLOAD lock on list of tables Thanks a lot Sandeep . But , I will not have access to sysadmin.fastlog and its not feasible to contact my DBA all the time . PLease suggest me with someother workaround .  
6112 Nov 2014 @ 12:49 PSTDatabaseTopicHow to find FLOAD/MLOAD lock on list of tables Hi All, Is it possible to capture FLOAD lock and MLOAD lock using ERROR HANDLER in Teradata Procedure . If yes , please let me know the steps / sample . If not , please suggest a better way to cap...
6011 Nov 2014 @ 11:42 PSTDatabaseTopicALTER Secondary IndexHi , Please help me with Syntax of all forms of Altering SECONDARY index .   Thanks in Advance!  
5928 Oct 2014 @ 09:45 PDTDatabaseReplyMLOAD error code need to be capturedHi Dieter , But i was unable to capture them . Please find below the code which i have used to capture and help me to accomplish REPLACE PROCEDURE EDW_DB.RELEASE_MLOAD() BEGIN DECLARE DBN...
5828 Oct 2014 @ 02:20 PDTDatabaseTopicMLOAD error code need to be capturedHi , I have a written  a stored procedure to release mload for the tables on which MLOAD is active . I have used DECLARE CONTINUE HANDLER FOR SQLEXCEPTION   INSERT INTO ERRORTABLE ......
5716 Oct 2014 @ 08:54 PDTDatabaseTopicExcel VBA connectivity to Teradata 14Hi , Can someone pls share some code of the excel vba connection to teradata server ?    
5615 Oct 2014 @ 09:09 PDTDatabaseTopicexpected something like a name or a Unicode delimited identifier between an integer and the integer '23'. Hi Team ,   While calling a procedure , i get the below error . Can u pls help me on this . expected something like a name or a Unicode delimited identifier between an integer and the integ...
5513 Oct 2014 @ 09:31 PDTDatabaseTopicMLOAD ErrorHi All , please help me on the below error  . 23:03:23 UTY3403 Only one statement per line is allowed.  Extra characters  were detected beginning in column '30'. &n...
5412 Oct 2014 @ 09:37 PDTDatabaseReplyResponse Row size or Constant Row size overflowHi Glass , I am using Teradata Studio express 15 .   Hi David , If i reduce the data field sizes , it will affect my data present in the field . :( :(  
5312 Oct 2014 @ 07:24 PDTDatabaseTopicResponse Row size or Constant Row size overflowHi All , Please help me on the below mentioned error while just selecting a view   Executed as Single statement. Failed [9804 : HY000] Response Row size or Constant Row size overflow. Ela...
5207 Oct 2014 @ 07:32 PDTDatabaseTopicError Handling in Stored ProcedureHi , After this DECLARE EXIT HANDLER FOR SQLEXCEPTION , i need to update a table and insert a value into another table . How can i accomplish this ? Pls help .
5102 Oct 2014 @ 08:09 PDTDatabaseTopicAborting a Stored ProcedureHi , A stored procedure was running for a long time . I was unable to abort the stored procedure . So i logged off the session . Will that stored procedure be stopped now ? Thanks !!!!  
5002 Oct 2014 @ 08:07 PDTDatabaseTopicDroping a Global Temporary TableHi , while dropping a global temporay table , i face the below error . Executed as Single statement.  Failed [5337 : HY000] Drop Table is not allowed due to materialized temporary tables. ...
4930 Sep 2014 @ 10:49 PDTDatabaseReplyHow to find base tables/views for views Nope :( please help me !!!  

Pages