# Astera Options

Astera Options are used to modify the default parameters when running queries, dataflows or workflows on the client. To open Astera Options, go to *Tools > Options*.

## **Query Options**

In *Query Options*, you can specify:

* The *General* options
* The *Query Batch Terminators* options

### **General**

This table helps you understand the general options available in the Query tab:

| **Option**                   | **Helps to**                                                                                        | **Action**                                                                     |
| ---------------------------- | --------------------------------------------------------------------------------------------------- | ------------------------------------------------------------------------------ |
| Max result rows              | Specify the number of rows to be displayed in the query result. The default number of rows is 5000. | Enter the maximum number of rows you want to be displayed in the query result. |
| Connection timeout (Seconds) | Specify the number of seconds before the database connection terminates.                            | Enter the number of seconds after which the database connection terminates.    |

### **Query Batch Terminators**

Astera Data Integrator supports a number of databases including SQL Server, MySQL, Oracle, DB2, Sybase, Microsoft Access, as well as the Salesforce service which Astera treats as a database connection. You can specify the *Query Batch Terminators* for the databases in use. Using Astera Data Integrator, users will be able to run the scripts, which they have developed using ‘GO’ or ‘;’ without changing the anything in the script. The query script will be passed to the database in tokens, with the batch terminator behaving as the delimiter and the query statement as the token.

Steps:

1\. In the *SQL Server* box, enter the *Query Batch Terminator*.The default value is *GO***.**

2\. In the *Oracle* box, enter the *Query Batch Terminator***.** The default value is **;.**

3\. In the *DB2* box, enter the *Query Batch Terminator***.** The default value is **;.**

4\. In the *Sybase* box, enter the *Query Batch Terminator***.** The default value is **;.**

5\. In the *Access* box, enter the *Query Batch Terminator***.** The default value is **;.**

You have successfully specified the Query Options.

## **General Options**

### **Records to be scanned**

You can specify the number of records to be scanned to determine Data Types and Sizes during layout building.

1\. Click *Entire File* to scan all records.

OR

1\. Click *Records* to specify the number of records to be scanned. The default value is 50000 records.

2\. In the *Records* box, enter the number of records to be scanned to change the default value.

### **Staging Directory**

The Staging Directory stores profiles or other temporary files for each job that runs on the client. To change the default location, enter the new path in the Directory input.

### **Help Url**

Help Url stores the default location of the Astera documentation on the web. For custom installations, you may want to change the url as necessary.

{% hint style="info" %}
**Note:** To set server options, such as outgoing email server or staging directories, use *Server Administration*.
{% endhint %}