Archives of the TeradataForum

Message Posted: Tue, 07 Jun 2005 @ 19:24:37 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Note that concatenating would not be feasible when you have a mix of BYTE & NONBYTE columns in your table. You could make use of the ACTIVITYCOUNT variable in BTEQ...

     .logon system/user,passwrd
     sel distinct col1, col2, col3...
     from table;
     .quit activityco

The above script would exit with the number of rows that the select returned.

PS: "activityco" is the correct usage.

Regards,

Sanjaya

	<Prev	Next>		<<First	<Prev	Next>	Last>>