All forum activity

#DateUserForumTypeThreadPost
5950130 Aug 2016 @ 02:19 PDThv186006DatabaseTopicFormatting in TeradataHi guys, New on Teradata. For a client I am trying to format some numbers. The wish is to paste the string 'EUR' to a value as follows. EUR 0.32 EUR 0.00 EUR 189.56 EUR 1,234.87  ...
5950030 Aug 2016 @ 01:58 PDTpbvillafloresToolsReplyFastExport Remove Binary/Indicator Values in Outmod Is there an example of OUTMOD somewhere that I can reference?
5949929 Aug 2016 @ 11:29 PDTThiru07ToolsReplyError Table MloadHi Ivyuan, Cingular_BID.txt data file contains pipe delimited records as below. U|3168372484|3043606542|3043606542|75|Terminating|0|20160802000529|-05:00|20160802050529|Peak|13044126356|1...
5949829 Aug 2016 @ 08:42 PDTIvyuanToolsReplyError Table MloadHi, 1. Can you let us know the error code recorded in the error table? If it is in the Application Error Table, the column name is DBCErrorCode; If it is in the Acquisition Error Table, the colu...
5949729 Aug 2016 @ 08:36 PDTCvinodhToolsTopicTDCH error limit for Export from HDFS with method batch.insertI am trying to load data from HDFS/Hive into Teradata using the method batch.insert.  Is there a way to set errorlimit property for the load so that the job will not fail when X-1 or lesser r...
5949629 Aug 2016 @ 04:27 PDTfgrimmerTeradata StudioReplyViews the rows being transferred overFarah,  The Transfer Progress View shows the start time, elapsed time as the transfer occurs, along with the progress bar. The Transfer History View will have Job Output that will show the err...
5949529 Aug 2016 @ 03:47 PDTIvyuanToolsReplyMULTILOAD BUFFER ERROR!!! urgentHi, 1. Can you let us know the MultiLoad version and the Teradata Data Connector version? The Data Connector version could be obtained by issuing a ".version;" command using MultiLoad. ...
5949429 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...
5949329 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...
5949229 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...
5949129 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
5949029 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?  
5948929 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'...
5948829 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...
5948729 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...
5948629 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.
5948529 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...
5948429 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...
5948329 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...
5948229 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...
5948129 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...
5948029 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.
5947929 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 ...
5947829 Aug 2016 @ 06:09 PDTsachin.sebastianDatabaseReplyextract time from timestamp(6)SELECT CAST(SUBSTR(CAST(<COL> AS VARCHAR(20)),12,19) AS TIME(0))
5947729 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...

Pages