59316 | 22 Aug 2016 @ 08:09 PDT | toadrw | Tools | Topic | Easyloader Schema Error 15.10 Only |
Hello:
We're receiving the following error on 15.10 whcih we were not receiving on 15.00. Could you please help? Here's our TD Load command line:
tdload -r... |
59315 | 22 Aug 2016 @ 07:33 PDT | cgermain904 | Database | Topic | Convert date > xx/01/xxxx of given month to first of following month | Hi,
I'm new to the forum and newly learning SQL. I'm hoping for some help on converting dates upon returning the query. The issue I have is that there is a PROCESS_DT field that I'm us... |
59314 | 22 Aug 2016 @ 06:32 PDT | urskumar | Database | Reply | How to convert the varchar to time(6) In Teradata? | Thank you bhavesh its working fine :)
|
59313 | 22 Aug 2016 @ 05:18 PDT | kiran72329 | General | Reply | interview help | Hi,
Please forward the questions to kiran72329@gmail.com
|
59312 | 22 Aug 2016 @ 04:27 PDT | bhavesh_09 | Database | Reply | How to convert the varchar to time(6) In Teradata? | try this:
select cast ('11:30'||':00.00' as time(6))
|
59311 | 22 Aug 2016 @ 04:07 PDT | Smac | Database | Reply | Create NUPI and USI having the same Column | Many Thanks VandebergB
Regarding 1st option - Multiset table will be effective when during DML activity. i.e., It will ignore the uniqueness checking while doing insert, update, etc.
We will ... |
59310 | 22 Aug 2016 @ 03:49 PDT | sachin.sebastian | Database | Reply | Resource Monitoring While Running Sql querries | You can use Viewpoint for this.
|
59309 | 22 Aug 2016 @ 12:25 PDT | Liji.Anooj | General | Reply | BTEQ .IF ERRORCODE <> 0 THEN <QUERY> | Hi Amit,
BTEQ commands must be preceded by a period '.'
so use .IF in your BTEQ.So query must be
.IF ACTIVITYCOUNT=2 THEN
<QUERY >
|
59308 | 21 Aug 2016 @ 09:07 PDT | jasonmoore2k | Connectivity | Reply | Teradata JDBC Driver returns the wrong schema / column nullability | I've put together an example outside of the Spark application which has confirmed my suspicion above (using 15.10.00.22):
val driver = new com.teradata.jdbc.TeraDriver()
val url = "jdb... |
59307 | 21 Aug 2016 @ 04:15 PDT | BB160003 | Teradata Studio | Topic | Looking for a TD Studio 14.10 install package | Preparing collateral for a customer that uses Studio 14.10. I skipped the 14.10 versions of all utilities and went straight to 15.10. Looks like the interfaces have changed a bit and I now need a 1... |
59306 | 21 Aug 2016 @ 04:13 PDT | krishna1985 | Database | Reply | Padding and timestamp | thank all ...it worked like charm L:)
|
59305 | 21 Aug 2016 @ 06:58 PDT | naughtycreator | Database | Reply | How to install Teradata Express on Windows 7 64 bit machine? | http://kosmisch.net/Blog/DataAndBusinessIntelligence/Archive/2014/6/29/1a7ee23474544efb9e2318c7a771f74f.html
|
59304 | 20 Aug 2016 @ 10:19 PDT | ChrisRx | Tools | Reply | Teradata Tool and Utilities package for Linux | Is there a particular reason why the TTU for Windows is made available and the TTU for Linux is not?
|
59303 | 20 Aug 2016 @ 05:20 PDT | dnoeth | Tools | Reply | Unicode Export through TPT | You must triple the VarChar size in your Export Schema, not in your Select.
Additionally you don't need to specify a schema at all, when the Format is DELIMITED, and your Select can be a... |
59302 | 20 Aug 2016 @ 04:01 PDT | venkata_k01 | Tools | Reply | Zero records are fetching when using where statement in TPT | Hi Steve,
We tried many ways by putting select statement in the script but still no luck.
It would be very helpful if you could please provide one simple sample example.
Thanks &... |
59301 | 19 Aug 2016 @ 04:58 PDT | sagar_ | General | Reply | Concatenate | Hi,
I can see your solution. But just thought of sharing below logic.
CREATE MULTISET TABLE TBL(COL1 SMALLINT,COL2 SMALLINT,COL3 SMALLINT,COL4 SMALLINT,COL5 SMALLINT);
INSERT INT... |
59300 | 19 Aug 2016 @ 04:45 PDT | jasonmoore2k | Connectivity | Reply | Teradata JDBC Driver returns the wrong schema / column nullability | True, it is reducing a three-value to a boolean by mapping the unknown to nullable = true, and this might explain case #1.
But I can see an actual problem in case #2 where every column was re... |
59299 | 19 Aug 2016 @ 04:14 PDT | dfranks44 | Database | Reply | Set QueryBand as JDBC Connection Parameter | This is exactly what I need. I can tease enough information out of here to trace our blocking issues down to the process id's in our job launcher logs. Thank you very much.
Y... |
59298 | 19 Aug 2016 @ 03:56 PDT | feinholz | Tools | Reply | Unicode Export through TPT | Please send me your script.
(I may make changes to it.)
|
59297 | 19 Aug 2016 @ 03:51 PDT | srivigneshkn | Tools | Reply | Unicode Export through TPT | I have changed the empcatnumber to 30. I even tried increasing the size to 60/90 but the error meesage remains the same.
My TPT version is Teradata Parallel Transporter Version 15.10.01.02 64... |
59296 | 19 Aug 2016 @ 03:32 PDT | PrajaktaDeosthali | Connectivity | Reply | Querying Teradata from JavaScript/jQuery? | Is there any update on this particular question?
I read Teradata Magazine article, but I am not able to find the REST API for Teradata system. It would be really helpful if someone can provi... |
59295 | 19 Aug 2016 @ 03:08 PDT | monsieurvinodh | Teradata Studio | Reply | Teradata 15.1 Error when trying to execute query | Downloaded Just 20 mins back.. It is on Windows 7 64 bit machine.. Version --> TeradataStudioExpress__win64_x86.15.11.00.00
Below Error Message: [[ Only when submitting queries ]]
f... |
59294 | 19 Aug 2016 @ 03:07 PDT | feinholz | Tools | Reply | Unicode Export through TPT | In the example script you sent, EmpCatNumber was defined in the table as VARCHAR(10).
If that is the case, then the script must specify VARCHAR(30).
If this is done correctly, I am not sure how T... |
59293 | 19 Aug 2016 @ 02:01 PDT | srivigneshkn | Tools | Reply | Unicode Export through TPT | Hi Steve,
I have mentioned UTF8 and tripled the size of the unicode fields, i still get the following error.
EXPORT_OPERATOR: connecting sessions
TPT_INFRA: TPT02638: Error: ... |
59292 | 19 Aug 2016 @ 01:50 PDT | tomnolan | Database | Reply | Set QueryBand as JDBC Connection Parameter | If you are using Teradata Database 14.0 or later, have you considered examining the Client Attributes information?
It is documented here:
http://developer.teradata.com/doc/connectivity/jd... |