59266 | 18 Aug 2016 @ 10:37 PDT | gtmmaj | Teradata Studio | Reply | Teradata 15.1 Error when trying to execute query | It is now working fine for me. Thanks @fgrimmer. I am now using TD 15.11
|
59265 | 18 Aug 2016 @ 09:41 PDT | RevathiS | Tools | Topic | Month 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..
|
59264 | 18 Aug 2016 @ 09:34 PDT | RevathiS | Teradata Debugger | Reply | Fetching 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... |
59263 | 18 Aug 2016 @ 09:12 PDT | RevathiS | UDA | Reply | CONVERT and DATEDIFF in Teradata | Hii Dieter,
Thanks. How can i handle this convert (SMALLDATETIME, {fn CURDATE()}--> epoch time format in teradata.??
|
59262 | 18 Aug 2016 @ 07:28 PDT | krishna1985 | Database | Topic | Padding and timestamp | Hi 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... |
59261 | 18 Aug 2016 @ 07:06 PDT | jasonmoore2k | Connectivity | Reply | Teradata JDBC Driver returns the wrong schema / column nullability | The 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... |
59260 | 18 Aug 2016 @ 03:12 PDT | sdc | Database | Reply | SQL command for setting connection option to return generated keys | Any insight, anyone? (Bump)
|
59259 | 18 Aug 2016 @ 02:11 PDT | dfranks44 | Database | Topic | Set QueryBand as JDBC Connection Parameter | Hi 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... |
59258 | 18 Aug 2016 @ 11:44 PDT | tomnolan | Database | Reply | Use 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 ... |
59257 | 18 Aug 2016 @ 11:42 PDT | tomnolan | Database | Reply | Use 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 "... |
59256 | 18 Aug 2016 @ 11:38 PDT | srivigneshkn | General | Topic | Disable Logging in TPT | Hi,
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... |
59255 | 18 Aug 2016 @ 11:12 PDT | Fred | Database | Reply | Use 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.
|
59254 | 18 Aug 2016 @ 11:11 PDT | yamyro | Database | Reply | How to make substring with the second or third occurrence of a charater | Hi 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. ... |
59253 | 18 Aug 2016 @ 09:29 PDT | latingntlman | Database | Reply | Declaring variables in Terdata SQL Assistant | Can someone provide the link to the DB2 forum please?
|
59252 | 18 Aug 2016 @ 09:26 PDT | ericawang0829 | Tools | Topic | CLI error" MTDP: EM_GSSINITFAIL<235>:... When logging on BTEQ in remote server | Hi 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... |
59251 | 18 Aug 2016 @ 09:25 PDT | latingntlman | Database | Reply | Declaring variables in Terdata SQL Assistant | Got 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 ... |
59250 | 18 Aug 2016 @ 08:51 PDT | flash7gordon | Connectivity | Reply | Teradata Client 15.0 to 15.11 for c# dot.net builds | Thanks, 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... |
59249 | 18 Aug 2016 @ 08:12 PDT | ToddAWalter | Tools | Reply | Getting export results in same date format as in Teradata table using BTEQ | Please provide the SHOW TABLE. Need to see the data type and format for the column that contains the date.
|
59248 | 18 Aug 2016 @ 07:48 PDT | dnoeth | Database | Reply | How 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.
|
59247 | 18 Aug 2016 @ 07:44 PDT | dnoeth | UDA | Reply | CONVERT and DATEDIFF in Teradata | For difference in days it should be SELECT CURRENT_DATE - DATE '2016-08-20'
|
59246 | 18 Aug 2016 @ 06:55 PDT | tomnolan | Connectivity | Reply | Teradata JDBC Driver returns the wrong schema / column nullability | Which 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... |
59245 | 18 Aug 2016 @ 06:53 PDT | RevathiS | UDA | Reply | CONVERT and DATEDIFF in Teradata | Hi, 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... |
59244 | 18 Aug 2016 @ 05:46 PDT | sanjeevkumar044 | Database | Reply | How to use regex in Teradata or 'LIKE' operator in teradata | Hi 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,... |
59243 | 18 Aug 2016 @ 05:30 PDT | padhia | Database | Reply | Declaring variables in Terdata SQL Assistant | DECLARE 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... |
59242 | 18 Aug 2016 @ 05:24 PDT | prateek.bansal07 | Tools | Reply | Getting export results in same date format as in Teradata table using BTEQ |
I tried using SET SESSION DATEFORM=ANSIDATE; to get all date fields in YYYY-mm-dd format but the end result is always yy-MM-dd :( Is there anything wrong with my shell script?/... |