58241 | 06 Jul 2016 @ 10:53 PDT | dhiraj_dt121 | Tools | Topic | teradata TPT , all rows in error table | Hi Folks, I have created TPT script, however when I run it all the rows are errored out. Below is my code and the table structure.
DEFINE JOB MOVE_DATA_WITHOUT_LANDING_TO_DISK
... |
58240 | 06 Jul 2016 @ 09:00 PDT | dhiraj_dt121 | Tools | Reply | TPT export to delimited files Error | Thanks this works. Now i am faced with another issue when using the unicode character sets for some Columns. All the records are in error tables.
EXPORT_OPERATOR: entering End Export Phase
... |
58239 | 06 Jul 2016 @ 07:41 PDT | bhanusri83 | Training | Reply | Teradata 14 basics certification information | All,
I am planning to take Terdata basic ceritification in a couple of weeks from now and am in need of the below information.
1. When trying to schedule my exam in Prometric site, it's askin... |
58238 | 06 Jul 2016 @ 03:59 PDT | Fred | Database | Reply | Hashing Algorithm | Could be either AMP or PE. In particular, FastLoad sends data blocks to AMPs round-robin and the AMPs hash the rows and send to the correct target AMP. But for a single-row fetch or insert, the PE ... |
58237 | 06 Jul 2016 @ 03:30 PDT | Nikhil_Teradata | Database | Reply | Defined type name error | I think I got the error resolved.
It went away after I restarted the TD SQLA. I still don't know why it happened though.
|
58236 | 06 Jul 2016 @ 03:25 PDT | timlisa20 | Connectivity | Reply | ODBC error (64bit) | Thanks Fred for the recommendation. I ran the uninstall script...rebooted....intalled in the correct order. Now when I look in the "ODBC Data Source Administrator" for "Teradata"... |
58235 | 06 Jul 2016 @ 02:29 PDT | nealvenna | Database | Reply | regexp_similar '^.$' issues | Just one more update. We have TD14 and TD 15 on different servers and I did following query
select case when regexp_similar('¥','^.$', 'i')=1
&... |
58234 | 06 Jul 2016 @ 02:27 PDT | Vinay151 | Database | Reply | Decimal Value | Thanks Carlos.... Also, is this the default format of Decimal data type to store the value
Thanks,
Vinay |
58233 | 06 Jul 2016 @ 02:01 PDT | ssinha | Analytics | Topic | Replacing missing value with next vaules | I have a data like
Attmpt_dt
1/1/2016
?
?
?
?
1/10/2016
?
?
?
1/31/2016
I want it to covert
Attmpt_dt
1/1/2016
1/10/2016
1/10/2016
1/10/2016
... |
58232 | 06 Jul 2016 @ 12:53 PDT | feinholz | Tools | Reply | TPT output from ODBC includes Indicator Bytes? | If you are reading data from Oracle with the ODBC operator, there are no indicator bytes coming from Oracle.
They are added to the data when the rows are moved from the ODBC operator to the loadin... |
58231 | 06 Jul 2016 @ 12:48 PDT | feinholz | Tools | Reply | TPT export to delimited files Error | By default, TPT is supporting a DECIMAL precision of 18 (8 bytes).
Since your source column is defined as DECIMAL with a precision of 22 (needing 16 bytes), you need to add the MaxDecimalDigits=31... |
58230 | 06 Jul 2016 @ 12:45 PDT | feinholz | Tools | Reply | TPT EXPORT OPERATOR job structure | Our documentation describes the Export operator, the mandatory attributes and the optional ones.
Our User Guide has examples of Export operator job scripts as well.
We also ship sample scripts wi... |
58229 | 06 Jul 2016 @ 12:13 PDT | ericm | Database | Reply | Restoring a Table | I figured it out. Simple syntax error. I was missing a ; at the end of the line.
|
58228 | 06 Jul 2016 @ 11:52 PDT | Nikhil_Teradata | Database | Topic | Defined type name error | Hi,
I get this type of error for below statement:
SELECT COUNT (DISTINCT Userid)
FROM PDB.View
WHERE
src_id IN (123)
AND Src_Cd = 'AB'
AND PGM = 'LN';
... |
58227 | 06 Jul 2016 @ 11:11 PDT | ericm | Database | Topic | Restoring a Table | I am attempting to restore a single table to our server. The table already exists, but I have truncated the data in the table.
First I start ARCMAIN:
arcmain FILEDEF=(ARCHIVE, tdbackup)
... |
58226 | 06 Jul 2016 @ 10:04 PDT | SNguyenWF | Teradata Studio | Reply | Studio Express severe keyboard lag | I was looking in the teradata.log file found in the workspace directory. An entry I'm curious about and which happens frequently is:
"2016-06-28 10:51:54,089 Teradata Datatools [mai... |
58225 | 06 Jul 2016 @ 09:30 PDT | abhishank18 | Database | Topic | Hashing Algorithm | I am just wandering, in which part of logical architecture of teradata does hashing happens. I read somewhere when data loading happens first data is transferred in AMPs and then hashing happens an... |
58224 | 06 Jul 2016 @ 09:27 PDT | sharonn | Connectivity | Topic | Ping Failed - can not connect to Teradata on Linux - aws | Hi,
I’m using Teradata Express on linux machine - aws.
When starting the machine, Teradata is not starting properly.
I have to stop it and start it several times until Teradata works fine.... |
58223 | 06 Jul 2016 @ 09:14 PDT | KG1116 | Database | Topic | Stored procedure | Hello,
I have been struggling with this concept and any help would be highly appreciated. Do we need a stored procedure here? here is a small mock up example, however this will be implemented o... |
58222 | 06 Jul 2016 @ 09:12 PDT | CarlosAL | Database | Reply | Decimal Value | Hi.
The datatype is NOT storing the value as ".00" (numbers are numbers). The FORMAT is what displays the data in one or other way.
You can define a FORMAT at column level (when cr... |
58221 | 06 Jul 2016 @ 09:08 PDT | KG1116 | Database | Topic | Stored procedure | Hello,
I have been struggling with this concept and any help would be highly appreciated. Do we need a stored procedure here?
Table 1
... |
58220 | 06 Jul 2016 @ 08:57 PDT | ryuwaraimasa | Database | Topic | Migration Compatibility | I'm new here so I will keep it short, just a quick question on compatibility. My company currently uses Tibero but we are looking into using a much larger DBMS as our company grows. My question... |
58219 | 06 Jul 2016 @ 08:41 PDT | dnoeth | Database | Reply | A problem with 'where' | Well, this is exactly what you wrote: No data from the year 2004 and no data from any august :-)
You want either a.num_month<>8 OR a.num_year<>2004 or NOT(a.num_month = 8 AND a.num_yea... |
58218 | 06 Jul 2016 @ 08:36 PDT | Rhino_373 | Database | Topic | Possible loop usage in SQL? | I have to tables that have two columns. Both have a date and an amount of money. The first table generally has every day of the month. The second table often skips days such as weekends and possibl... |
58217 | 06 Jul 2016 @ 08:06 PDT | monchomark | Tools | Topic | TPT EXPORT OPERATOR job structure |
Hi guys, can you help me with a basic structure for a TPT EXPORT operator job?
I have good examples on LOAD operator but I'm not sure what to change ar what's needed.
T... |