Syntax

The LONG VARCHAR FOR BIT DATA type allows storage of bit strings -up to 32,700 bytes. It is identical to , +up to 32,700 bytes. It is identical to VARCHAR FOR BIT DATA, except that you do not have to specify a maximum length when creating columns of this type.

Syntax LONG VARCHAR FOR BIT DATA Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj30540.dita URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj30540.dita?rev=202296&r1=202295&r2=202296&view=diff ============================================================================== --- incubator/derby/docs/trunk/src/ref/rrefsqlj30540.dita (original) +++ incubator/derby/docs/trunk/src/ref/rrefsqlj30540.dita Tue Jun 28 15:46:15 2005 @@ -19,15 +19,15 @@ column-definition - DataType - [ ]* + Simple-column-Name DataType + [ Column-level-constraint ]* [ [ WITH ] DEFAULT { ConstantExpression | NULL } - | ] - [ ]* + |generated-column-spec ] + [ Column-level-constraint ]*
The syntax of Data-Type is described in .
The -syntaxes of and are described in Column-level-constraint and Table-level constraint are described in .

Column default
For the definition of a default value, a ConstantExpression is an expression that does Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj31580.dita URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj31580.dita?rev=202296&r1=202295&r2=202296&view=diff ============================================================================== --- incubator/derby/docs/trunk/src/ref/rrefsqlj31580.dita (original) +++ incubator/derby/docs/trunk/src/ref/rrefsqlj31580.dita Tue Jun 28 15:46:15 2005 @@ -26,7 +26,7 @@

A schema is a way to logically group objects in a single collection and provide a unique namespace for objects.
-Syntax CREATE SCHEMA
The +Syntax CREATE SCHEMA schemaName
The CREATE SCHEMA statement is used to create a schema. A schema name cannot exceed 128 characters. Schema names must be unique within the database.
-- Create a schema for employee-related tables Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj31648.dita URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj31648.dita?rev=202296&r1=202295&r2=202296&view=diff ============================================================================== --- incubator/derby/docs/trunk/src/ref/rrefsqlj31648.dita (original) +++ incubator/derby/docs/trunk/src/ref/rrefsqlj31648.dita Tue Jun 28 15:46:15 2005 @@ -27,7 +27,7 @@

The DROP SCHEMA statement drops a schema. The target schema must be empty for the drop to succeed.

Neither the APP schema (the default user schema) nor the SYS schema can be dropped.
-Syntax DROP SCHEMA RESTRICT
Syntax DROP SCHEMA schemaName RESTRICT
The RESTRICT keyword enforces the rule that no objects can be defined in the specified schema for the schema to be deleted from the database. The RESTRICT keyword is required
Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj31783.dita URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj31783.dita?rev=202296&r1=202295&r2=202296&view=diff ============================================================================== --- incubator/derby/docs/trunk/src/ref/rrefsqlj31783.dita (original) +++ incubator/derby/docs/trunk/src/ref/rrefsqlj31783.dita Tue Jun 28 15:46:15 2005 @@ -25,16 +25,16 @@

CursorsIn-place updatesThe -FOR UPDATE clause is an optional part of a . +FOR UPDATE clause is an optional part of a SELECT statement. The FOR UPDATE clause specifies whether the ResultSet of a simple that meets the requirements for a cursor is +href="rrefsqlj41360.dita#rrefsqlj41360">SELECT statement that meets the requirements for a cursor is updatable or not. For more information about updatability, see Requirements for Updatable Cursors.
Syntax FOR { READ ONLY | FETCH ONLY | - UPDATE [ OF [ , ]* ] + UPDATE [ OF Simple-column-Name [ , Simple-column-Name]* ] }
Simple-column-Name refers to the names visible for the table specified in the FROM clause of the underlying query.

Cursors are read-only by default. For a cursor to be updatable, you must specify FOR Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj32268.dita URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj32268.dita?rev=202296&r1=202295&r2=202296&view=diff ============================================================================== --- incubator/derby/docs/trunk/src/ref/rrefsqlj32268.dita (original) +++ incubator/derby/docs/trunk/src/ref/rrefsqlj32268.dita Tue Jun 28 15:46:15 2005 @@ -33,16 +33,10 @@ is not transactional: If the SET SCHEMA statement is part of a transaction that is rolled back, the schema change remains in effect.
Syntax SET [CURRENT] SCHEMA [=] +{ schemaName | +USER | ? | '<string-constant>' } | SET CURRENT SQLID [=] { - | -USER | ? | '<string-constant>' -} -| -SET CURRENT SQLID [=] -{ - | -USER | ? | '<string-constant>' -}
is +schemaName | USER | ? | '<string-constant>' }
schemaName is an identifier with a maximum length of 128. It is case insensitive unless enclosed in double quotes. (For example, SYS is equivalent to sYs, SYs, sys, etcetera.)

USER is the current user. If no current user is defined, Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj32654.dita URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj32654.dita?rev=202296&r1=202295&r2=202296&view=diff ============================================================================== --- incubator/derby/docs/trunk/src/ref/rrefsqlj32654.dita (original) +++ incubator/derby/docs/trunk/src/ref/rrefsqlj32654.dita Tue Jun 28 15:46:15 2005 @@ -23,18 +23,18 @@ GROUP BY clause -

A GROUP BY clause, part of a , groups +

A GROUP BY clause, part of a SelectExpression, groups a result into subsets that have matching values for one or more columns. In each group, no two rows have the same value for the grouping column or columns. NULLs are considered equivalent for grouping purposes.

You typically use a GROUP BY clause in conjunction with an aggregate expression.
-Syntax GROUP BY [ , ] *
must be a column from +Syntax GROUP BY column-Name [ , column-Name ] *
column-Name must be a column from the current scope of the query; there can be no columns from a query block outside the current scope. For example, if a GROUP BY clause is in a subquery, it cannot refer to columns in the outer query.

