Import SQL File

Parameters

Input:

• Log Save In Folder (Folder) - Location for the log file to be stored
• Document (Document) - The DDL Script to be imported
• Jndi Name (Text) - The data store name to import the scripts into

Output: 

• Log file (Document) - File that contains the error found during import or the log content in case of success
• Error Occurred (Boolean) - Set to true if any error has occurred.
• Error Text (Text) - Provides the result message.

Notes

• This smart service works only with MySQL and SQL Server.
• The following statement can be used in the SQL file to set the database on which the queries that follow should run on
  • USE `database_name`;
• Supported file formats: .sql, .zip. The zipped file can include multiple sql script files.