-- Text /* Text */
You can use a double dash to create a comment anywhere within an ij command line and as permitted by the underlying connection within SQL commands. The comment is ended at the first new line encountered in the text.
Comments are ignored on input and have no effect on the output displayed.
You can also enclose text in /* */ characters to create either one-line or multi-line comments. Nested comments are permitted. For example, you could put lines like the following into a script named comment.sql:
/* start the file with a /* nested comment */ and see what happens */ connect 'jdbc:derby:newdb;create=true'; values 'hi!'; create table t (x int); /* use a multi-line comment */ /* insert into t values 1, 2, 3; insert into t values 4, 5, 6; */ /* end the file with a comment */ values 'This is a test'; /* This is also a test */
ij> -- this is a comment; -- the semicolons in the comment are not taken as the end -- of the command; for that, we put it outside the --: ; ij>
ij> run 'comment.sql'; ij> /* start the file with a /* nested comment */ and see what happens */ connect 'jdbc:derby:newdb;create=true'; ij> values 'hi!'; 1 --- hi! 1 row selected ij> create table t (x int); 0 rows inserted/updated/deleted ij> /* use a multi-line comment */ /* insert into t values 1, 2, 3; insert into t values 4, 5, 6; */ /* end the file with a comment */ values 'This is a test'; 1 -------------- This is a test 1 row selected ij> /* This is also a test */ ; ij>