SelectItems in -the with +the SelectExpression with a GROUP BY clause must contain only aggregates or grouping columns.
-- find the average flying_times of flights grouped by -- airport Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj32693.dita URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj32693.dita?rev=202296&r1=202295&r2=202296&view=diff ============================================================================== --- incubator/derby/docs/trunk/src/ref/rrefsqlj32693.dita (original) +++ incubator/derby/docs/trunk/src/ref/rrefsqlj32693.dita Tue Jun 28 15:46:15 2005 @@ -31,7 +31,7 @@ The ALL qualifier retains duplicates. ALL is the default value if neither ALL nor DISTINCT is specified. For example, if a column contains the values 1.0, 1.0, 1.0, 1.0, and 2.0, AVG(col) returns a smaller value than AVG(DISTINCT -col).

Only one DISTINCT aggregate expression per is +col).

Only one DISTINCT aggregate expression per SelectExpression is allowed. For example, the following query is not valid: SELECT AVG (DISTINCT flying_time), SUM (DISTINCT miles) FROM Flights

The expression can contain multiple column references or expressions, but it cannot contain another aggregate or subquery. Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj33215.dita URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj33215.dita?rev=202296&r1=202295&r2=202296&view=diff ============================================================================== --- incubator/derby/docs/trunk/src/ref/rrefsqlj33215.dita (original) +++ incubator/derby/docs/trunk/src/ref/rrefsqlj33215.dita Tue Jun 28 15:46:15 2005 @@ -20,11 +20,11 @@ TableOrViewExpression - { | } - [ [ AS ] - [ ( [ , ]* ) ] ] ] + { table-Name | view-Name} + [ [ AS ] correlation-Name + [ (Simple-column-Name [ , Simple-column-Name]* ) ] ] ] Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj33520.dita URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj33520.dita?rev=202296&r1=202295&r2=202296&view=diff ============================================================================== --- incubator/derby/docs/trunk/src/ref/rrefsqlj33520.dita (original) +++ incubator/derby/docs/trunk/src/ref/rrefsqlj33520.dita Tue Jun 28 15:46:15 2005 @@ -30,7 +30,7 @@ Syntax MIN ( [ DISTINCT | ALL ] Expression )
The DISTINCT and ALL qualifiers eliminate or retain duplicates, but these qualifiers have no effect in a MIN expression. Only one DISTINCT aggregate expression -per is +per SelectExpression is allowed. For example, the following query is not allowed: SELECT COUNT (DISTINCT flying_time), MIN (DISTINCT miles) FROM Flights

The expression can contain multiple column references or expressions, but it cannot contain another aggregate or subquery. @@ -38,7 +38,7 @@ evaluate to built-in data types. (For example, a method that returns a java.lang.Integer or int evaluates to an INTEGER.) If an expression evaluates to NULL, the aggregate skips that value.

The type's comparison rules determine the maximum value. For -CHAR, VARCHAR, and , +CHAR, VARCHAR, and LONG VARCHAR, the number of blank spaces at the end of the value can affect the result.

The resulting data type is the same as the expression on which it operates (it will never overflow).
Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj33562.dita URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj33562.dita?rev=202296&r1=202295&r2=202296&view=diff ============================================================================== --- incubator/derby/docs/trunk/src/ref/rrefsqlj33562.dita (original) +++ incubator/derby/docs/trunk/src/ref/rrefsqlj33562.dita Tue Jun 28 15:46:15 2005 @@ -39,7 +39,7 @@ conversions between data types are valid. The first column on the table lists the source types, while the first row lists the target types. A "Y" indicates that the source to the target is a valid conversion. -Y -TIMESTAMP +TIME STAMP - - - @@ -597,8 +597,8 @@
approximate numeric (FLOAT, REAL, DOUBLE PRECISION)

string
-
character string (CLOB, CHAR, VARCHAR, )
-
bit string (BLOB, CHAR FOR BIT DATA, VARCHAR FOR BIT DATA, )
+
character string (CLOB, CHAR, VARCHAR, LONG VARCHAR)
+
bit string (BLOB, CHAR FOR BIT DATA, VARCHAR FOR BIT DATA, LONG VARCHAR FOR BIT DATA)

date/time

Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj33602.dita URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj33602.dita?rev=202296&r1=202295&r2=202296&view=diff ============================================================================== --- incubator/derby/docs/trunk/src/ref/rrefsqlj33602.dita (original) +++ incubator/derby/docs/trunk/src/ref/rrefsqlj33602.dita Tue Jun 28 15:46:15 2005 @@ -23,13 +23,13 @@ WHERE clause -

A WHERE clause is an optional part of a , , or . +

A WHERE clause is an optional part of a SelectExpression, DELETE statement, or UPDATE statement. The WHERE clause lets you select rows based on a boolean expression. Only rows for which the expression evaluates to TRUE are returned in the result, or, in the case of a DELETE statement, deleted, or, in the case of an UPDATE statement, updated.
-Syntax WHERE
WHERE +Syntax WHERE Boolean expression
WHERE clauseSQL extensions toBoolean expressions are allowed in the WHERE clause. Most of the general expressions listed in , can result in a Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj33923.dita URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj33923.dita?rev=202296&r1=202295&r2=202296&view=diff ============================================================================== --- incubator/derby/docs/trunk/src/ref/rrefsqlj33923.dita (original) +++ incubator/derby/docs/trunk/src/ref/rrefsqlj33923.dita Tue Jun 28 15:46:15 2005 @@ -73,17 +73,17 @@

