Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>   <<First <Prev

Subj:   Re: SQL script
From:   Dempsey, Mike

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
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016