Dear Team,
I am loading tables in teradata using Tpump loader (through Informatica).
 

Created error table with  "Activity count zero for TPump UPDATE or DELETE."

Can someone tell me if there is any way to fix issue 

Info from TPUMP manual

1: Error 2818: Activity count zero for TPump UPDATE or DELETE.

Hi I'm biginner to teradata.

 
I want to ask u that 
while we creating a new database in teradata why we use "from" clauses in that query.

The query is
 

CREATE DATABASE personnel

FROM administration

AS PERMANENT = 5000000 BYTES,

FALLBACK,

BEFORE JOURNAL,

DUAL AFTER JOURNAL,

Hi All,

I have a PPI table defined as like below,

I have a query, that runs just fine in Oracle and SAS, but, it doesn't want to execute in Teradata. I understand that there's a 'Scalar Subquery' ability in TD13, but in the near term we're still on TD12.

As I'm in the process of porting all of our existing analytic work to the new Teradata environment, getting a little help with this (and other similar queries) would be greatly appreciated.


Select component_location_id, component_type_code,


Hi,I am trying to replicate the following ORACLE syntax to Teradata but facing issues in conversion.can anyone pls help me out?(substr(to_char(new_time(to_date(inventory.gmt_start_time,'mm/dd/yyyy hh:mi:ss AM'), 'GMT', 'EDT'),'mm/dd/yyyy hh:mi:ss AM'), 1, 14) || Casewhen to_number(substr(to_char(new_time(to_date(inventory.gmt_start_time,'mm/dd/yyyy hh:mi:ss AM'), 'GMT', 'EDT'),'mm/dd/yyyy hh:mi:ss AM'), 15, 2)) >= 30 then'30:00'else'00:00'end || substr(to_char(new_time(to_date(inventory.gmt_start_time,'mm/dd/yyyy hh:mi:ss AM'), 'GMT', 'EDT'),'mm/dd/yyyy hh:mi:ss AM'), 20, 3)) half_hr_timeThanks in Advance.

Hi all,
I am building a SQL in which I have a date prompt.
My back end is Oracle and the column I am using has datatype of DATE. Below is the condition I am using.
Where BGN_DATE <= #sq(prompt('ToDate', 'date'))#
It is working but I have to add 30 days to 'ToDate'. Is it possible? How can I do this? Is there any function I can use?

HI All,
Does any one where can i find training DBA materials or classes for the same.  
 

Hello,
i'm a newbie with Teradata, i have just used the DB to run some inquiry on tables.
I have to build an ETL from zero using this DB, i have experience with Oracle PL/SQL but I'm not aware how it works with Teradata.
My question is: do I have to use an orchestration tool (e.g. IBM infosphere, Talend,..., whatever) to create an ETL or can I use just Teradata? 

Is there a way to find last access date and time of partition of a table in Teradata?

Hello All,
I have a report that is generating SUM for various code values. The data on which the aggregate is being run has a mix of upper and lower case data for the same value (e.g. 'AB', 'ab','Ab','aB'). The sum that is returned is correct, only thing is -  the query had been returning all uppercase values and now it is returning all lowercase values.

Hello,
I'd like to set my sql assistant connection from ODBC to UTF8 session.  How can I do that?  Thank you for your kind feedback.
Regards,
 

Hi, I have to get the value for the latest date..Say I have ID and Event Date fields. I need to get the ID of the latest "Event Date". I know latest date could be achieved by using MAX, I would like to know how we can do the same without aggregate function?

Have any Informatica users out there ever encountered the following failure:
 
Severity: ERROR
Timestamp: 4/26/2013 10:51:03 AM
Node: node01_DVWPAP0031
Thread: READER_1_1_1
Process ID: 184264
Message Code: RR_4036
Message: Error connecting to database [
[Teradata][ODBC Teradata Driver] Memory management error
 

For the query below , imanagerid = 100 and iempid are being applied after join condition.
select  coalesce(t1.managerid,10) as imanagerid
       ,coalesce(t1.empid,1) as iempid
from    test.t1
        full outer join
        test.t2
   on   t1.managerid = t2.managerid
  and   t1.empid     = t2.empid
  where imanagerid = 100

Hi, Can anyone let me know some of differences between Global Temp Table & Volatile table and also is there any specific purpose where each can be used???Thank You,

Hi,
I am facing a problem in Teradata
I want to create view in DAtabase1 and have my tables in Database2
Create view Database1.view1
as
sel a.col1 , a.col2
from database2.table 1 a, database2.table 2 b
where a.col1=b.col1
I get an error saying database2.a.col1 not found.
 
Please help
 
 
 
 
 

Hi All,
I am tying to create the following (and it did work) but was wondering if I can add the other datatypes I have commented out or make my varchar larger than 62000
REMRK_CLOB  VARCHAR(62000) CHARACTER SET LATIN NOT CASESPECIFIC TITLE 'REMARKS',
 
CREATE SET TABLE DTST_ADL_STG_METS.METS_ORDR_B ,NO FALLBACK ,
     NO BEFORE JOURNAL,

hi, I am a layman in TD, and come across a Sum function issue.
sel
created_date (format 'YYYY/MM') (char(7)) as month
,count(*) as overall
,sum(table1. amount) as overall_amount
,sum(case when table1.amount > 300 then 1 else 0 end) as over_300_cnt
 
that's a part of my SQL,

Hi,
I am trying to export data from a table in which one column  has a data type of Decimal(38,0). 
 
Query: select sa from aa;
Result:
When I run the select statement in SQL assistant....the output is fine....like below
 

sa

1 1,234,567,890,123,456,789,012,345,678

HI at all
I´m new on Teradata and I'm studying the TPUMP utility from official documentation "Teradata Parallel Data Pump".
At some point in the chapter 1 section "What it Does" the document tells:
"The Teradata TPump task provides the acquisition of data from client files for application to

Dear Folks,
          Need to identify names with atleast one special character in TD.
For ex:   'Robert John'
              'Rama / Ram'
             '.Akbar_raj'
            'New_york_2'
           '..###'
 
Out of these need to select below names, i.e. with atleast one spec character.
              'Rama / Ram'

Does a query sampling a certain number of rows from a table, such as the following, really scan all rows? The information from Explain below seems to indicate that all rows are scanned.

Hello,

I am connected in SQL Assistant, and run a SP who believes, this SP uses a volatile table. I need to know how to remove the TV from the SP. Without having to disconnect from the session.

If not possible, I could tell you that answer docume tion meeting in order to have a physical document with which to sustain him that answer to my boss

Hi,I am having a stored procedure containing cursor declaration.I have fetched employee ID's in the cursor ..I need to loop through the cursor variable..If some one knows, please let me know.......Thanks,

The exception 7632 is not caught by the below exception handler
 
declare exit handler for SQLEXCEPTION
Begin
set sqlcd= SQLCODE;
sel errortext into SQLmsg from dbc.errormsgs where errorcode= sqlcd;
insert into error_table(proc_name,code,msg,date_time) values('proc',:sqlcd,:SQLmsg,current_timestamp)
end