dbscript

Executes an SQL script to load data. Administrative privileges are required to execute this command.

Syntax

dbscript PROFILE [cs=CHARSET] SQL_FILE_PATH [:parameter ...]
Required Parameters
PROFILE
JDBC connection profile. You can configure the connect profile in the web console.
SQL_FILE_PATH
Path to the SQL script file to run. The maximum length of an SQL script file cannot exceed 1 MB (1,048,576 bytes).
Note
The SQL script file must meet the following conditions:
- Only the 'SELECT' query is available.
- You can use a question mark (?) to specify where to insert the parameter.
Optional Parameters
cs=CHARSET
Character set (default: utf-8). Use the preferred MIME name or aliases registered in the following document: http://www.iana.org/assignments/character-sets/character-sets.xhtml
:parameter ...
Parameters to be referenced in the script. Use whitespaces as a separator. It replaces the placeholder in the SQL file in the order of the parameters. The name of the parameter must start with a colon (:).You can set the parameters using the set command or take over the procedure call argument as a parameter. For calling procedures, refer to the dbcall command.