|59501||30 Aug 2016 @ 02:19 PDT||hv186006||Database||Topic||Formatting in Teradata||Hi 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.
|59500||30 Aug 2016 @ 01:58 PDT||pbvillaflores||Tools||Reply||FastExport Remove Binary/Indicator Values in Outmod ||Is there an example of OUTMOD somewhere that I can reference?
|59499||29 Aug 2016 @ 11:29 PDT||Thiru07||Tools||Reply||Error Table Mload||Hi Ivyuan,
Cingular_BID.txt data file contains pipe delimited records as below.
|59498||29 Aug 2016 @ 08:42 PDT||Ivyuan||Tools||Reply||Error Table Mload||Hi,
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... |
|59497||29 Aug 2016 @ 08:36 PDT||Cvinodh||Tools||Topic||TDCH error limit for Export from HDFS with method batch.insert||I 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... |
|59496||29 Aug 2016 @ 04:27 PDT||fgrimmer||Teradata Studio||Reply||Views the rows being transferred over||Farah, 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... |
|59495||29 Aug 2016 @ 03:47 PDT||Ivyuan||Tools||Reply||MULTILOAD BUFFER ERROR!!! urgent||Hi,
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.
|59494||29 Aug 2016 @ 03:20 PDT||harshainocu||Tools||Reply||TPT 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
|59493||29 Aug 2016 @ 01:39 PDT||fomer||Teradata Studio||Topic||Views the rows being transferred over||Once 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... |
|59492||29 Aug 2016 @ 01:21 PDT||tomnolan||Database||Reply||moving first 4 characters to last 4 characters||The 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... |
|59491||29 Aug 2016 @ 01:06 PDT||efgeorge18||Database||Reply||moving first 4 characters to last 4 characters||I resolved this one:
TO_CHAR(cast(cast(cast(table.column as CHAR(8) ) as DATE FORMAT 'YYYYMMDD') as DATE FORMAT'MMDDYYYY'),'MMDDYYYY') AS converted
|59490||29 Aug 2016 @ 12:16 PDT||wgfagundes||Database||Reply||ODBC 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?
|59489||29 Aug 2016 @ 11:40 PDT||flash7gordon||Connectivity||Reply||Can 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'... |
|59488||29 Aug 2016 @ 10:46 PDT||Fred||Database||Reply||Can 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... |
|59487||29 Aug 2016 @ 10:44 PDT||NetFx||Connectivity||Reply||Can 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... |
|59486||29 Aug 2016 @ 10:37 PDT||flash7gordon||Connectivity||Reply||Can 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.
|59485||29 Aug 2016 @ 10:34 PDT||Fred||Database||Reply||Output is different in DBC.diskspace and for Dbc.diskspacev||Where 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... |
|59484||29 Aug 2016 @ 10:05 PDT||flash7gordon||Connectivity||Reply||Can 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... |
|59483||29 Aug 2016 @ 10:00 PDT||fgrimmer||Teradata Studio||Reply||Tools > Create > Database, User etc. dialogs missing in Teradata Studio Express 15||Which 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... |
|59482||29 Aug 2016 @ 07:59 PDT||efgeorge18||Database||Topic||moving first 4 characters to last 4 characters||Hello,
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... |
|59481||29 Aug 2016 @ 07:18 PDT||Thiru07||Tools||Topic||Error Table Mload||On running the following mload script :
.BEGIN IMPORT MLOAD TABLES prepd_usge
WORKTABLES EDB.WT_prepd_usge... |
|59480||29 Aug 2016 @ 07:05 PDT||SQLfan123||Database||Reply||Filtering results of concatenation||Thanks, 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.
|59479||29 Aug 2016 @ 06:24 PDT||vc||Database||Topic||Output is different in DBC.diskspace and for Dbc.diskspacev||Hello,
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 ... |
|59478||29 Aug 2016 @ 06:09 PDT||sachin.sebastian||Database||Reply||extract time from timestamp(6)||SELECT CAST(SUBSTR(CAST(<COL> AS VARCHAR(20)),12,19) AS TIME(0))
|59477||29 Aug 2016 @ 04:15 PDT||sasnai||Database||Topic||How to transpose row values ||Hi,
I have a data like
1 AB 1234 / CD 5678 / EF 9101.
I want output like this
1 AB 1234
1 CD 5678
1 EF 9101
I tried using TD_UNPIVOT functi... |