All forum activity

#DateUserForumTypeThreadPost
4555624 Oct 2014 @ 06:14 PDTPrivate Forum
4555524 Oct 2014 @ 06:13 PDTDaveWellmanTeradata StudioTopic'Long Text Boundary Size' - not what is expectedHi,   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...
4555424 Oct 2014 @ 05:33 PDTvinaynaranDatabaseTopicSubquery in Case StatementHi All, This is my first Post. I would like to run somthing using Case statement in Teradata SQL Assistant. My Query as below sel case when  Day_of_week = 2 then   (sel top 5&...
4555324 Oct 2014 @ 05:24 PDTromankTeradata StudioReplyjre 1.6 is required for TS application warning, failed TS installHi, 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...
4555224 Oct 2014 @ 04:52 PDTdwillierUDAReply[Performance] how to avoid parsing time when executing macro via JDBC Hello, Here s an exemple of the DDL of a macro. Thanks you Replace Macro FRDM_PAF.M_PAF_SALES_DAY_ALLOCATION_ALL_ALL ( p_StartTime date format 'YYYY-MM-DD' , p_E...
4555124 Oct 2014 @ 01:44 PDTEUshaGeneralReplyAdditional padding characters that are not removable with TRIM functionThanks for your valuable suggestion. Now this worked when i ran the below query using BTEQ and using Sql Assistant with Teradata .Net provider. SELECT     COL1,   &nbs...
4555024 Oct 2014 @ 01:29 PDTKarthikB11DatabaseReplyUrgent help- Need to check unique items from table1 and get dimension data from table 2 for those itemsI 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...
4554924 Oct 2014 @ 12:43 PDTSANDREOLIDatabaseTopicAggregate 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...
4554823 Oct 2014 @ 11:58 PDTsujiwarrierDatabaseReplyhistory handled output requiredPlease get me sample query for this case.
4554723 Oct 2014 @ 11:24 PDTSYAMALAMEDURIToolsTopicMLOAD 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:...
4554623 Oct 2014 @ 10:37 PDTmcfabreroDatabaseReplyFLAT SQL to SET SQLHi 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 :) MC
4554523 Oct 2014 @ 10:32 PDTARyanTeradata StudioReplyTeradata express studio failed to start as it gives JVM Terminated exit code=13 errorI 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...
4554423 Oct 2014 @ 10:28 PDTSaarang84DatabaseTopicError While Trying to cast as TimestampHi, 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...
4554323 Oct 2014 @ 09:43 PDTRaja_KTGeneralReplyNeed Help with QueryNeed to be careful with data type:   select id,id1, max(coalesce(key1,0))over(partition by id,id1 order by id,id1 rows between unbounded preceding and unbounded following) k1,max(coalesce(...
4554223 Oct 2014 @ 08:38 PDTRaja_KTDatabaseReplyLoad Different DATE formats into TeradataIf your target is varchar, it can be in any format. In some cases, you need to cast.
4554123 Oct 2014 @ 08:32 PDTPrivate Forum
4554023 Oct 2014 @ 08:30 PDTPrivate Forum
4553923 Oct 2014 @ 07:10 PDTjagzDatabaseTopicUrgent help- Need to check unique items from table1 and get dimension data from table 2 for those itemsHi, 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...
4553823 Oct 2014 @ 06:50 PDTwavyDatabaseTopicTO_BYTES adding leading zero byteHi 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 ...
4553723 Oct 2014 @ 06:12 PDTspkotherDatabaseTopicLoad Different DATE formats into TeradataHi,     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
4553623 Oct 2014 @ 04:49 PDTKarthikB11DatabaseTopicError 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...
4553523 Oct 2014 @ 02:25 PDTdarkchanterTeradata StudioReplyCannot install all Plug-insOk, 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.
4553423 Oct 2014 @ 01:03 PDTTDWGeneralReplySelect 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. ...
4553323 Oct 2014 @ 12:35 PDTpsinncigTeradata StudioTopicTeradata Studio 14.10.02 Job found still running after platform shutdownI 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...
4553223 Oct 2014 @ 11:53 PDTtomnolanConnectivityReplyHow 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 ...

Pages