Archives of the TeradataForum

Message Posted: Wed, 16 Jul 2003 @ 07:24:45 GMT

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

<-- Anonymously Posted: Wednesday, July 16, 2003 12:37 -->

I had this experience that i used select sql statement to check rowcount. The sql statement as below.But the parameter 'activitycount' always equals '1'. why? Does anyone know another way to solve this problem?

Thanks .

'sel count(*) from pdata.item_master
.if activitycount = 0 then .quit 0; '

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