Write all exported answer sets to a single file

Teradata Studio
Enthusiast

Write all exported answer sets to a single file

Hi

Is there any way in Studio to use the similar option in SQLA of  "Write all exported answer sets to a single file" ?

For example I generate a set of SHOW statements and want to export all their output to a single file, so that I can then modify the whole set and then execute again.

Cheers

Steven


Accepted Solutions
Teradata Employee

Re: Write all exported answer sets to a single file

Steven, We have a JIRA open for this. A possible workaround is to have the set of SHOW commands and run Execute All in the Teradata SQL Editor. This will create a Results Group in the Result Set Viewer. You can then do an Export All action that will place the results in a single Excel or CSV file.

 

Also note the Generate DDL option for a Database that allows you to generate the DDL (which runs the SHOW command) for its child objects, such as tables, views, etc. and creates a scipt.sql file with the results. 

1 ACCEPTED SOLUTION
1 REPLY
Teradata Employee

Re: Write all exported answer sets to a single file

Steven, We have a JIRA open for this. A possible workaround is to have the set of SHOW commands and run Execute All in the Teradata SQL Editor. This will create a Results Group in the Result Set Viewer. You can then do an Export All action that will place the results in a single Excel or CSV file.

 

Also note the Generate DDL option for a Database that allows you to generate the DDL (which runs the SHOW command) for its child objects, such as tables, views, etc. and creates a scipt.sql file with the results.