you can tweak a select query with row_number
or you can create
CREATE CREATE MULTISET VOLATILE TABLE tmp (
Field1 INTEGER GENERATED BY DEFAULT AS IDENTITY
(START WITH 1
INCREMENT BY 1
From this link
http://www.info.teradata.com/HTMLPubs/DB_TTU_14_00/index.html#page/General_Reference/B035_1096_111A/... shows that it cannot be done.
Probably,you can find out a way to generate a sequence from any of the queries having unique rows or you can populate or use/ from another/ independent permanent table as temp and drop it later.
You can use the last 3 posts at the following link: