Archives of the TeradataForum

Message Posted: Thu, 17 Jul 2003 @ 18:26:02 GMT

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

-> sel count(*) from pdata.item_master

is an SQL statement that bteq will sent to the DBS as soon as it sees a semicolon.

-> .if activitycount = 0 then .quit 0

is a command to bteq (because it starts with a period)

So... Bteq stuffs the SQL statement into a request buffer. It can't send it because it has not seen a semicolon yet. Then it deals with the bteq command. Since the SQL statement has not yet been sent to the DBS, activity count is whatever it was set to prior to what you've shown us.

Make sense?

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