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 Parameter
PROFILE
- JDBC connect 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).NoteThe 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
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.