Executing SQL statements with solidDB SQL Editor (solsql)

solidDB Help : Configuring and administering : Using solidDB data management tools : solidDB SQL Editor (solsql) : Executing SQL statements with solidDB SQL Editor (solsql)

To execute SQL statements with solidDB SQL Editor (solsql), the statements must be terminated by a semicolon (;). Remember to commit work after each statement or before exiting solsql.

For example:

CREATE TABLE TESTTABLE (VALUE INTEGER, NAME VARCHAR);
COMMIT WORK;
INSERT INTO TESTTABLE (VALUE, NAME) VALUES (31, 'DUFFY DUCK');
SELECT VALUE, NAME FROM TESTTABLE;
COMMIT WORK;
DROP TABLE TESTTABLE;
COMMIT WORK;

You can use parameter markers with solsql. When a statement that contains parameter markers is executed, solsql prompts for a value for each parameter. You must use this feature to perform write operations when you are using a solidDB grid, see Use dynamic parameter binding in statements.

Each parameter value must be terminated by a semicolon as shown in the following example:

solsql> insert into TAB1 values(?,?,?);
Param 1:
101;
Param 2:
102;
Param 3:
'mytext';

Command completed successfully, 1 rows affected.

Go up to

solidDB SQL Editor (solsql)