Aggregatesrequirements forAggregates are permitted only in the following:
-
A SelectItem in a .
-
A .
-
An (using an alias +
A SelectItem in a SelectExpression.
+
A HAVING clause.
+
An ORDER BY clause (using an alias name) if the aggregate appears in the result of the relevant query block. -That is, an alias for an aggregate is permitted in an if -and only if the aggregate appears in a SelectItem in a .
+That is, an alias for an aggregate is permitted in an ORDER BY clause if +and only if the aggregate appears in a SelectItem in a SelectExpression.
-
All expressions in SelectItems in the must +
All expressions in SelectItems in the SelectExpression must be either aggregates or grouped columns (see ). (The same is true if there is a HAVING clause without a GROUP BY clause.) -This is because the ResultSet of a must +This is because the ResultSet of a SelectExpression must be either a scalar (single value) or a vector (multiple values), but not a mixture of both. (Aggregates evaluate to a scalar value, and the reference to a column can evaluate to a vector.) For example, the following query mixes Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj34148.dita URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj34148.dita?rev=202296&r1=202295&r2=202296&view=diff ============================================================================== --- incubator/derby/docs/trunk/src/ref/rrefsqlj34148.dita (original) +++ incubator/derby/docs/trunk/src/ref/rrefsqlj34148.dita Tue Jun 28 15:46:15 2005 @@ -25,7 +25,7 @@

DROP TABLE removes the specified table.
-Syntax DROP TABLE +Syntax DROP TABLE table-Name
Statement dependency system
Triggers, constraints (primary, unique, check and references from the table being dropped) and indexes on the table are silently dropped. The existence of an open cursor Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj35034.dita URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj35034.dita?rev=202296&r1=202295&r2=202296&view=diff ============================================================================== --- incubator/derby/docs/trunk/src/ref/rrefsqlj35034.dita (original) +++ incubator/derby/docs/trunk/src/ref/rrefsqlj35034.dita Tue Jun 28 15:46:15 2005 @@ -23,13 +23,10 @@ INNER JOIN expression -

An INNER JOIN is a that +

An INNER JOIN is a JOIN operations that allows you to specify an explicit join clause.
Syntax TableExpression [ INNER ] JOIN TableExpression -{ - ON booleanExpression } - }
You can specify the join clause by specifying ON +>TableExpression { ON booleanExpression }
You can specify the join clause by specifying ON with a boolean expression.

ON clausepart of INNER JOIN expressionThe scope of expressions in the ON clause includes the current tables and any tables in outer query blocks Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj35981.dita URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj35981.dita?rev=202296&r1=202295&r2=202296&view=diff ============================================================================== --- incubator/derby/docs/trunk/src/ref/rrefsqlj35981.dita (original) +++ incubator/derby/docs/trunk/src/ref/rrefsqlj35981.dita Tue Jun 28 15:46:15 2005 @@ -26,7 +26,7 @@
Syntax { DELETE FROM table-Name - [] | + [WHERE clause] | DELETE FROM table-Name WHERE CURRENT OF }

The first syntactical form, called a searched delete, removes Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj38716.dita URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj38716.dita?rev=202296&r1=202295&r2=202296&view=diff ============================================================================== --- incubator/derby/docs/trunk/src/ref/rrefsqlj38716.dita (original) +++ incubator/derby/docs/trunk/src/ref/rrefsqlj38716.dita Tue Jun 28 15:46:15 2005 @@ -31,14 +31,14 @@ eliminates duplicates. The ALL qualifier retains duplicates. ALL is assumed if neither ALL nor DISTINCT is specified. For example, if a column contains the values 1, 1, 1, 1, and 2, COUNT(col) returns a greater value than COUNT(DISTINCT -col).

Only one DISTINCT aggregate expression per is +col).

Only one DISTINCT aggregate expression per SelectExpression is allowed. For example, the following query is not allowed:
-- query not allowed SELECT COUNT (DISTINCT flying_time), SUM (DISTINCT miles) FROM Flights
An Expression can contain multiple column references or expressions, but it cannot contain another aggregate or subquery. If an Expression evaluates to NULL, the aggregate is not processed for that value.

The resulting data type of COUNT is .
+href="rrefsqlj30435.dita#rrefsqlj30435">BIGINT.
-- Count the number of countries in each region, -- show only regions that have at least 2 SELECT COUNT (country), region Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj40506.dita URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj40506.dita?rev=202296&r1=202295&r2=202296&view=diff ============================================================================== --- incubator/derby/docs/trunk/src/ref/rrefsqlj40506.dita (original) +++ incubator/derby/docs/trunk/src/ref/rrefsqlj40506.dita Tue Jun 28 15:46:15 2005 @@ -31,7 +31,7 @@ user-initiated lock escalation)
avoiding deadlocks

You cannot lock system tables with this statement.
-Syntax LOCK TABLE IN { SHARE | EXCLUSIVE } MODESyntax LOCK TABLE table-Name IN { SHARE | EXCLUSIVE } MODE
Once a table is locked in either mode, a transaction does not acquire any subsequent row-level locks on a table. Replace line 13 with this: For example, if a transaction locks the entire Flights table in share Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj40774.dita URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj40774.dita?rev=202296&r1=202295&r2=202296&view=diff ============================================================================== --- incubator/derby/docs/trunk/src/ref/rrefsqlj40774.dita (original) +++ incubator/derby/docs/trunk/src/ref/rrefsqlj40774.dita Tue Jun 28 15:46:15 2005 @@ -28,17 +28,17 @@ The number of values assigned in an INSERT statement must be the same as the number of specified or implied columns.
Syntax INSERT INTO table-Name - [ ( [ , ]* ) ] + [ (Simple-column-Name [ , Simple-column-Name]* ) ] Query
Query can be:
-
a
+
a SelectExpression

a VALUES list

a multiple-row VALUES expression
Single-row and multiple-row lists can include the keyword DEFAULT. Specifying DEFAULT for a column inserts the column's default value into the column. Another way to insert the default value into the column is to omit the column from the column list and only insert values into other columns in the table. For more information see .
+href="rrefsqlj11277.dita#rrefsqlj11277">VALUES Expression.

UNION expressions

