All Forums

Covers Teradata-developed applications such as TRM, DCM, etc. For articles, blogs and more, see the Applications section of the site.

You must login to post to the forums.
ssis query timeout error using odbc Topic by mbaig_88 16 Dec 2011 odbc, ssis timeout error, ssis odbc query timeout error

hello

i am facing a problem in ssis, i want to get large data from teradata source using odbc but i am getting the following error:

TITLE: Microsoft Visual Studio
------------------------------

There was an error displaying the preview.

------------------------------
ADDITIONAL INFORMATION:

9351 views
0 replies
teradata connection with ssis using odbc & oledb Topic by mbaig_88 16 Dec 2011

hello

i am facing a problem in ssis, i want to get large data from teradata source using odbc but i am getting the following error:

TITLE: Microsoft Visual Studio
------------------------------

There was an error displaying the preview.

------------------------------
ADDITIONAL INFORMATION:

8786 views
0 replies
RESET keyword in Teradata 12 Certification Topic by rupert160 17 Oct 2010 reset td12 certification advance sql

Any ideas why this is going wrong people? The following command in the T12 course notes is causing a syntax error:

SELECT Month_Of_The_Year, Sales,
SUM( Sales ) OVER (
ORDER BY Month_Of_The_Year
RESET WHEN sales IS NOT NULL
ROWS UNBOUNDED PRECEDING ) AS Last_Non_Null_Sales
FROM monthly_sales;

--error 3707: expect something like ")" between "Month_Of_The_Year" and "RESET"

------------------fyi----------------------------------

CREATE VOLATILE TABLE monthly_sales
(
Month_of_the_Year INTEGER NOT NULL
, Sales INTEGER
)
ON COMMIT PRESERVE ROWS;

10662 views
5 replies, 7 years ago
7325 views
0 replies
SQL Assistant 12 Shows some values in Status Bar "x ROWS PROCESSED" - What is this number? Topic by venugopal2705 10 Aug 2011 sql assistant, x rows processed

I am using Teradata 12 SQL Assistant, In status bar most of the time I am getting some numbers which are not relevant to the command which I have executed successfully. Like

I have a table with single column and 2 records. When I drop the table, The status will be like " Completed, 15 Rows Processed"

Proper values come for Insert/Delete/Update on a Table

9246 views
1 reply, 8 years ago
Import date into a query in BTEQ Topic by ravikanth 09 Aug 2011

Hi All,

I'm trying to run a BTEQ script with Date parameter. I want to import the date from a text file and the date is in yyyy-mm-dd format without single quotes.

Here is the script and the error. Can you please let me know where I'm going wrong.

.IMPORT data file= D:/BTEQ/SSW/date.txt
.QUIET ON
.REPEAT *
Using Ext(Date)

Delete from RTWIT_TDW_URT_EXCP.STG_SSW_MEMBR
where DWH_STT_DT = :Ext;

*** Starting Row 0 at Wed Aug 10 16:11:39 2011

*** Growing Buffer to 12338
*** Error: Import data size does not agree with byte length.
The cause may be:

7738 views
1 reply, 8 years ago
Disappearing bookmarks Topic by GlennB 16 Aug 2011 bookmark

Can anyone tell me why my bookmarks are disappearing? and how to stop it from happening?

Scenario: Multiple query tabs open in query window. Set a bookmark on a specific line (blue flag in window left hand border). Change to a different tab, change back to original tab and the bookmark has vanished.

I am using Teradata SQL Assistant Version 12.0.0.13

6436 views
0 replies
Opening with BA continuum Solutions ( non bank subsidiary of Bank Of America) - chennai/Gurgaon Topic by contactsonnu 20 Jun 2011

Hello

Greetings for the day!!

Opening with BA continuum Solutions ( non bank subsidiary of Bank Of
America) - chennai/Gurgaon
Exp:4yrs to 8yrs
Location: Chennai/Gurgaon
Skills:Teradata Development with teradata utilities.
Bteq is preferred.

Interested do mail resume to contact.so...@gmail.com

Regards
Sonnu

8425 views
0 replies
Help needed! Topic by JMBERTONCELLI 18 Apr 2011 .net databinding

Hello,

I try to bind a check list box in a .Net application to a TD datasource. In order to do this I have a {DataSet ds = new DataSet("D");} and { TdDataAdapter adapter = new TdDataAdapter("SELECT NAICS_CODE FROM \"DBIPAD02\".\"GIS_NAICS_READY\"", new TdConnection(cnsb.ToString()));}.

