Advertisement

10.08.2008 at 11:57AM PDT, ID: 23798628 | Points: 500
[x]
Attachment Details

Overflow error in Teradata Macro

Asked by PeterFrb in Teradata, Databases Miscellaneous, Miscellaneous Programming

Tags: , , ,

I have a Teradata macro that gives me an Overflow error when I pass an integer value to it.  The Account numbers are generally 10 digits long, and I get no error when I assign the Account Number field to a straight number.  When I call it this way, I get an error:
    Exec M_Peter_OneAcctDetail (1234567890)
But this is a perfectly fine construction:
      Select
            MyTable.*
      FROM
            MyTable
      WHERE
            (ACCT_NUM = 1234567890);
I am mystified by this error.  Thanks in advance for any insight you can provide.  ~Peter FerberStart Free Trial 
1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:

Replace MACRO
	M_Peter_OneAcctDetail 
	(
		Use_Acct_Num Integer
	)
As
(
	Select 
		MyTable.*
	FROM
		MyTable
	WHERE
		(ACCT_NUM = :Use_Acct_Num);
)
 
Keywords: Overflow error in Teradata Macro
Title
1 Overflow on Binary Access of Very L…
2 Access overflow
3 Memory Overflow
4 SQL 2000 Arithmetic Overflow
5 Excel Macro to increase the capability
6 arithmetic overflow
 
Loading Advertisement...
 
[+][-]10.09.2008 at 10:44PM PDT, ID: 22684531

Experts Exchange has a courteous staff of administrators who help members get the most out of the website by means of administrative comments like this one.

Start your 7-day free trial to view this Administrative Comment or ask the Experts your question.

 
[+][-]10.11.2008 at 09:20PM PDT, ID: 22696298

Experts Exchange has a courteous staff of administrators who help members get the most out of the website by means of administrative comments like this one.

Start your 7-day free trial to view this Administrative Comment or ask the Experts your question.

 
[+][-]10.13.2008 at 06:42PM PDT, ID: 22708045

Experts Exchange has a courteous staff of administrators who help members get the most out of the website by means of administrative comments like this one.

Start your 7-day free trial to view this Administrative Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628