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:
|
9379 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:
|
8798 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;
|
10678 views
|
5 replies,
9 years ago
|
|
7335 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
|
9263 views
|
1 reply,
9 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:
|
7750 views
|
1 reply,
9 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
|
6446 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
|
8437 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"));}
|
7438 views
|
1 reply,
9 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
|
6847 views
|
1 reply,
9 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".
|
8128 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
|
7686 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.
|
7506 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;
|
12239 views
|
1 reply,
10 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
|
9256 views
|
4 replies,
10 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)
|
9266 views
|
1 reply,
10 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.
|
8092 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.
|
6370 views
|
0 replies
|