All forum activity

#DateUserForumTypeThreadPost
5949229 Aug 2016 @ 03:20 PDTharshainocuToolsReplyTPT attributes SkipRows and SkipRowsEveryFile Teradata Parallel Transporter SQL DDL Operator Version 15.00.00.05 DDL_OPR_table: private log specified: table_log DDL_OPR_table: connecting sessions DDL_OPR_table: sending SQL requests DDL_O...
5949129 Aug 2016 @ 01:39 PDTfomerTeradata StudioTopicViews the rows being transferred overOnce a Teradata Studio Job Transfer has been started(migrating from pipe delimited flat file into Teradata), is it possible for me to view how many rows have been moved? I am trying to transfer a 7...
5949029 Aug 2016 @ 01:21 PDTtomnolanDatabaseReplymoving first 4 characters to last 4 charactersThe DATE FORMAT approach is probably better, but since you mentioned substring, for comparison, the substring+concatenation approach would look like the following:   select substring(cast(ti...
5948929 Aug 2016 @ 01:06 PDTefgeorge18DatabaseReplymoving first 4 characters to last 4 charactersI resolved this one: select TO_CHAR(cast(cast(cast(table.column as CHAR(8) ) as DATE FORMAT 'YYYYMMDD')  as DATE FORMAT'MMDDYYYY'),'MMDDYYYY') AS converted
5948829 Aug 2016 @ 12:16 PDTwgfagundesDatabaseReplyODBC TimeStamp Hello Dieter, Did not work.. any other ideia, for example, modify user to set a timezone or use a profile with a timezone to the user?  
5948729 Aug 2016 @ 11:40 PDTflash7gordonConnectivityReplyCan you get Teradata.Client.Provider for c#/dot.net just from disk?NetFx, Thanks this is helpful.   I know the .Net Data Provider for Teradata folder and have used it a lot.   Hopefully the directory is all I need to get it to compile and run (I don'...
5948629 Aug 2016 @ 10:46 PDTFredDatabaseReplyCan we pass object as parameter in a macro ? You can't use SysExecSQL for a data-returning statement. You need to use a second (dynamic) cursor:   DECLARE sel_csr CURSOR FOR sel_stmt; PREPARE sel_stmt FROM create_user_sql; OPEN s...
5948529 Aug 2016 @ 10:44 PDTNetFxConnectivityReplyCan you get Teradata.Client.Provider for c#/dot.net just from disk?1- You can install two or more version of the .NET Data Provider for Teradata on you workstation. This concept is called Side-By-Side and the .NET Data Provider for Teradata has supported this feat...
5948429 Aug 2016 @ 10:37 PDTflash7gordonConnectivityReplyCan you get Teradata.Client.Provider for c#/dot.net just from disk?When I use Oracle or MS Sql I never even think about this.   MS Sql I won't hold against Teradata, they control the compiler.
5948329 Aug 2016 @ 10:34 PDTFredDatabaseReplyOutput is different in DBC.diskspace and for Dbc.diskspacevWhere there are both, the views with "V" are the ones everyone should be using - since TD12. The ones without V are only for backward compatibility.   Currently, object n...
5948229 Aug 2016 @ 10:05 PDTflash7gordonConnectivityReplyCan you get Teradata.Client.Provider for c#/dot.net just from disk?One of my associates asked this question directly of Teradata support.  This is what they said:  "TERADATA DO NOT (SIC) SUPPORT THE REVERSE SCENARIO; I.E. AN APPLICATION BUILT WITH A...
5948129 Aug 2016 @ 10:00 PDTfgrimmerTeradata StudioReplyTools > Create > Database, User etc. dialogs missing in Teradata Studio Express 15Which version of Studio are you using. In Studio 15.11, the Create Database option is now part of the Object List Viewer. You will need to open the Administration Perspective and in the Navigator V...
5948029 Aug 2016 @ 07:59 PDTefgeorge18DatabaseTopicmoving first 4 characters to last 4 charactersHello, I have a field time_key (bigint) that shows '20160817' I want to format it so that it displays as '08172016' in the sql.   I've played around with trim,cast,subs...
5947929 Aug 2016 @ 07:18 PDTThiru07ToolsTopicError Table MloadOn running the following mload script : .LOGTABLE EDB.LOG_prepd_usge; .LOGON abc.net/user,pass; DATABASE EITOPSDB; .BEGIN IMPORT MLOAD TABLES prepd_usge WORKTABLES EDB.WT_prepd_usge...
5947829 Aug 2016 @ 07:05 PDTSQLfan123DatabaseReplyFiltering results of concatenationThanks, Fred! I used this approach: "CAST(EXTRACT(YEAR from saledate) as VARCHAR(4))||' '||CAST(EXTRACT(MONTH from saledate) as VARCHAR(4)) AS date_num" and it worked perfectly.
5947729 Aug 2016 @ 06:24 PDTvcDatabaseTopicOutput is different in DBC.diskspace and for Dbc.diskspacevHello, When I am firing the below 2 query,I am getting the same output as  abc_stg,test_mdl,123_srci for databasename columns But when I replace Dbc.diskspacev with dbc.diskspace the output ...
5947629 Aug 2016 @ 06:09 PDTsachin.sebastianDatabaseReplyextract time from timestamp(6)SELECT CAST(SUBSTR(CAST(<COL> AS VARCHAR(20)),12,19) AS TIME(0))
5947529 Aug 2016 @ 04:15 PDTsasnaiDatabaseTopicHow to transpose row values Hi,  I have a data like id    info 1     AB 1234 / CD 5678 / EF 9101. I want output like this id info 1 AB 1234 1 CD 5678 1 EF 9101 I tried using TD_UNPIVOT functi...
5947429 Aug 2016 @ 03:59 PDTsachin.sebastianDatabaseReplyMerge different rows in one rowYou could do this: SEL Act_dt,cust_id and cust_line_id,MAX(flg1), MAX(flg2), MAX(flg3), MAX(metric1), MAX(metric2), MAX(metric3)  FROM <TABLE> GROUP BY 1...
5947329 Aug 2016 @ 02:57 PDTDeepakjiDatabaseReplyCan we pass object as parameter in a macro ? thanks Todd .. after your suggestion i tried with stored procedure .. but still i m a bit confused how to implement it with stored procedure.. can u please guide me ? I m trying it .. but i m gett...
5947229 Aug 2016 @ 01:05 PDTkamlesh114DatabaseReplyPPIThank you very much Todd. I got it what i needed.  
5947128 Aug 2016 @ 09:48 PDTmario93GeneralReplyinterview helpHi There, Thank you very much for  all the effort, & could you please mail to  mariogomez9041@gmail.com  all those stuff. Thats very helpfull for us.  ...
5947028 Aug 2016 @ 04:26 PDTFredDatabaseReplyFiltering results of concatenationIt's the extra spaces introduced by implicit typecast from INTEGER result of extract. The default is FORMAT -(10)9 so the year, for example is 2005 with 5 leading spaces. Explicitly CAST(EXTRA...
5946928 Aug 2016 @ 04:09 PDTSegebreTeradata StudioReplyTools > Create > Database, User etc. dialogs missing in Teradata Studio Express 15But none of them have create database option!  
5946828 Aug 2016 @ 04:06 PDTFredTeradata Database on VMWareReplyODBC on Teradata on VMTry setting ODBCINI and/or ODBCINST to make sure those are the ini files you are actually using, e.g. ODBCINI=/opt/teradata/client/15.10/odbc_64/odbc.ini

Pages