| 73 | 26 May 2016 @ 11:12 PDT | Connectivity | Topic | Perl to TERADATA connection via DBD::Teradata using kerberos | Hi ,
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 ... |
| 72 | 12 Feb 2016 @ 08:30 PST | Connectivity | Reply | Parameters 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
{... |
| 71 | 12 Feb 2016 @ 09:55 PST | Connectivity | Topic | Parameters 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 ?
|
| 70 | 12 Feb 2016 @ 09:52 PST | Teradata Studio | Topic | Does 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 ?
|
| 69 | 16 Jan 2016 @ 11:43 PST | Connectivity | Topic | sqoop import to teradata via kerberos authentication | Hi 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... |
| 68 | 15 Jan 2016 @ 05:48 PST | Database | Topic | teradata 15 vm ware | Hi 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... |
| 67 | 08 Jan 2016 @ 11:32 PST | Database | Topic | TTU 15.10 for Linux / Centos6 | Hi All ,
Please help me to download Teradata Tools and Utilities 15.10 for Linux / Centos6 . Please give me a link .
|
| 66 | 30 Nov 2014 @ 08:15 PST | Database | Reply | Stored Procedure for storing the DDL of Table in a variable | Thank you very much dieter . But this will not work for tables with identity column , right ? Please help me in that scenario as well .
|
| 65 | 30 Nov 2014 @ 05:30 PST | Database | Topic | Stored Procedure for storing the DDL of Table in a variable | Hi ,
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... |
| 64 | 17 Nov 2014 @ 06:27 PST | Database | Topic | Access inbetween databases | Hi ,
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 ... |
| 63 | 13 Nov 2014 @ 07:59 PST | Database | Topic | SQLServer - Teradata Timestamp Issue | Hi ,
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 .
... |
| 62 | 12 Nov 2014 @ 02:02 PST | Database | Reply | How 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 .
|
| 61 | 12 Nov 2014 @ 12:49 PST | Database | Topic | How 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... |
| 60 | 11 Nov 2014 @ 11:42 PST | Database | Topic | ALTER Secondary Index | Hi ,
Please help me with Syntax of all forms of Altering SECONDARY index .
Thanks in Advance!
|
| 59 | 28 Oct 2014 @ 09:45 PDT | Database | Reply | MLOAD error code need to be captured | Hi 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... |
| 58 | 28 Oct 2014 @ 02:20 PDT | Database | Topic | MLOAD error code need to be captured | Hi ,
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 ...... |
| 57 | 16 Oct 2014 @ 08:54 PDT | Database | Topic | Excel VBA connectivity to Teradata 14 | Hi ,
Can someone pls share some code of the excel vba connection to teradata server ?
|
| 56 | 15 Oct 2014 @ 09:09 PDT | Database | Topic | expected 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... |
| 55 | 13 Oct 2014 @ 09:31 PDT | Database | Topic | MLOAD Error | Hi 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... |
| 54 | 12 Oct 2014 @ 09:37 PDT | Database | Reply | Response Row size or Constant Row size overflow | Hi 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 . :( :(
|
| 53 | 12 Oct 2014 @ 07:24 PDT | Database | Topic | Response Row size or Constant Row size overflow | Hi 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... |
| 52 | 07 Oct 2014 @ 07:32 PDT | Database | Topic | Error Handling in Stored Procedure | Hi ,
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 .
|
| 51 | 02 Oct 2014 @ 08:09 PDT | Database | Topic | Aborting a Stored Procedure | Hi ,
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 !!!!
|
| 50 | 02 Oct 2014 @ 08:07 PDT | Database | Topic | Droping a Global Temporary Table | Hi ,
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.
... |
| 49 | 30 Sep 2014 @ 10:49 PDT | Database | Reply | How to find base tables/views for views | Nope :( please help me !!!
|