For more information about Query, see .
INSERT INTO COUNTRIES Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj41360.dita URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj41360.dita?rev=202296&r1=202295&r2=202296&view=diff ============================================================================== --- incubator/derby/docs/trunk/src/ref/rrefsqlj41360.dita (original) +++ incubator/derby/docs/trunk/src/ref/rrefsqlj41360.dita Tue Jun 28 15:46:15 2005 @@ -25,18 +25,18 @@

A SELECT statement consists of a query with an optional and an optional . +href="rrefsqlj13658.dita#rrefsqlj13658">ORDER BY clause and an optional FOR UPDATE clause. The SELECT statement is so named because the typical first word of the query construct is SELECT. (Query includes the VALUES expression and UNION, INTERSECT, and EXCEPT -expressions as well as SELECT expressions).

The guarantees -the ordering of the ResultSet. The makes +expressions as well as SELECT expressions).

The ORDER BY clause guarantees +the ordering of the ResultSet. The FOR UPDATE clause makes the result an updatable cursor. The SELECT statement supports the FOR FETCH ONLY clause. The FOR FETCH ONLY clause is synonymous with the FOR READ ONLY clause.
In order to get an updatable ResultSet, you must include a FOR UPDATE clause with the SELECT clause.
-Syntax -[] -[] +Syntax Query +[ORDER BY clause] +[FOR UPDATE clause] WITH {RR|RS|CS|UR}
You can set the isolation level in a SELECT statement using the WITH {RR|RS|CS|UR} syntax.
-- lists the names of the expression SAL+BONUS+COMM as TOTAL_PAY and @@ -71,8 +71,8 @@ has the same syntax as the SELECT statement for updatable cursors. To generate updatable cursors:

The SELECT statement must not include an ORDER BY clause.
-
The underlying Query must be a .
-
The in +
The underlying Query must be a SelectExpression.
+
The SelectExpression in the underlying Query must not include:

DISTINCT

Aggregates
@@ -82,7 +82,7 @@
The FROM clause in the underlying Query must not have:

more than one table in its FROM clause

anything other than one table name
-
s
+
SelectExpressions

subqueries

There is no SQL language statement to assign a name to Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj42082.dita URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj42082.dita?rev=202296&r1=202295&r2=202296&view=diff ============================================================================== --- incubator/derby/docs/trunk/src/ref/rrefsqlj42082.dita (original) +++ incubator/derby/docs/trunk/src/ref/rrefsqlj42082.dita Tue Jun 28 15:46:15 2005 @@ -25,7 +25,7 @@

