title: Multiple select statements give multiple answer sets
body: <p>I have a few SELECT statements that I would like to have in one SQL file. </p>
  
  <pre><code>File.sql
  SELECT * FROM A
  SELECT * FROM B
  SELECT * FROM C
  </code></pre>
  
  <p>I want to run File.sql directly in Teradata and be able to see the results from the different select statements. These results are quite different and should not be in the same answer set. It doesn't matter if the reult is shown in Teradata or stored in some file. What is the easiest way to accomplish this? FYI: My user rights are limited, I can't e.g create stored procedures. </p>
  
  <p>This question was considered similar to "Run multiple queries from 1 SQL file showing result in multiple tables". It is similar but not identical. The difference i mainly how the result set it represnted. In that question the requirement was to store it in one file but in this question I don't care how the result set is displayed. Hence I hope for an easier answer here. </p>