All forum activity

#DateUserForumTypeThreadPost
5916915 Aug 2016 @ 11:47 PDTpinaldbaToolsReplyTPT Wizard 15.10.01.02 64-Bit: error occurred while accessing the logThe error can be avoided by just editing the config file of the tptwizard.properties. It's recomdonned to take the backup of the existing tptwizard.properties file. Edit the path of...
5916815 Aug 2016 @ 10:23 PDTkrishna1985DatabaseTopicSQL query needed---UrgentHi All, I have source data as Month         x                   y Aug 14     3000           &n...
5916715 Aug 2016 @ 09:37 PDTSmacGeneralReplyMulti Column Primary Index and Secondary IndexMany Thank Fred. Helps lot!  
5916615 Aug 2016 @ 08:01 PDTdblochConnectivityReplyOLEDB Driver of TD15.10.NET Connector seems much slower than old OLEDB connector btw.
5916515 Aug 2016 @ 07:46 PDTkrishna1985ToolsReplyCasting Date in Bteq utilitiesHi Fred, thank you very much for your inputs howver I have tried to create the staging table with the below query and used oTranslate funcion to pad 0 if its single digit    substri...
5916415 Aug 2016 @ 05:58 PDTau185006Teradata Database on AWSReplyDoes AWS have bring-your-own-license model for Teradata Database?Not currently but it on the roadmap as an offer.    I am nt aware of the Target date, but will update when there is one.    
5916315 Aug 2016 @ 05:55 PDTfranceszhuTeradata Database on AWSTopicDoes AWS have bring-your-own-license model for Teradata Database?I am looking for Teradata database solutions on AWS. Does AWS have bring-your-own-license model for Teradata Database? Thanks.
5916215 Aug 2016 @ 05:13 PDTCrayRayDatabaseTopicPerformance Issue - Left Join vs UpdateHi everyone, I have 2 tables as below:   Main (20 mil rows, 50 other columns): Col1  Col2  Col3 a       2      3 b       2   &n...
5916115 Aug 2016 @ 04:52 PDTfranceszhuTeradata Database on AWSReplyDoes AWS provides previous versions of Teradata Database?Thanks for the information.
5916015 Aug 2016 @ 04:00 PDTskunkwerkToolsReplyTPT with JDBC to Kafkathanks Tom.   Does anyone have a working Teradata -> Kafka configuration they can share? I have Kafka, Zookeeper, & a Schema Registry up and running. But when I run the JDBC connect...
5915915 Aug 2016 @ 02:09 PDTau185006Teradata Database on AWSReplyDoes AWS provides previous versions of Teradata Database?15.10 is the only version of the database available on AWS.
5915815 Aug 2016 @ 01:39 PDTfranceszhuTeradata Database on AWSTopicDoes AWS provides previous versions of Teradata Database?I am looking for Teradata database version 14.10 on AWS. I see all Teradata database products on AWS are Version 15.10.02.06. Does AWS provide previous versions. If yes, how do I get it? &nbs...
5915715 Aug 2016 @ 01:09 PDTmitsukiefiToolsTopicFatal Error with TD TPT APIDear All Our reporting tool generates the following SQL query to be executed on TD 15.10: select a11.Gl_Acct_Prod_Grp_Id Gl_Acct_Prod_Grp_Id, a11.Gl_Acct_Prod_Grp_Src_Id Gl_Acct_Prod_Grp_Sr...
5915615 Aug 2016 @ 12:16 PDTFredToolsReplyCasting Date in Bteq utilitiesFastLoad supports only limited data type conversions, either implicit or using Teradata-style syntax. And at a minimum you would need to change the input to always have 2 digits for the h...
5915515 Aug 2016 @ 11:50 PDTFredDatabaseReplyA table with non-latin characters in table name and column names doesn't display properlyhelp session;
5915415 Aug 2016 @ 11:44 PDTFredUDAReplyBT/ETNot sure what you mean by "in Unix". Do you mean "in BTEQ?" By default SQL Assistant stops executing SQL when an error is encountered. In BTEQ you must explicitly check&n...
5915315 Aug 2016 @ 11:22 PDTKellnerKToolsReplyBTEQ and OReplaceThank you Dieter, that was exactly the case.  I did not realize that by not explicity casting the oReplace that it would expand the field size so significantly.  Casting back to VarChar(3...
5915215 Aug 2016 @ 11:21 PDTFredGeneralReplyMulti Column Primary Index and Secondary IndexNon-unique PI(acctid) may be best choice if number of rows per acctid isn't too huge. Partitioning on bus_dt may be better choice than USI. Again, somewhat depends on avg / max number of ...
5915115 Aug 2016 @ 10:58 PDTfeinholzToolsReplyUnderstanding teradata sample scriptsThe $FILE_WRITER and $LOAD syntax describes the use of templates. Those templates define the operators you are trying to use, and those operator definitions are found in the "templates" ...
5915015 Aug 2016 @ 10:32 PDTraddatz.dennis@gmail.comDatabaseReplyDatatype of a Column of a ViewI have the following CASE statement in my view: SELECT   CAST((CASE EV.EVNT_CD     WHEN 'A001' THEN 'SOMETHINGxxxxxxxx'      ELSE 'UN...
5914915 Aug 2016 @ 07:16 PDTHanCDatabaseReplyBteq import the output characters got cut off by 2 Thank you so much Dieter! It is working as expected. You made my day!
5914815 Aug 2016 @ 07:08 PDTsdcDatabaseTopicSQL command for setting connection option to return generated keysHello, I am setting the following parameter in a connection string: ReturnGeneratedKeys="C" Instead, I'd like to set this option via an SQL command after having made the connecti...
5914715 Aug 2016 @ 06:07 PDTsk8s3iDatabaseReplyCapturing MAX marks for Each Student when the MArks are in ColumnsWorked as a charm! Thanks Dieter! :-D
5914615 Aug 2016 @ 05:20 PDTdnoethConnectivityReplyCLI CONNECTION USING HOSTS NAME INSTEAD OF IP ADDR. - EXTENDED TIME FOR LOGONThe delay is caused by the lookup to find an ip-address for teracli., the COP discovery: BTEQ/CLI adds COP1 to the hostname and resolves it to an p-address, if successful the number is increased t...
5914515 Aug 2016 @ 04:41 PDTdnoethDatabaseReplyCapturing MAX marks for Each Student when the MArks are in ColumnsYou should find 9 UDFs in syslib and 10 in td_sysfnlib with the name GREATEST (but different specific names). The functions in syslib are not the built-in functions (those UDFs have been installed...

Pages