0 - 2 of 2 tags for rowcount
GET DIAGNOSTICS v_Variable_Name = ROW_COUNT giving wrong output

Hi,
ROW_COUNT is returning wrong number.
i have a table having around 100K rows. In a procedure i'm updating all the rows and returning number of rows affected.
I'm using following query to get number of affected rows.
 
GET DIAGNOSTICS v_Variable_Name = ROW_COUNT;
 

By parthmalhan, 24 Dec 2014 | Tagged: teradata database procedure DIAGNOSTICS row_count rowcount | 3 comments
Copy the record and increment in its one column

Hi, 
So i've been searching all around on how i could increment a column in Teradata. I'm new to this so im not really familiar with all the syntax or tactics that i could use. 
I've read about autogenerated identity column, OLAP and recursive in teradata but i think it does not matches my need. 
So here's my problem.

By Lacsum, 29 Aug 2014 | Tagged: teradata increment column Identity column csum olap rank rowcount max number | 3 comments