All forum activity

#DateUserForumTypeThreadPost
5799223 Jun 2016 @ 11:32 PDT31_resuDatabaseReplyError 7547 on UpdateThey both work, I see what you're saying about using defined alias and not original table name, I like the EXISTS as it's cleaner. Thank you very much Dieter
5799123 Jun 2016 @ 11:22 PDTajithpillaiTeradata StudioReplyTeradata studio installation is failing...i have installed teradata studio in my pc..does the teradata studio come with default data tables? if yes, how do we connect..what is the connection parameters/?
5799023 Jun 2016 @ 11:17 PDTfeinholzToolsReplyNeed help with Conflicting Column Count in TPTWhat exact version of TPT are you running? I might need you to enable the operator trace for the Export operator and send me the binary log from the job (to me email). In the meantime, I am inves...
5798923 Jun 2016 @ 11:10 PDTrnadjafiDatabaseReplyISOLATING A BLOCK OF TEXT FROM A LARGER BLOCK OF TEXT WITHIN 1 COLUMNThank you so much!  It works if there is only one word without spaces.   1) If "WORD4" was instead "WORD 4" how would I deal with the space?  Even for "Sign...
5798823 Jun 2016 @ 11:03 PDTboagus1DatabaseReplyIdentifying which column is throwing error on INSERTThanks AtardecerR0j0. This helps !!
5798723 Jun 2016 @ 10:53 PDTdnoethDatabaseReplyError 7547 on UpdateYou must use a defined alias instead of the original table name: UPDATE DA FROM DATABASENAME.DIG_ADOPT AS DA , (SELECT DISTINCT(CG.ACCT_NBR) FROM DATABASENAME.SRT_CG AS CG ...
5798623 Jun 2016 @ 10:35 PDTfeinholzToolsReplyNeed Help regarding TPT ODBC OperatorThe ODBC license files for the bundled DataDirect drivers are provided at no charge, but they must be obtained from our Product Management group, as they track to which customers they supply the li...
5798523 Jun 2016 @ 10:12 PDTSNguyenWFTeradata StudioReplyStudio Express severe keyboard lagHmm, I don't think I have a problem there.  I have the latest version of the driver for my integrated Intel graphics.
5798423 Jun 2016 @ 09:34 PDTphilxbatesToolsTopicNeed help with Conflicting Column Count in TPTI have a TPT job that is getting the following errors: TPT_INFRA: TPT02640: Error: Conflicting column count. Source column count (12) Target column count (27). $EXPORT: TPT12108: Output Schema do...
5798323 Jun 2016 @ 09:34 PDTphilxbatesToolsTopicNeed help with Conflicting Column Count in TPTI have a TPT job that is getting the following errors: TPT_INFRA: TPT02640: Error: Conflicting column count. Source column count (12) Target column count (27). $EXPORT: TPT12108: Output Schema do...
5798223 Jun 2016 @ 09:22 PDT31_resuDatabaseReplyError 7547 on UpdateI see that product join,and I have made many joins after the set statement and still cant get past the spool
5798123 Jun 2016 @ 09:10 PDT31_resuDatabaseReplyError 7547 on UpdateHere it is with datbase/table names changes to be like the example   UPDATE DA FROM DATABASENAME.DIG_ADOPT AS DA ,     (SELECT     DISTINCT(CG.ACCT_NBR) &nb...
5798023 Jun 2016 @ 09:04 PDTfgrimmerTeradata StudioReplyHow Do You Create A Teradata Database?Aniket, You will need to first login as an administrator and create a new user in Teradata. Please refer to the Teradata documentation for the CREATE USER statement syntax.
5797923 Jun 2016 @ 09:01 PDTdnoethDatabaseReplyError 7547 on UpdateCan you show Explain? Double check your table aliases, seems like you get a product-join.
5797823 Jun 2016 @ 08:33 PDTdnoethDatabaseReplyQuery optimization issueApparently the join-conditions on ORG_ENTITY_ID are missing and you get CROSS-joins.  
5797723 Jun 2016 @ 08:17 PDTajithpillaiTeradata StudioTopicTeradata studio installation is failing...when i try to run the teradata studio, the system is prompting me for JRE. I downloaded JRE from Java website. but it is still failing..what could be the reason?
5797623 Jun 2016 @ 08:04 PDT31_resuDatabaseTopicError 7547 on UpdateHello, I'm running an update, and as I develop it, from updating everything incorrectly, to error 7547's, to spool space, and collecting stats on tables invloved, distinct, with and withou...
5797523 Jun 2016 @ 06:35 PDTrharitha7Teradata Database on VMWareTopichow to execute bteq on vmaware with linux oshi i've installed teradata on vmware on linux os? can someone help me to how to execute bteq scripts?   thanks.
5797423 Jun 2016 @ 06:03 PDTArpan.RoyToolsReplyNeed Help regarding TPT ODBC OperatorHi Steve, I'm able to extract data using TPT ODBC Operator and Data Connector Consumar. I'm using TTU 15.10. But while running the job, getting 6060  and 6062 like Carlos. Below is th...
5797323 Jun 2016 @ 03:12 PDTArpan.RoyToolsReplyNeed Help regarding TPT ODBC OperatorHi Steve, I've installed TTU15.10 in Linux. In which directory the Data Direct ODBC drivers will reside? Do we need any additional license or cost to het these drivers?   Thanks & R...
5797223 Jun 2016 @ 01:06 PDTJok3rGeneralReplyRetrieve columns having a specific valueHi, I didn't mean column names but column value.  Thanks. 
5797123 Jun 2016 @ 12:03 PDTstami27ToolsReplyTPT Work/error Tables always protected (FALLBACK) ?Thank you for your prof. answer
5797023 Jun 2016 @ 12:01 PDTaniket.sharma@pb.comTeradata StudioReplyHow Do You Create A Teradata Database?Hi, I am new user of Teradata Express VMware. I have been able to create a database connection using the default Teradata JDBC connection properties i.e. User Name/Domain: dbc Password: dbc Ho...
5796922 Jun 2016 @ 11:40 PDTM.Saeed KhurramAsterReplyHow to list all seqeunces?Hi, One possible way is to list down all the columns with serial data type from nc_all_columns. Br, Khurram
5796822 Jun 2016 @ 11:40 PDTMichael.musicConnectivityReplyTeradata JDBC Exception Hey mu CPU does not support VT-x i have checked in the BIOS and not able to use VM Ware so i use teradatafor the same.pls lket me know. and HOW pls it is veryurgent i have to worked on that as soon...

Pages