Options

To change Active Table Editor Settings

  • Click System MenuFileOptions

Dialog box will appear

Global Variables are used to replace Variable with Value, for example before input form is shown to the user <CustomerId> will be replaced with 1

EG

 Select * from Customers where  CustomerId = <CustomerId>

Is changed to

 Select * from Customers where  CustomerId = 1

Predefined variables:

 <ATEUserName>
 <username> OS user name
 <computername> 
 <datetime> 

Note:

 Works only with input forms SQL.

For more technologies supported by our ETL Software see Advanced ETL Processor Versions and Visual Importer ETL Versions

Confused? Ask question on our ETL Forum

  • ate/options.txt
  • Last modified: 17/09/2018 10:31
  • by admin