59367 | 23 Aug 2016 @ 05:35 PDT | bhavesh_09 | Database | Reply | Teradata Implicit Casting | Hi,
What do you mean by "joined together". does it mean concat?
if it is concat then you can check it by using
select type(cast(123456 as integer)||cast(123 as byteint))
&nb... |
59366 | 23 Aug 2016 @ 05:22 PDT | juanalfonso | Teradata Database on VMWare | Topic | UltraVNC is not working in Teradata Express 15.10 | Hello,
I can't make UltraVNC work in the TD Express 15.10 Virtual Machine to make a remote desktop connection from Windows.
It's strange because in the TD Express 15.00 it worked fine, bu... |
59365 | 23 Aug 2016 @ 04:20 PDT | Deepakji | Database | Topic | Can we pass object as parameter in a macro ? | For eg :
replace macro database1.macro1(databasename char(50),tablename char(50))
as
(
Select count(*) from :databasename.:tablename;
);
Can someone let me know ho... |
59364 | 23 Aug 2016 @ 04:05 PDT | agnit.chatterjee1988 | Database | Topic | When to use Join Index | Hi ,
What are the indications from the explain plan of a query that might indicate we should use a JI [ aggregate,sparse,single table or multi table ]?
Thanks,
Agnit
|
59363 | 23 Aug 2016 @ 03:57 PDT | bhushan.koli | Database | Reply | Resource Monitoring While Running Sql querries | Yes we can use ViewPoint ,But I don't have console access of TD machine
|
59362 | 23 Aug 2016 @ 03:40 PDT | sachin.sebastian | Database | Reply | rows unbounded preceding | Why is the result of the 3rd row 500 (and not 500-80 = 420)? Should there be no subtraction within a month? Also is the date format in example given DD/MM/YYYY?
|
59361 | 23 Aug 2016 @ 02:07 PDT | CarlosAL | Database | Reply | Read Timezone Without ':' Character | Hi.
You'll have to process the string to get a readable Teradata format (the day of month must be two digits too).
BTW: 5 Mar 2015 was not Monday.
HTH.
Cheers.
Carlos.
|
59360 | 23 Aug 2016 @ 01:16 PDT | G787010 | Database | Reply | rows unbounded preceding | Hi All,
Could anyone provide the suggestion for the below query,
The requirement is, considering 2 columns with date and amount, if the month of the date is 1(January) then the amount should be t... |
59359 | 22 Aug 2016 @ 11:53 PDT | jasonmoore2k | Connectivity | Reply | Teradata JDBC Driver returns the wrong schema / column nullability | And as a follow-up question, could the driver use isNullable=N + mayBeNull=Y to instead return columnNullableUnknown?
|
59358 | 22 Aug 2016 @ 07:16 PDT | toadrw | Tools | Reply | Easyloader Schema Error 15.10 Only | Hello Steve:
Again, sorry about the confusion. Below is the error and the private log when running under 15.10. We use the same command line switches for both loads. I would assu... |
59357 | 22 Aug 2016 @ 07:13 PDT | dlcook | Tools | Reply | Easy Loader Error - 2 Teradata Systems | That did it - thanks so much, SteveF!
|
59356 | 22 Aug 2016 @ 07:13 PDT | agnit.chatterjee1988 | Database | Topic | Teradata Implicit Casting | Hi,
I was just curious to know what would happen when 2 columns with different data types integer and byteint is joined together?
According to me the byteint should be converted to integer. Howev... |
59355 | 22 Aug 2016 @ 06:31 PDT | jasonmoore2k | Connectivity | Reply | Teradata JDBC Driver returns the wrong schema / column nullability | Out of interest, what is the logic behind the property "mayBeNull" on FullContentMetadataItem? I'm noticing that it differs from the isNullable property in the second query... |
59354 | 22 Aug 2016 @ 06:18 PDT | jwah | Database | Topic | Fetch multiple columns from cursor | Hi,
I am try to use a cursor to loop through multiple values, which is fine if I only use one column.
It doesn't seem to work if I try to fetch more than one column.
e.g.
DECLARE var_a V... |
59353 | 22 Aug 2016 @ 06:05 PDT | BB160003 | Teradata Studio | Reply | Looking for a TD Studio 14.10 install package | Thank you, my friend. I had forgotten about that resource. Appreciate the info and guidance. :-)
|
59352 | 22 Aug 2016 @ 04:58 PDT | jasonmoore2k | Connectivity | Reply | Teradata JDBC Driver returns the wrong schema / column nullability | I really appreciate the effort you've put in. Looks like this is defintely an a issue in the database server itself (not the driver/connectivity).
|
59351 | 22 Aug 2016 @ 04:46 PDT | sumaps | Database | Topic | Read Timezone Without ':' Character | Hi,
I have a source data column that has a timestamp with timezone in the below format:
Mon, 5 Mar 2015 08:23:00 -0800 (PST)
I am trying to cast this as timestamp(0) with timezone FORMAT... |
59350 | 22 Aug 2016 @ 04:23 PDT | feinholz | Tools | Reply | Error Running Teradata to hadoop script "PTS00031" | Did you provide the Hadoop_Home and/or Hadoop_Prefix job variables?
|
59349 | 22 Aug 2016 @ 04:16 PDT | toadrw | Tools | Reply | Easyloader Schema Error 15.10 Only | Thanks Steve: I think I was sent the incorrect private log. I'll get back to you as soon as I can with the correct one. Sorry for the confusion.
|
59348 | 22 Aug 2016 @ 03:51 PDT | flash7gordon | Connectivity | Topic | Can you get Teradata.Client.Provider for c#/dot.net just from disk? | Hi, Have one version of the Teradata Client installed on the laptop where I do my compiles. I want to use another version of the Teradata.Client.Provider for my compiles. Can I... |
59347 | 22 Aug 2016 @ 03:40 PDT | Fred | Database | Reply | Need information about | Need more detail. For example:
How unique / non-unique are Col1 alone, Col2 alone, combined (Col1,Col2)?
How big is table1 vs table2?
|
59346 | 22 Aug 2016 @ 03:38 PDT | kchinnasamy@snaplogic.com | Tools | Topic | Error Running Teradata to hadoop script "PTS00031" | cmd: tbuild -f PTS00031 -v jobvars.txt -j PTS00031
Output:
Teradata Parallel Transporter Version 15.10.01.03 64-Bit
Job log: /opt/teradata/client/15.10/tbuild/logs/PTS00031-57.out
Job i... |
59345 | 22 Aug 2016 @ 03:32 PDT | feinholz | Tools | Reply | Easyloader Schema Error 15.10 Only | Your 15.10 job is not anything like the 15.0 job.
The 15.00 job uses the DataConnector operator and the Load operator.
The 15.10 job is using the ODBC operator and the Stream operator.
|
59344 | 22 Aug 2016 @ 03:25 PDT | kchinnasamy@snaplogic.com | Tools | Reply | Understanding teradata sample scripts | Thanks that was really helpful.
|
59343 | 22 Aug 2016 @ 03:24 PDT | feinholz | Tools | Reply | TPT Script, Only Pull Entries Within Last 6 Months? | SQL statements assigned to attributes are enclosed in single-quotes.
Because of this, all single-quotes inside that string must be escaped (doubled) in order to be preserved.
So, your Sel... |