#DateForumTypeThreadPost
109619 Oct 2014 @ 06:59 PDTConnectivityReplyCreate a Teradata view to an external Teradata ServerI heard that Query Grid is already launched ? Is it not so?
109517 Oct 2014 @ 12:19 PDTDatabaseReplyBusiness Day calculationTry this: case when (date2-date1)>3 then 'Y' else 'N' end
109417 Oct 2014 @ 12:14 PDTGeneralReplycompution logic of this td_week_begin function when first argument is timestamp and last third argument is time literalThis doc is a good read: http://www.info.teradata.com/HTMLPubs/DB_TTU_14_10/index.html#page/SQL_Reference/B035_1145_112A/Business_Calendars.080.001.html#ww1270902
109316 Oct 2014 @ 11:28 PDTDatabaseReply Load utilities Limit in TASMYou can have a look at this blog from Carrie, setting  DisableTDWMSessionRules...... http://developer.teradata.com/blog/carrie/2012/08/utility-session-management-its-inside-the-database-...
109216 Oct 2014 @ 10:24 PDTDatabaseReplyExcel VBA connectivity to Teradata 14Somebody has worked out: http://forums.teradata.com/forum/connectivity/teradata-driver-upgraded-from-12-to-14-excel-vba-connection-string-wont-work-now http://forums.teradata.com/forum/connectivi...
109116 Oct 2014 @ 09:39 PDTDatabaseReplyMatching within a windowIt will take sometime 12,000,000 rows, but not much. self-join, recursive query , but  I think it will give spool memory. Maybe you can think of getting into vtt or gtt, filtering what y...
109016 Oct 2014 @ 03:24 PDTGeneralReplyCould anyone pls tell me how can we get sorted results without using order by clauseWhat scenario you encountered? If not so Hmmm perfect,quality wheels are fitted for car in order that it runs as  per the steering and take you to your required destination and you don't...
108915 Oct 2014 @ 11:19 PDTDatabaseReplyUpdate the table with min and max timestampTry this: select name,st_time,end_tm from (select name,max(status)over(partition by name order by start_time) st,min(start_time) over(partition by name order by start_time) st_time,max(end_time...
108815 Oct 2014 @ 03:42 PDTConnectivityReplyload data from a webform into teradataCan you try from the examples given below. For many years, I have not coded in java ,jsp. However, references to previous posts, if it helps: https://forums.teradata.com/forum/connectivity/driver...
108715 Oct 2014 @ 02:36 PDTGeneralReplyLogan- Unable to import text file into a table using Import in BTEQcheck your data n script. delimited ..... fieldwidths look okay.
108614 Oct 2014 @ 10:42 PDTDatabaseReplySessions are getting block Without seeing the code in DS, can't say much. However, you can think of doing a lock, to avoid deadlock or use different DB if possible for error, log.....
108514 Oct 2014 @ 08:44 PDTDatabaseReplySessions are getting block You have not given infos of utilities ...... :) Looks like you are using the same DBs for error, log..... tables?  
108414 Oct 2014 @ 08:42 PDTTeradata ApplicationsReplyFastLoad process hang with concurrent sessions You could have created a new topic :). With Td 14 onwards most of the datatypes are available/compatible with almost all ETL tools or interfaces.eg Char , varchar may work. But it may fail in cert...
108314 Oct 2014 @ 08:21 PDTDatabaseReplySQL-LoopingYou can think of putting all in a subquery and union all, giving alias to all fields.
108214 Oct 2014 @ 07:44 PDTToolsReplyLoading Mutiple Oracle source table into 1 tale in TeradataMy suggestion : join all what you have in Oracle and treat it as one source , to avoid I/O, Cpu, network ..... issues and then proceed with usl. Just a while back someone asks something similar: ...
108114 Oct 2014 @ 07:27 PDTDatabaseReplyRemove Chars and get only numeric valuesstring ('AL234ps12;') looks like it contains 1 and 1 is numeric. Do you want 1 also like 1234 from the string? You can use REGEXP_SIMILAR(str,'^[0-9]+$','c')=1
108014 Oct 2014 @ 01:13 PDTConnectivityReplyCreate a Teradata view to an external Teradata ServerUSL? Can you refer to this link. http://forums.teradata.com/forum/database/how-can-we-connect-different-oracle-teradata-multiple-database-servers-to-join-the
107913 Oct 2014 @ 09:54 PDTDatabaseReplyMLOAD ErrorYoiu can check your script again. Error msg: UTY3403   Only one statement per line is allowed. Extra characters were detected beginning in column '<integer>'. ...
107813 Oct 2014 @ 09:35 PDTDatabaseReplyFailure: 3738 error while inserting String in a VARCHAR field. Need alternative way 3738   String is longer than 31000 characters. Explanation: Quoted strings cannot be longer than 31000 physical characters. Generated By: LEX modules. For Whom: ...
107713 Oct 2014 @ 06:25 PDTDatabaseReplyTranspose data from wide table to long tabletry something like this: select customerid,case when col1<>'0' then '1' else '0' end as id from your_table where col1<>'0' union all select customerid,...
107612 Oct 2014 @ 10:15 PDTDatabaseReplyResponse Row size or Constant Row size overflowIf you can perchance reduce your order by if it meets requirements.It can be due to character set session  too.
107512 Oct 2014 @ 08:10 PDTDatabaseReplyLoading Rejected records from Error Table 1 to target tableWhy do you want to load from error table? you can load from corrected source or do you have specific error templates made to load from error table?
107412 Oct 2014 @ 07:58 PDTDatabaseReplyGreatest() function error in TD15I tried it works fine: select TD_SYSFNLIB.greatest(1,4,5);
107310 Oct 2014 @ 07:44 PDTDatabaseReplySeparation of columns into rowsm is not no of days in month. ok then try to work out with simple substr like select id,inst,package,substr(demog,1,3) from yourtable ... union all select id,inst,package,substr(demog,5,5) ...
107210 Oct 2014 @ 07:35 PDTDatabaseReplyAnalytic functionIt looks like you need rows between preceding or following. With data, it will be more clear.

Pages