DROP TRIGGER removes the specified trigger.
-Syntax DROP TRIGGER +Syntax DROP TRIGGER TriggerName DROP TRIGGER TRIG1
Statement dependency system
When a table is dropped, all triggers on that table are automatically dropped. (You Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj42154.dita URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj42154.dita?rev=202296&r1=202295&r2=202296&view=diff ============================================================================== --- incubator/derby/docs/trunk/src/ref/rrefsqlj42154.dita (original) +++ incubator/derby/docs/trunk/src/ref/rrefsqlj42154.dita Tue Jun 28 15:46:15 2005 @@ -20,17 +20,17 @@ Table-level constraint - [CONSTRAINT ] + [CONSTRAINT constraint-Name] { - CHECK () | + CHECK (searchCondition) | { - PRIMARY KEY ( [ , ]* ) | - UNIQUE ( [ , ]* ) | - FOREIGN KEY ( [ , ]* ) - + PRIMARY KEY ( Simple-column-Name [ , Simple-column-Name ]* ) | + UNIQUE ( Simple-column-Name [ , Simple-column-Name ]* ) | + FOREIGN KEY ( Simple-column-Name [ , Simple-column-Name ]* ) + REFERENCES clause } } Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj42324.dita URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj42324.dita?rev=202296&r1=202295&r2=202296&view=diff ============================================================================== --- incubator/derby/docs/trunk/src/ref/rrefsqlj42324.dita (original) +++ incubator/derby/docs/trunk/src/ref/rrefsqlj42324.dita Tue Jun 28 15:46:15 2005 @@ -25,7 +25,7 @@

CURRENT_USER returns the authorization identifier of the current user (the name of the user passed in when the user connected to the database). -If there is no current user, it returns APP.

and are +If there is no current user, it returns APP.

USER and SESSION_USER are synonyms.

These functions return a string of up to 128 characters.
Syntax CURRENT_USER VALUES CURRENT_USER Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj42476.dita URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj42476.dita?rev=202296&r1=202295&r2=202296&view=diff ============================================================================== --- incubator/derby/docs/trunk/src/ref/rrefsqlj42476.dita (original) +++ incubator/derby/docs/trunk/src/ref/rrefsqlj42476.dita Tue Jun 28 15:46:15 2005 @@ -24,8 +24,8 @@

USER returns the authorization identifier or name of the current -user. If there is no current user, it returns APP.
USER, , -and are synonyms.
+user. If there is no current user, it returns APP.
USER, CURRENT_USER, +and SESSION_USER are synonyms.
SyntaxUSER VALUES USER Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj43125.dita URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj43125.dita?rev=202296&r1=202295&r2=202296&view=diff ============================================================================== --- incubator/derby/docs/trunk/src/ref/rrefsqlj43125.dita (original) +++ incubator/derby/docs/trunk/src/ref/rrefsqlj43125.dita Tue Jun 28 15:46:15 2005 @@ -44,11 +44,11 @@ the table on which it is defined.

If a qualified trigger name is specified, the schema name cannot begin with SYS.
Syntax CREATE TRIGGER +href="rreftriggername.dita#rreftriggername">TriggerName { AFTER | NO CASCADE BEFORE } -{ INSERT | DELETE | UPDATE } [ OF column-Name [, ]* ] -ON -[ ] +{ INSERT | DELETE | UPDATE } [ OF column-Name [, column-Name]* ] +ON table-Name +[ ReferencingClause ] FOR EACH { ROW | STATEMENT } MODE DB2SQL Triggered-SQL-statement
Before or after: when triggers fire
Triggers are Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj57522.dita URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj57522.dita?rev=202296&r1=202295&r2=202296&view=diff ============================================================================== --- incubator/derby/docs/trunk/src/ref/rrefsqlj57522.dita (original) +++ incubator/derby/docs/trunk/src/ref/rrefsqlj57522.dita Tue Jun 28 15:46:15 2005 @@ -23,7 +23,7 @@ RIGHT OUTER JOIN expression -

A RIGHT OUTER JOIN is one of the s +

A RIGHT OUTER JOIN is one of the JOIN operationss that allow you to specify a JOIN clause. It preserves the unmatched rows from the second (right) table, joining them with a NULL in the shape of the first (left) table. A LEFT OUTER JOIN B is equivalent to B RIGHT OUTER JOIN A, with Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj59893.dita URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj59893.dita?rev=202296&r1=202295&r2=202296&view=diff ============================================================================== --- incubator/derby/docs/trunk/src/ref/rrefsqlj59893.dita (original) +++ incubator/derby/docs/trunk/src/ref/rrefsqlj59893.dita Tue Jun 28 15:46:15 2005 @@ -24,7 +24,7 @@

DROP INDEX removes the specified index.
-Syntax DROP INDEX +Syntax DROP INDEX index-Name DROP INDEX OrigIndex DROP INDEX DestIndex Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj61102.dita URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj61102.dita?rev=202296&r1=202295&r2=202296&view=diff ============================================================================== --- incubator/derby/docs/trunk/src/ref/rrefsqlj61102.dita (original) +++ incubator/derby/docs/trunk/src/ref/rrefsqlj61102.dita Tue Jun 28 15:46:15 2005 @@ -25,7 +25,7 @@

Drops the specified view.
-Syntax DROP VIEW +Syntax DROP VIEW view-Name DROP VIEW AnIdentifier
Statement dependency system
Any statements referencing the view are invalidated on a DROP VIEW statement. DROP VIEW is Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj66113.dita URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj66113.dita?rev=202296&r1=202295&r2=202296&view=diff ============================================================================== --- incubator/derby/docs/trunk/src/ref/rrefsqlj66113.dita (original) +++ incubator/derby/docs/trunk/src/ref/rrefsqlj66113.dita Tue Jun 28 15:46:15 2005 @@ -27,7 +27,7 @@ accessed. No NULLs or duplicates are eliminated. COUNT(*) does not operate on an expression.
Syntax COUNT(*)
The -resulting data type is .
+resulting data type is BIGINT.
-- Count the number of rows in the Flights table SELECT COUNT(*) FROM Flights Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj73147.dita URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj73147.dita?rev=202296&r1=202295&r2=202296&view=diff ============================================================================== --- incubator/derby/docs/trunk/src/ref/rrefsqlj73147.dita (original) +++ incubator/derby/docs/trunk/src/ref/rrefsqlj73147.dita Tue Jun 28 15:46:15 2005 @@ -24,8 +24,8 @@

Returns the square root of a floating point number; only the -built-in types , , and DOUBLE +built-in types REAL, FLOAT, and DOUBLE PRECISION are supported. The return type for SQRT is the type of the parameter.
To execute SQRT on other data types, you must cast them to floating point types.
Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj81859.dita URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj81859.dita?rev=202296&r1=202295&r2=202296&view=diff ============================================================================== --- incubator/derby/docs/trunk/src/ref/rrefsqlj81859.dita (original) +++ incubator/derby/docs/trunk/src/ref/rrefsqlj81859.dita Tue Jun 28 15:46:15 2005 @@ -36,16 +36,16 @@
increase the width of a VARCHAR, CHAR VARYING, and CHARACTER VARYING column

override row-level locking for the table (or drop the override)

-
SyntaxALTER TABLE +
SyntaxALTER TABLE table-Name { - ADD COLUMN | - ADD | + ADD COLUMN column-definition | + ADD CONSTRAINT clause | DROP { PRIMARY KEY | FOREIGN KEY constraint-name | UNIQUE constraint-name | CHECK constraint-name | CONSTRAINT constraint-name } - ALTER | + ALTER column-alteration | LOCKSIZE { ROW | TABLE } }
-
Adding columns
The syntax for the for +
Adding columns
The syntax for the column-definition for a new column is the same as for a column in a CREATE TABLE statement. This means that a column constraint can be placed on the new column within the ALTER TABLE ADD COLUMN statement. However, a column with a NOT NULL constraint @@ -81,7 +81,7 @@ a delimited identifier.
Dropping a primary key, unique, or foreign key constraint drops the physical index that enforces the constraint (also known as a backing index).
-
Modifying columns
The allows +
Modifying columns
The column-alteration allows you to alter the named column in the following ways:

Increasing the length of an existing VARCHAR column. CHARACTER VARYING or CHAR VARYING can be used as synonyms for the VARCHAR keyword.
To increase @@ -145,7 +145,8 @@ ALTER TABLE Activities ADD PRIMARY KEY (city_id, activity); -- Drop a primary key constraint from the CITIES table -ALTER TABLE Cities DROP CONSTRAINT Cities_PK; + +ALTER TABLE Cities DROP CONSTRAINT Cities_PK; -- Drop a foreign key constraint from the CITIES table ALTER TABLE Cities DROP CONSTRAINT COUNTRIES_FK; -- add a DEPTNO column with a default value of 1 Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj91438.dita URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj91438.dita?rev=202296&r1=202295&r2=202296&view=diff ============================================================================== --- incubator/derby/docs/trunk/src/ref/rrefsqlj91438.dita (original) +++ incubator/derby/docs/trunk/src/ref/rrefsqlj91438.dita Tue Jun 28 15:46:15 2005 @@ -20,7 +20,7 @@ searchCondition -
A searchCondition is any that +
A searchCondition is any Boolean expression that meets the requirements specified in .

If a constraint-Name is not specified, generates a unique constraint name (for either column or table constraints).
Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj93082.dita URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj93082.dita?rev=202296&r1=202295&r2=202296&view=diff ============================================================================== --- incubator/derby/docs/trunk/src/ref/rrefsqlj93082.dita (original) +++ incubator/derby/docs/trunk/src/ref/rrefsqlj93082.dita Tue Jun 28 15:46:15 2005 @@ -24,8 +24,8 @@

The SUBSTR function acts on a character string expression or -a bit string expression. The type of the result is a in -the first case and in +a bit string expression. The type of the result is a VARCHAR in +the first case and VARCHAR FOR BIT DATA in the second case. The length of the result is the maximum length of the source type.
Syntax SUBSTR({ CharacterExpression }, Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj98067.dita URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj98067.dita?rev=202296&r1=202295&r2=202296&view=diff ============================================================================== --- incubator/derby/docs/trunk/src/ref/rrefsqlj98067.dita (original) +++ incubator/derby/docs/trunk/src/ref/rrefsqlj98067.dita Tue Jun 28 15:46:15 2005 @@ -25,8 +25,7 @@

ABS or ABSVAL returns the absolute value of a numeric expression. The return type is the type of parameter. All built-in numeric types are supported -(, DOUBLE -PRECISION, , , , , , , , , and ).
Modified: incubator/derby/docs/trunk/src/ref/rrefsqljcreatesynonym.dita URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqljcreatesynonym.dita?rev=202296&r1=202295&r2=202296&view=diff ============================================================================== --- incubator/derby/docs/trunk/src/ref/rrefsqljcreatesynonym.dita (original) +++ incubator/derby/docs/trunk/src/ref/rrefsqljcreatesynonym.dita Tue Jun 28 15:46:15 2005 @@ -1,52 +1,51 @@ - - - - -CREATE SYNONYM statement - -CREATE SYNONYM statementSynonymscreating - - - -
Use the CREATE SYNONYM statement to provide an alternate name -for a table or a view that is present in the same schema or another schema. -You can also create synonyms for other synonyms, resulting in nested synonyms. -A synonym can be used instead of the original qualified table or view name -in SELECT, INSERT, UPDATE, DELETE or LOCK TABLE statements. You can create -a synonym for a table or a view that doesn't exist, but the target table or -view must be present before the synonym can be used.
Synonyms share -the same namespace as tables or views. You cannot create a synonym with the -same name as a table that already exists in the same schema. Similarly, you -cannot create a table or view with a name that matches a synonym already present.
A -synonym can be defined for a table/view that does not exist when you create -the synonym. If the table or view doesn't exist, you will receive a warning -message (SQLSTATE 01522). The referenced object must be present when you -use a synonym in a DML statement.
You can create a nested synonym (a -synonym for another synonym), but any attempt to create a synonym that results -in a circular reference will return an error message (SQLSTATE 42916).
Synonyms cannot be defined in system schemas. All schemas starting with 'SYS' are considered system schemas and are reserved by .
A synonym cannot -be defined on a temporary table. Attempting to define a synonym on a temporary -table will return an error message (SQLSTATE XCL51).
-
SyntaxCREATE SYNONYM FOR { | }The in the statement represents -the synonym name you are giving the target table or view, while the or represents -the original name of the target table or view.
-ExampleCREATE SYNONYM SAMP.T1 FOR SAMP.TABLEWITHLONGNAME - - + + + + +CREATE SYNONYM statement + +CREATE SYNONYM statementSynonymscreating + + + +
Use the CREATE SYNONYM statement to provide an alternate name +for a table or a view that is present in the same schema or another schema. +You can also create synonyms for other synonyms, resulting in nested synonyms. +A synonym can be used instead of the original qualified table or view name +in SELECT, INSERT, UPDATE, DELETE or LOCK TABLE statements. You can create +a synonym for a table or a view that doesn't exist, but the target table or +view must be present before the synonym can be used.
Synonyms share +the same namespace as tables or views. You cannot create a synonym with the +same name as a table that already exists in the same schema. Similarly, you +cannot create a table or view with a name that matches a synonym already present.
A +synonym can be defined for a table/view that does not exist when you create +the synonym. If the table or view doesn't exist, you will receive a warning +message (SQLSTATE 01522). The referenced object must be present when you +use a synonym in a DML statement.
You can create a nested synonym (a +synonym for another synonym), but any attempt to create a synonym that results +in a circular reference will return an error message (SQLSTATE 42916).
Synonyms cannot be defined in system schemas. All schemas starting with 'SYS' are considered system schemas and are reserved by .
A synonym cannot +be defined on a temporary table. Attempting to define a synonym on a temporary +table will return an error message (SQLSTATE XCL51).
SyntaxCREATE SYNONYM synonym-Name FOR { view-Name | table-Name }The synonym-Name in the statement represents +the synonym name you are giving the target table or view, while the view-Name or table-Name represents +the original name of the target table or view.
+ExampleCREATE SYNONYM SAMP.T1 FOR SAMP.TABLEWITHLONGNAME + + Modified: incubator/derby/docs/trunk/src/ref/rrefsqljcurrenttimestamp.dita URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqljcurrenttimestamp.dita?rev=202296&r1=202295&r2=202296&view=diff ============================================================================== --- incubator/derby/docs/trunk/src/ref/rrefsqljcurrenttimestamp.dita (original) +++ incubator/derby/docs/trunk/src/ref/rrefsqljcurrenttimestamp.dita Tue Jun 28 15:46:15 2005 @@ -23,7 +23,7 @@ CURRENT TIMESTAMP function -

CURRENT TIMESTAMP is a synonym for .
+

CURRENT TIMESTAMP is a synonym for CURRENT_TIMESTAMP.
Modified: incubator/derby/docs/trunk/src/ref/rrefsqljdropsynonym.dita URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqljdropsynonym.dita?rev=202296&r1=202295&r2=202296&view=diff ============================================================================== --- incubator/derby/docs/trunk/src/ref/rrefsqljdropsynonym.dita (original) +++ incubator/derby/docs/trunk/src/ref/rrefsqljdropsynonym.dita Tue Jun 28 15:46:15 2005 @@ -1,31 +1,31 @@ - - - - - -DROP SYNONYM statement - -DROP SYNONYM statementSynonymsdropping - - - -

Drops the specified synonym from a table or view.
-Syntax DROP SYNONYM - - - + + + + + +DROP SYNONYM statement + +DROP SYNONYM statementSynonymsdropping + + + +

Drops the specified synonym from a table or view.
+Syntax DROP SYNONYM synonym-Name + + + Modified: incubator/derby/docs/trunk/src/ref/rrefsqljrenametablestatement.dita URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqljrenametablestatement.dita?rev=202296&r1=202295&r2=202296&view=diff ============================================================================== --- incubator/derby/docs/trunk/src/ref/rrefsqljrenametablestatement.dita (original) +++ incubator/derby/docs/trunk/src/ref/rrefsqljrenametablestatement.dita Tue Jun 28 15:46:15 2005 @@ -26,7 +26,7 @@

RENAME TABLE allows you to rename an existing table in any schema (except the schema SYS).
Syntax RENAME TABLE table-Name TO
If +href="rrefnewtablename.dita#rrefnewtablename">new-Table-Name
If there is a view or foreign key that references the table, attempts to rename it will generate an error. In addition, if there are any check constraints or triggers on the table, attempts to rename it will also generate an error.
Modified: incubator/derby/docs/trunk/src/ref/rrefsynonymname.dita URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsynonymname.dita?rev=202296&r1=202295&r2=202296&view=diff ============================================================================== --- incubator/derby/docs/trunk/src/ref/rrefsynonymname.dita (original) +++ incubator/derby/docs/trunk/src/ref/rrefsynonymname.dita Tue Jun 28 15:46:15 2005 @@ -1,27 +1,27 @@ - - - - -synonym-Name - -
A synonym-Name represents a synonym for a table or a view. -You can qualify a synonym-Name with a schema-Name.
-
Syntax [ . ]
- - + + + + +synonym-Name + +
A synonym-Name represents a synonym for a table or a view. +You can qualify a synonym-Name with a schema-Name.
+
Syntax [ schemaName. ] SQL92Identifier
+ + Modified: incubator/derby/docs/trunk/src/ref/rreftableexpression.dita URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rreftableexpression.dita?rev=202296&r1=202295&r2=202296&view=diff ============================================================================== --- incubator/derby/docs/trunk/src/ref/rreftableexpression.dita (original) +++ incubator/derby/docs/trunk/src/ref/rreftableexpression.dita Tue Jun 28 15:46:15 2005 @@ -24,8 +24,8 @@

A TableExpression specifies a table or -view in a . It is the source from which -a selects +view in a FROM clause. It is the source from which +a SelectExpression selects a result.

A correlation name can be applied to a table in a TableExpression so that its columns can be qualified with that name. If you do not supply a correlation name, the table name qualifies the column @@ -39,13 +39,13 @@ of the table new names in the AS clause. Some situations in which this is useful:
-
When a is used as a , since there is no other way to name -the columns of a .
+
When a VALUES expression is used as a TableSubquery, since there is no other way to name +the columns of a VALUES expression.

When column names would otherwise be the same as those of columns in other tables; renaming them means you don't have to qualify them.

-
The Query in a appearing in a FromItem can contain -multiple columns and return multiple rows. See .
+
The Query in a TableSubquery appearing in a FromItem can contain +multiple columns and return multiple rows. See .

For information about the optimizer overrides you can specify, see .
Syntax Modified: incubator/derby/docs/trunk/src/ref/rreftablename.dita URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rreftablename.dita?rev=202296&r1=202295&r2=202296&view=diff ============================================================================== --- incubator/derby/docs/trunk/src/ref/rreftablename.dita (original) +++ incubator/derby/docs/trunk/src/ref/rreftablename.dita Tue Jun 28 15:46:15 2005 @@ -21,10 +21,10 @@ table-Name
A table-Name represents a table. You can qualify a table-Name with -a schema-Name.
-
Syntax [ . ]
-
Example -- SAMP.PROJECT is a table-Name that includes a schema-Name +a schemaName.
+
Syntax [ schemaName. ] SQL92Identifier
+
Example -- SAMP.PROJECT is a table-Name that includes a schemaName SELECT COUNT(*) FROM SAMP.PROJECT
Modified: incubator/derby/docs/trunk/src/ref/rreftablesubquery.dita URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rreftablesubquery.dita?rev=202296&r1=202295&r2=202296&view=diff ============================================================================== --- incubator/derby/docs/trunk/src/ref/rreftablesubquery.dita (original) +++ incubator/derby/docs/trunk/src/ref/rreftablesubquery.dita Tue Jun 28 15:46:15 2005 @@ -25,20 +25,20 @@

A TableSubquery is a subquery that returns multiple rows.
-
Unlike a , a TableSubquery is allowed only: +
Unlike a ScalarSubquery, a TableSubquery is allowed only:

as a TableExpression in -a
+a FROM clause
with EXISTS, IN, or quantified comparisons.

-
When used as a TableExpression in a , it can return +
When used as a TableExpression in a FROM clause, it can return multiple columns. When used with EXISTS, it returns multiple columns only if you use * to return the multiple columns.

When used with IN or quantified comparisons, it must return a single column.
Syntax -() +(Query) -- a subquery used as a TableExpression in a FROM clause Modified: incubator/derby/docs/trunk/src/ref/rreftriggername.dita URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rreftriggername.dita?rev=202296&r1=202295&r2=202296&view=diff ============================================================================== --- incubator/derby/docs/trunk/src/ref/rreftriggername.dita (original) +++ incubator/derby/docs/trunk/src/ref/rreftriggername.dita Tue Jun 28 15:46:15 2005 @@ -21,8 +21,8 @@ TriggerName
A TriggerName refers to a trigger created by a user.
-
Syntax [ . ]
+
Syntax [ schemaName . ] SQL92Identifier

Example DROP TRIGGER TRIG1
Modified: incubator/derby/docs/trunk/src/ref/rrefviewname.dita URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefviewname.dita?rev=202296&r1=202295&r2=202296&view=diff ============================================================================== --- incubator/derby/docs/trunk/src/ref/rrefviewname.dita (original) +++ incubator/derby/docs/trunk/src/ref/rrefviewname.dita Tue Jun 28 15:46:15 2005 @@ -22,8 +22,8 @@
A view-Name represents a table or a view. You can qualify a view-Name with a schema-Name.
-
Syntax [ . ]
+
Syntax [ schemaName. ] SQL92Identifier

Example -- This is a View qualified by a schema-Name SELECT COUNT(*) FROM SAMP.EMP_RESUME
Modified: incubator/derby/docs/trunk/src/tools/ctoolsij32837.dita URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tools/ctoolsij32837.dita?rev=202296&r1=202295&r2=202296&view=diff ============================================================================== --- incubator/derby/docs/trunk/src/tools/ctoolsij32837.dita (original) +++ incubator/derby/docs/trunk/src/tools/ctoolsij32837.dita Tue Jun 28 15:46:15 2005 @@ -1,4 +1,6 @@ + - - + Getting started with ij - - - - + + -
-
-
-
-
- +
This section discusses the use of the ij tool.
+ + Modified: incubator/derby/docs/trunk/src/tools/ctoolsij34525.dita URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tools/ctoolsij34525.dita?rev=202296&r1=202295&r2=202296&view=diff ============================================================================== --- incubator/derby/docs/trunk/src/tools/ctoolsij34525.dita (original) +++ incubator/derby/docs/trunk/src/tools/ctoolsij34525.dita Tue Jun 28 15:46:15 2005 @@ -17,23 +17,15 @@ Using ij +ij is 's interactive JDBC scripting tool. It is a simple utility for running scripts against a database. -
ij is 's interactive JDBC scripting tool. It is a simple -utility for running scripts against a database. ij is a Java application, +
ij is a Java application, which you start from a command window such as an MS-DOS Command Window or -the UNIX* shell. ij provides several commands for ease in accessing a variety +the UNIX shell. ij provides several commands for ease in accessing a variety of JDBC features through scripts.
-
This chapter includes the following sections: -
-
-
-
-
-
-
Modified: incubator/derby/docs/trunk/src/tools/ctoolsijcomref15645.dita URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tools/ctoolsijcomref15645.dita?rev=202296&r1=202295&r2=202296&view=diff ============================================================================== --- incubator/derby/docs/trunk/src/tools/ctoolsijcomref15645.dita (original) +++ incubator/derby/docs/trunk/src/tools/ctoolsijcomref15645.dita Tue Jun 28 15:46:15 2005 @@ -31,7 +31,7 @@
ij uses the result of the JDBC execute request to determine whether it should print a number-of-rows message or display a result set.

If a JDBC execute request causes an exception, it displays the SQLState, if any, and error message.
-
Setting the ij property to true displays the SQLException's error code (see ).
+
Setting the ij property ij.showErrorCode to true displays the SQLException's error code (see ).

The number-of-rows message for inserts, updates, and deletes conforms to the JDBC specification for any SQL statement that does not have a result set. DDL (data definition language) commands typically report "0 rows inserted/updated/deleted" Modified: incubator/derby/docs/trunk/src/tools/ctoolsijcomref18998.dita URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tools/ctoolsijcomref18998.dita?rev=202296&r1=202295&r2=202296&view=diff ============================================================================== --- incubator/derby/docs/trunk/src/tools/ctoolsijcomref18998.dita (original) +++ incubator/derby/docs/trunk/src/tools/ctoolsijcomref18998.dita Tue Jun 28 15:46:15 2005 @@ -20,13 +20,6 @@ -
ij issues the following messages to inform the user of errors -during processing of statements: -
-
-
-
-
-
-
+
ij might issue messages to inform the user of errors +during processing of statements.
Modified: incubator/derby/docs/trunk/src/tools/ctoolsijtools11318.dita URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tools/ctoolsijtools11318.dita?rev=202296&r1=202295&r2=202296&view=diff ============================================================================== --- incubator/derby/docs/trunk/src/tools/ctoolsijtools11318.dita (original) +++ incubator/derby/docs/trunk/src/tools/ctoolsijtools11318.dita Tue Jun 28 15:46:15 2005 @@ -17,19 +17,12 @@ Tools and localization +The tools provide support for common localization features such as localized message files and GUI, locale-appropriate formatting of data, codesets, unicode identifiers and data, and database territories. -
The tools provide support for common localization features -(such as localized message files and GUI, locale-appropriate formatting of -data, codesets, unicode identifiers and data, and database territories). For -general information about international systems, see the . -
-
-
-
-
+
For general information about international systems, see the .
Modified: incubator/derby/docs/trunk/src/tools/ctoolsijtools20118.dita URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tools/ctoolsijtools20118.dita?rev=202296&r1=202295&r2=202296&view=diff ============================================================================== --- incubator/derby/docs/trunk/src/tools/ctoolsijtools20118.dita (original) +++ incubator/derby/docs/trunk/src/tools/ctoolsijtools20118.dita Tue Jun 28 15:46:15 2005 @@ -1,4 +1,6 @@ + - - + JDBC basics +Most of the tools +are JDBC applications. A JDBC application is one that uses the classes in +the java.sql package to interact with a DBMS. - - - - + + -
Most of the tools are JDBC applications. A JDBC application -is one that uses the classes in the java.sql package -to interact with a DBMS. When you work with JDBC applications, you need to -know about the following two JDBC concepts: -
-
-
-
- +
When you work with JDBC applications, you need to know about several concepts.
+ +