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:

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:

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;

http://forums.teradata.com/forum/tools/teradata-schema-workbench-help#comment-16696

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

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:

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

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

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"));}

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

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".

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

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.

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;

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

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)

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.

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