Archives of the TeradataForum

Message Posted: Tue, 24 Jun 2003 @ 14:22:40 GMT

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

The RUN command in SQL Assistant (aka Queryman) is single level only.

SQLA does not look at the data that it loads from the file. (other than to break it up at the semicolons, if any) It simply sends each statement to the DBS, one at a time.

If one of those statements is a RUN command the DBS will not know what to do with it.

The application has no concept of a stack - or file level - to allow it to handle nested RUN commands. In fact you can only issue a single RUN command in a query ... with no other SQL.

It is simply an alternative to dragging the file into the query window. (It is also a way to reduce what gets written to the History file for big queries since onlty the RUN command is saved to History rather than the SQL itself.)

Mike Dempsey
Teradata Client Tools

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