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


dbscript PROFILE [cs=CHARSET] SQL_FILE_PATH [:parameter ...]
Required Parameter
JDBC connect profile. You can configure the connect profile in the web console.
Path to the SQL script file to run. The maximum length of an SQL script file cannot exceed 1 MB (1,048,576 bytes).
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 Parameter
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.