Is "numeric" data type available in TD ?

Database

Is "numeric" data type available in TD ?

Hi,

I'm currently working on a project where Stored Procedures from Sybase are being migrated to TD. 

How do you convert  "numeric(10)" data type in Sybase to equivalent TD data type ?

se10              numeric(10)   null,
qId int null,
rId int null,
sId int null,
rfDate date null

How do i convert numeric(10) to equivalent TD data type ?


And i noticed the use of "go" here and there in Sybase stored procs. I dont know why "go" is used in them ? Can someone help me with these pls. ?

if exists (select 1 from sysprocedure
where proc_name='get_se_data' and creator=suser_id('ABCD')) then
drop procedure ABCD.get_se_data;
end if;
go


Like the one above. What is the use of "go" in it ?

Thank You!

Paddy

2 REPLIES
Enthusiast

Re: Is "numeric" data type available in TD ?

In Sybase I believe NUMERIC datatype is same as DECIMAL. Teradata has DECIMAL datatype, you can specify the precision and scale for DECIMAL as per requirement.

I think NUMERIC(10) should be similar to DECIMAL(10,0) in Teradata.

Enthusiast

Re: Is "numeric" data type available in TD ?

Regarding your second question... GO is generally used as as batch separator in a script which ensures that the all the SQL before the GO statement will finish before proceeding further. Semicolon (;) has the same functionality in most of the dbs...