Archives of the TeradataForum

Message Posted: Wed, 20 Dec 2006 @ 13:38:00 GMT

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

Hi Kumar,

According to my knowledge ,SQL Assistant doesn't display output for query containing WITH clause because SQL ASST. is an ODBC based application which always display ouptut in the relational form, Whereas the Output Generated by query including WITH clause is non-relational output.

You better go with BTEQ which is a CLI based Application and can display output for query including WITH clause.

Regards,

Rahulkumar

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