Using Aginity Catalog to Make Exporting to a File (via Aginity Script) Even Easier

Background

Aginity Script is a powerful utility that over time will be used to expose a lot of powerful features in Aginity Pro and Team.  Currently, we have deployed the ability to use Aginity Script to export data to files.  

This knowledge base article talks about making the export feature more useful when you use it in conjunction with the Aginity Catalog.

Step by Step Approach

1.  Create two entries in your catalog to hold the code for exporting to files (before SQL query and after SQL query portions) as shown below.

mceclip0.png

2.  Here is an example where I’ve put this syntax in with the typical defaults I want to use. Using a $ parameter also means that it will prompt me to add a file name when I run this:

mceclip1.png

3.  When you have a query you want to export, just type “@{beg....” and it should find the catalog reference you need to insert before the query itself.

mceclip2.png

4.  Do the same with “@{end...}” after the query and you should end up with something like this in a couple keystrokes. When it runs, it will prompt you for a filename and spool out the results!

mceclip3.png

 

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.