After executing the {adapter.Fill(ds);} which work well I do { MyCheckListBox.DataBindings.Add(new Binding("Text", ds, "DBIPAD02.GIS_NAICS_READY.NAICS_CODE"));}

7420 views
1 reply, 8 years ago
Teradata Query Scheduler Topic by thirtyfiveblack 03 May 2011 teradata query scheduler, tqsclient, tqs

Hi all,
Has anyone been able to extend the length of a query in TQS?

Mine seems to be truncating around the 58,000 character limit.

Any help will be appreciated

6831 views
1 reply, 8 years ago
Issue on install teradata bynet driver Topic by ksshon 07 Apr 2011 bynet

I get an error message as below while install teradata bynet driver on windows 7.
" Error 1335. The cabinet file 'Data1.cab' required for this installation is corrupt and cannot be used. This could indicate a network error, an error reading from the CD-ROM, or a problem with this package".

8115 views
0 replies
Issue with creating a vector using CM >> 13:Type Mismatch Topic by howiev 31 Jan 2011 issue with commmanager creating vectors

Hello

Apologies if I made a mistake posting the topic.

We use CommManager in our bank. We are getting the following error when we:
- try creating a vector from scratch
- try making changes to existing vectors

7674 views
0 replies
CRM 5.2.1.6 End of Export String - Record Count? Topic by MarkyB197052 30 Dec 2010 crm 5, end of export string, record count

We use CRM 5.2.1.6 and for a specific abnormal campaign, we wish to replace the standard EOE (End Of Export String) with a trailer record. The minimum we require is a record count although the full trailer, if possible is:
Record Type,Physical Count,Logical Count, Filler e.g.

7495 views
0 replies
SQLEXCEPTION behaves differently in different databases Topic by mzs 28 Sep 2010 sqlexception

Hello,
I wrote a pretty simple code to test exception handling, and it works as expected, but when I tried to run the same code in a different (same-level) database, it does not work.
Here is the procedure, which takes divisor as parameter, and generates record in a table if divisor = 0 :
REPLACE PROCEDURE SP_TEST (IN divisor INT, OUT answer INT, OUT retString CHAR(1), OUT errNum INT)
BEGIN
DECLARE procName VARCHAR(100);
DECLARE processDate DATE;
DECLARE errNumber INT;
DECLARE errCode CHAR(5);

DECLARE EXIT HANDLER FOR SQLEXCEPTION
BEGIN
SET answer = 0;

12217 views
1 reply, 8 years ago
Questioning the results of a Window Remaining Function Topic by rupert160 17 Oct 2010 window remaining function

Using the T12 express demo DB "retail" I was looking at how the "Window Remaining Function" works. I was using the following query:
SELECT
deptNo AS Dept
,name AS Emp
,salary AS Sal
,AVE(Sal)OVER(
ORDER BY Sal DESC
PARTITION BY Dept
ROWS BETWEEN CURRENT ROW
AND UNBOUNDED FOLLOWING
)
WHERE Dept IN (1360,4080,8496)
FROM retail.employee;

and got the following dataset:
Dept Emp Sal Remaining Avg(Sal)
1360 Jim Sink 80548.54 80548.54
1360 Meg O'Connel 78069.83 79309.19
1360 Nathan Mautz 60611.6 73076.66

9242 views
4 replies, 8 years ago
Dynamic Cursors Topic by prashanth.bose 15 Mar 2010 dynamic sql, dynamic cursors, procedures

i have couple of questions:

how to pass queries in the procedure ( i would be passing different queries at different times)
execute them as cursors
how to find out the no of coulmns in the cursor and fetch them into strings or array( as no of columns in the queries would be changing each for each call)

9252 views
1 reply, 9 years ago
Return of the Friday Night project - What do you want to see? Topic by Mikec 22 Sep 2009 teradata sample application

After some time off (to do my real job) I'm going to do some more articles in the Friday Night project series [http://developer.teradata.com/applications/articles/the-friday-night-project].

I'm probably going to concentrate on iBatis to start with (what is it, how can it help me bridge the gap from Object to Relational, etc).

The Teradata Sample Application (upon which FNP is based) has examples of Web and Viewpoint Portlet Presentation veneers incorporating elements such as Hibernate O/R Mapping, ACEGI security and of course how to make your application work well on Teradata.

8073 views
0 replies
Welcome to the Teradata Developer Exchange discussion forums! Topic by neilotoole 14 Jul 2009 devx

Please see this topic in the General forum for an introduction to the new discussion forums, and a chance to give feedback.

6354 views
0 replies

Pages