All forum activity

#DateUserForumTypeThreadPost
5926919 Aug 2016 @ 01:24 PDTJohannes VinkGeneralReplyDisable Logging in TPTThe script/program that calls the TPT also specified the logging and the detail of the logging. You need to look into that.
5926818 Aug 2016 @ 10:37 PDTgtmmajTeradata StudioReplyTeradata 15.1 Error when trying to execute queryIt is now working fine for me. Thanks @fgrimmer. I am now using TD 15.11
5926718 Aug 2016 @ 09:41 PDTRevathiSToolsTopicMonth days !!!Hi, Could any one explain this code logic, DAY(DATEADD(ms,-2,DATEADD(MONTH, DATEDIFF(MONTH,0,CURRENT_DATE.DAY)+1,0))) and provide me alternate code in tera data...   Thanks..
5926618 Aug 2016 @ 09:34 PDTRevathiSTeradata DebuggerReplyFetching the last date of the current Quarter !!! Hi Dieter,            Yeah its working for the end of current quarter. Thank you. The code for fetching the current quarter's first date is working fine.  If...
5926518 Aug 2016 @ 09:12 PDTRevathiSUDAReplyCONVERT and DATEDIFF in TeradataHii Dieter,   Thanks. How can i handle this convert (SMALLDATETIME, {fn CURDATE()}--> epoch time format in teradata.??
5926418 Aug 2016 @ 07:28 PDTkrishna1985DatabaseTopicPadding and timestampHi All,   I have a column with the format column x and beow are the values.  10/1/15 4/1/16 7/1/15 I want to convert the same into 2015-01-10 00:00:00 and same for others. I wan...
5926318 Aug 2016 @ 07:06 PDTjasonmoore2kConnectivityReplyTeradata JDBC Driver returns the wrong schema / column nullabilityThe call is made in Apache Spark's infrastructure, and it uses ResultSetMetaData.isNullable as you expected: https://github.com/apache/spark/blob/v2.0.0/sql/core/src/main/scala/org/apache/spar...
5926218 Aug 2016 @ 03:12 PDTsdcDatabaseReplySQL command for setting connection option to return generated keysAny insight, anyone? (Bump)
5926118 Aug 2016 @ 02:11 PDTdfranks44DatabaseTopicSet QueryBand as JDBC Connection ParameterHi all, I would like to perform query banding at the connection level.  We are trying to track down a blocking issue, across a couple hundred, that are all hitting a single metadata table. &n...
5926018 Aug 2016 @ 11:44 PDTtomnolanDatabaseReplyUse teradata with jmeter The Apache JMeter documentation says that the JDBC Driver's jar files must be present on JMeter's classpath, and also says that it is "easiest to copy .jar file into JMeter's ...
5925918 Aug 2016 @ 11:42 PDTtomnolanDatabaseReplyUse teradata with jmeter Documentation for how to configure a JDBC connection for JMeter is available here: http://jmeter.apache.org/usermanual/component_reference.html#JDBC_Connection_Configuration   For the "...
5925818 Aug 2016 @ 11:38 PDTsrivigneshknGeneralTopicDisable Logging in TPTHi, I am executing my TPT export and each time, it does a detailed logging in the following logs folder. This detailed logging makes the tpt to fail with out of space error in the logs folder. L...
5925718 Aug 2016 @ 11:12 PDTFredDatabaseReplyUse teradata with jmeter Just as you would for any other database? You can use the Teradata JDBC driver to submit SQL statements directly, and/or drive some application that uses Teradata on the back end.
5925618 Aug 2016 @ 11:11 PDTyamyroDatabaseReplyHow to make substring with the second or third occurrence of a charaterHi Dieter, Do you know if there is a bug in TERADATA  VERSION 14.00.03.02 for this fuction?, when I tried to use I had an error: SELECT STRTOK (NULL,'|',2) --> SELECT Failed. ...
5925518 Aug 2016 @ 09:29 PDTlatingntlmanDatabaseReplyDeclaring variables in Terdata SQL AssistantCan someone provide the link to the DB2 forum please?
5925418 Aug 2016 @ 09:26 PDTericawang0829ToolsTopicCLI error" MTDP: EM_GSSINITFAIL<235>:... When logging on BTEQ in remote serverHi all, I'm trying to use BTEQ Utility inside a remote server. What I did was to install TTU 15.10.05 Windows in my local machine first and then copied the installed folder into the remote ser...
5925318 Aug 2016 @ 09:25 PDTlatingntlmanDatabaseReplyDeclaring variables in Terdata SQL AssistantGot it!  Thanks for explanation. This is my first post and I'm a TD newbie, so, since I'm using TD sql assistant to connect to DB2 and queries objects, I thouht it should be submitted ...
5925218 Aug 2016 @ 08:51 PDTflash7gordonConnectivityReplyTeradata Client 15.0 to 15.11 for c# dot.net buildsThanks, this was helpful.  I found the old 15.0 dll file, deleted the current reference, and added the old one, thens set "Specific Version" to True.   Unfortunately, like all t...
5925118 Aug 2016 @ 08:12 PDTToddAWalterToolsReplyGetting export results in same date format as in Teradata table using BTEQPlease provide the SHOW TABLE. Need to see the data type and format for the column that contains the date.
5925018 Aug 2016 @ 07:48 PDTdnoethDatabaseReplyHow to use regex in Teradata or 'LIKE' operator in teradata[0-9] is a range of characters and + means repeat the previous at least once.
5924918 Aug 2016 @ 07:44 PDTdnoethUDAReplyCONVERT and DATEDIFF in TeradataFor difference in days it should be SELECT CURRENT_DATE - DATE '2016-08-20'
5924818 Aug 2016 @ 06:55 PDTtomnolanConnectivityReplyTeradata JDBC Driver returns the wrong schema / column nullabilityWhich JDBC API method does your application call in order to obtain the column nullability information?   If your application is calling the ResultSetMetaData.isNullable method, for that met...
5924718 Aug 2016 @ 06:53 PDTRevathiSUDAReplyCONVERT and DATEDIFF in TeradataHi, For this SQL Query select DATEDIFF(DAY,'2016-08-20', convert (SMALLDATETIME, {fn CURDATE()})).. I need to achieve this in Tera data. Since datediff is problem to work with here in ter...
5924618 Aug 2016 @ 05:46 PDTsanjeevkumar044DatabaseReplyHow to use regex in Teradata or 'LIKE' operator in teradataHi Dieter, I would like to know more about '[0-9]+' .    request you to briefly explain imporntance of + and how does the '[0-9]+' block work.     Thank you,...
5924518 Aug 2016 @ 05:30 PDTpadhiaDatabaseReplyDeclaring variables in Terdata SQL AssistantDECLARE VARIABLE is an embedable, non-excutable statement meant for pre-processor (or stored-procedures). See http://www.ibm.com/support/knowledgecenter/SSEPEK_10.0.0/sqlref/src/tpc/db2z_sql_d...

Pages