|45556||24 Oct 2014 @ 06:14 PDT||Private Forum |
|45555||24 Oct 2014 @ 06:13 PDT||DaveWellman||Teradata Studio||Topic||'Long Text Boundary Size' - not what is expected||Hi,
I've just got TS working (finally) and have come across the following which I think is a bug.
In "Preferences / Result Set Preferences" one option is 'Long Text Boun... |
|45554||24 Oct 2014 @ 05:33 PDT||vinaynaran||Database||Topic||Subquery in Case Statement||Hi All,
This is my first Post. I would like to run somthing using Case statement in Teradata SQL Assistant.
My Query as below
case when Day_of_week = 2 then
(sel top 5&... |
|45553||24 Oct 2014 @ 05:24 PDT||romank||Teradata Studio||Reply||jre 1.6 is required for TS application warning, failed TS install||Hi, I was able to install Teradata Studio on Mac OS X 10.9.5. Steps:
1. the restriction on java version is in the file /Teradata Studio.pkg/Contents/Resources/preflight:
$javafile = '/Sy... |
|45552||24 Oct 2014 @ 04:52 PDT||dwillier||UDA||Reply||[Performance] how to avoid parsing time when executing macro via JDBC ||Hello,
Here s an exemple of the DDL of a macro.
Replace Macro FRDM_PAF.M_PAF_SALES_DAY_ALLOCATION_ALL_ALL
p_StartTime date format 'YYYY-MM-DD' ,
|45551||24 Oct 2014 @ 01:44 PDT||EUsha||General||Reply||Additional padding characters that are not removable with TRIM function||Thanks for your valuable suggestion. Now this worked when i ran the below query using BTEQ and using Sql Assistant with Teradata .Net provider.
|45550||24 Oct 2014 @ 01:29 PDT||KarthikB11||Database||Reply||Urgent help- Need to check unique items from table1 and get dimension data from table 2 for those items||I am going to assume that you want to get the corresponding information present in both the tables, you need to do an inner join
select columns from tablea A, tableb B where A.commoncolumn = B.com... |
|45549||24 Oct 2014 @ 12:43 PDT||SANDREOLI||Database||Topic||Aggregate join index can be loaded incrementally?||Aggregate join index can be loaded incrementally?
Is there a way to insert an incremental new data without having to fully recharge an aggregate join index ?
For example, if I have a 48 m... |
|45548||23 Oct 2014 @ 11:58 PDT||sujiwarrier||Database||Reply||history handled output required||Please get me sample query for this case.
|45547||23 Oct 2014 @ 11:24 PDT||SYAMALAMEDURI||Tools||Topic||MLOAD ERROR : "UTY4019 Access module error '4' received during 'File open' operation: 'Requested file not found' "||Hello Everyone,
One of our workflow (using MLOAD loader connection) used to fail with the error "UTY4019 Access module error '4' received during 'File open' operation:... |
|45546||23 Oct 2014 @ 10:37 PDT||mcfabrero||Database||Reply||FLAT SQL to SET SQL||Hi Dieter,
Yes I already did. I'm having a trouble last time, thinking of ways I can set values to my variable that I forgot to use derived tables .
Thank you for helping out :)
|45545||23 Oct 2014 @ 10:32 PDT||ARyan||Teradata Studio||Reply||Teradata express studio failed to start as it gives JVM Terminated exit code=13 error||I got the same error after downloading and attempting to run the 64bit Teradata Studio for Linux. Looks like the 1.6 JVM that comes with Teradata Express 13.0 is 32 bit - not 64 bit. I downloaded a... |
|45544||23 Oct 2014 @ 10:28 PDT||Saarang84||Database||Topic||Error While Trying to cast as Timestamp||Hi,
I'm trying to modify a code script and trying to add a few new fields to it. The tricky part I come across while try to add these fields is while trying to cast them. I would need the form... |
|45543||23 Oct 2014 @ 09:43 PDT||Raja_KT||General||Reply||Need Help with Query||Need to be careful with data type:
max(coalesce(key1,0))over(partition by id,id1 order by id,id1 rows between unbounded preceding and unbounded following) k1,max(coalesce(... |
|45542||23 Oct 2014 @ 08:38 PDT||Raja_KT||Database||Reply||Load Different DATE formats into Teradata||If your target is varchar, it can be in any format. In some cases, you need to cast.
|45541||23 Oct 2014 @ 08:32 PDT||Private Forum |
|45540||23 Oct 2014 @ 08:30 PDT||Private Forum |
|45539||23 Oct 2014 @ 07:10 PDT||jagz||Database||Topic||Urgent help- Need to check unique items from table1 and get dimension data from table 2 for those items||Hi,
I have a requirement:
Table A - contains Item information
Table B - contains physical dimension data for those items
Both are final tables
Both table have one column in common(idn)
I need... |
|45538||23 Oct 2014 @ 06:50 PDT||wavy||Database||Topic||TO_BYTES adding leading zero byte||Hi Teradata experts, I'm trying to write a query that selects a varchar column - which contains a valid hexidecimal character string - and converts it to it's byte representation.
So if I ... |
|45537||23 Oct 2014 @ 06:12 PDT||spkother||Database||Topic||Load Different DATE formats into Teradata||Hi,
I have a requirement to load different date formats into teradata(Format MM-DD-YYYY HH:MM:SS) ,what is the transformation logic to handle different type of formats
|45536||23 Oct 2014 @ 04:49 PDT||KarthikB11||Database||Topic||Error in String Parsing for Large Varchar fields.||Hi,
I am working on a task to replace a string value in Requesttext in DBC.Tables to switch views to point to different tables ( we have a dual active DB ) during backups. Requesttext in DBC.Table... |
|45535||23 Oct 2014 @ 02:25 PDT||darkchanter||Teradata Studio||Reply||Cannot install all Plug-ins||Ok, I figoured it out. Maybe you want to highlight in your Guide that these packages need to be added from the Eclipse Market Place. Some of them are ambiguous.
|45534||23 Oct 2014 @ 01:03 PDT||TDW||General||Reply||Select data from one row, while on another row in the same table.||Thanks Dieter,
Now I need to come up with an OLAP to handle a 45-day grace period end date for the same calendar.
I modified your code as follows, but I do not get the results I was looking for.
|45533||23 Oct 2014 @ 12:35 PDT||psinncig||Teradata Studio||Topic||Teradata Studio 14.10.02 Job found still running after platform shutdown||I have one user who has Teradata Studio 14.10.02 installed on her machine, and Teradata works without any problems, but when she closes the application, it gives a message "An error has occurr... |
|45532||23 Oct 2014 @ 11:53 PDT||tomnolan||Connectivity||Reply||How to call a Teradata stored procedure using openJPA?||FYI -- that is a macro, not a stored procedure. Regarding your question...
You can obtain the current database name by executing the HELP SESSION command.
Please refer to my blog ... |