-
Common Overview
-
Pages
- Algorithms
- Analyze
- Automation Engine Action H
- Automation Engine History
- Automation Engine Parameters
- Automation Instruction Task Definition
- Automation Instruction Task Group
- Automation Instruction Task Group Definition
- Automation Instruction Task H
- Automation Instruction – SQL
- Automation Instructions
- Build View H
- Calendar Exception
- Calendar Exception Work Hours
- Calendar H
- Calendar User
- Candidates
- Client Column Name Variant
- Copy Calendar
- Copy: Automation Instructions
- Data Classification
- Data Services Profiling Results
- Data Services Profiling Results Table Columns
- Data Source Objects
- Data Source Registry H
- Data Source Registry User Credentials H
- Data Sources Tables
- Database Function Setup
- DBMoto Function Setup
- Debug Log H
- Debug Logs
- Definitions
- Duplicates
- Field Values H
- History Of Changes
- Information Type
- Keys
- Language Column Name Variant
- Mapping Set
- Monitor H
- NonDuplicates
- Object Columns H
- Object History H
- Objects Changed By Week (Users)
- Objects H
- Parameters - Metrics
- Parameters - User Management
- Parameters – Collect
- Parameters – Duplicates
- Parameters – Integrate
- Parameters – Profile
- Parameters – Secure
- Parameters – Trace
- Post Action Rule Table Column
- Post Action Rule Table H
- Process Adapter
- Process Adapter Properties
- Report Engine - Filters
- Report Engine - Job User Filters
- Report Engine - Report Source
- Report Engine Core Configuration
- Report Engine Formats
- Report Engine Formatting Styles
- Report Engine Job DataStores
- Report Engine MongoDB Configuration
- Report Engine Notifications
- Report Engine – Header/Footers
- Report Engine – Job Filters
- Report Engine – Job Users
- Report Engine – Jobs H
- Reports
- Results
- SAP RFC
- Schedule – Configure
- Schedules H
- SQL Objects
- SQL Objects (With History)
- System Types Group Table Rule Fields
- System Types Group Table Rules
- System Types Group Tables
- System Types Groups
- System Types H
- System Types Import
- System Types Index Fields
- System Types Join Field
- System Types Joins
- System Types Mappings
- System Types Model Build Views
- System Types Model Group Tables
- System Types Model Groups
- System Types Model Required Fields
- System Types Model Tables
- System Types Models H
- System Types Table Fields H
- System Types Table Indices
- System Types Table Lookup
- System Types Table Statics
- System Types Tables H
- Table (Results) H
- Table Field (Results) H
- Toolkit: Excel H
- Toolkit: File/Folder Operations H
- User Credentials H
- User Management H
- User Role
- Work Day
- Work Hours
-
Procedures
- Activate and Deactivate Data Sources
- Activate and Deactivate Tables
- Activate or Deactivate Tables in a System Type Group
- Activate or Deactivate Tables in a System Type Model Group
- Add a Calendar
- Add a Debug Log to a Custom WebApp
- Add a Lookup Table Manually
- Add a System Type Group
- Add a System Type Model
- Add a System Type Model Group
- Add a System Type Model Table
- Add an Exception to the Calendar
- Add and Remove a Calendar’s Users
- Add Custom Data Classifications and Information Types
- Add DBMoto Functions
- Add Default User Credentials to a Connection
- Add Fields to Tables
- Add Indices
- Add Keys
- Add Mappings
- Add Post Action Table Rules
- Add System Tables and Fields
- Add System Types
- Add Table Join Relationships
- Add User Credentials to an SAP Connection for a Specific User
- Assign a User to a Security Role in Common
- Assign an Expiration Date to a User
- Automation Engine
- Build a Construction Page Manually
- Build Views
- Build Views based on a System Type Model
- Configure Collect
- Configure Collect Parameters
- Configure Columns
- Configure Data Sources to be Ignored
- Configure Debug Logs Settings
- Configure Duplicates Parameters
- Configure Integrate Parameters
- Configure Profile Parameters
- Configure Regulatory Compliance Settings
- Configure Secure
- Configure Secure Parameters
- Configure Trace Parameters
- Copy a Calendar
- Copy a System Type Table
- Copy Files
- Copy Folders
- Copy Instructions
- Copy Task Groups
- Copy Tasks
- Copy Work Hours Across Work Days
- Copy: Automation Instruction Task
- Copy: Automation Instruction Task Group
- Create a Secure Key
- Create a User Account in Common
- Create and Manage User Accounts in Common
- Create Dashboards
- Create Instructions
- Create Object Views
- Create Schedules
- Create Task Groups
- Create Tasks
- Data Sources in Common
- Define Instructions for Tasks
- Define Tasks for Task Group
- Delete a Calendar
- Delete Files
- Delete Folders
- Delete Monitored Records
- Display Data Services Profiling Results
- Download Rate of Change Spreadsheet
- Encrypt CranSoft Data Source Password
- Establish a Connection in a Target System Overview
- Establish a Connection via a Direct Connection to the Application Server
- Establish a Connection via a Message Server
- Export Excel Files
- Export Translations to a Catalog
- Find Duplicates
- Find Duplicates Overview
- Forgotten/Incorrect Encryption Password
- Generate Records in the AE History Table
- Ignore Data Sources
- Import a Data Source
- Import a Model
- Import Excel Files
- Import System Types Using Collect
- Manage System Types with System Type Models
- Manually Add System Type Tables
- Modify Actions
- Modify Text for Password Email Notifications
- Monitor Application Activity
- Monitor Overview
- Move Files
- Process Adapters
- Profile Data Source
- Profile Data Sources
- Register a Data Source in Common
- Register Objects
- Register Plugins to Import and Export Files
- Register Public Plugins
- Reset a User's Password
- Reset Profiling
- Resolve Duplicate Candidates
- Review Duplicate Records
- Review Non Duplicate Records
- Run Post Duplicate Detection Process
- Send a Temporary Password to a New User
- Set up Database Functions
- Set up Post Action Rule Tables
- Set Values for System Types Table Fields
- Set Work Days and Work Hours for a Calendar
- Sync Data Sources in Common and System Administration
- System Types
- Trace Data Sources
- Trace Object Changes Daily
- Trace Object Changes Monthly
- Trace Object Changes Weekly
- Trace Object Summary
- Track Construction Status
- Update Retention Expiration Warning Period
- Update the Retention Expiration Email
- Use a Calendar
- Use the Toolkit for Custom Development
- View Activity
- View Debug Logs
- View Fields Required for System Type Tables
- View the Profiling Results
- View Trace Dashboard: Object Summary
-
Pages
Automation Instruction – SQL
Use this page to Create Instructions.
To access this page:
- Select Common > Automation Engine > Automation Instructions in Navigation pane.
- Click SQL for the instruction to add the SQL code.
Field
Description
Pre Check SQL Template
Pre Check SQL
Displays SQL code used to determine if the SQL execution should precede. The Automation Engine executes the Pre Check SQL and if one or more records are returned, the statement in the SQL field will not be executed. This pre check allows a user to provide checks and control if SQL is run.
SQL Template
SQL
Displays the SQL instruction run to perform the automation step.
Was this article helpful?
Sorry about that.
Why wasn't this helpful? (check all that apply)
Thanks for your feedback.
Want to tell us more?
Send an email to our authors to leave your feedback.
Great!
Thanks for your feedback.