HP 3000 Manuals HP 3000 Manuals
INPUT
The INPUT command inserts rows into an existing table.
Scope
ISQL only.
ISQL Syntax
INP[UT] {[Owner.]TableName} (ColumnName [,ColumnName] [...] )
{[Owner.]ViewName }
{(Value [,Value] [...] ) [ROLLBACK WORK]} [...] E[ND]
{ [COMMIT WORK ]}
Parameters
[Owner.]TableName identifies a table in the DBEnvironment you are
using.
[Owner.]ViewName identifies a view based on a single table. Refer
to the discussion of the CREATE VIEW statement in
the ALLBASE/SQL Reference Manual, for
restrictions governing insert operations on a
view.
The new rows are inserted into the table on which
the view is based.
ColumnName identifies the column(s) for which you will
specify values. Columns not specified are
assigned null values (if allowed).
You must provide data for any column that does
not allow null values.
Value is data to be inserted into a column. Within
each set of parentheses, you specify one row of
data; put a space, a carriage return, or a comma
between sets of parentheses. A value must be
specified for each ColumnName specified, in the
order in which you named the columns. Provide
data in the order in which the columns were named
in the table or view definition.[REV BEG]
Character data that contains a single quote must
double the single quote.[REV END]
Values for a row can span lines, but do not split
values across lines. Enclose character values in
single quotation marks. To specify a null value,
enter NULL.
ROLLBACK WORK backs out rows entered since the last COMMIT
WORK.
COMMIT WORK performs a COMMIT WORK. Rows entered up to this
point permanently update the DBEnvironment. A
COMMIT WORK is also processed if the SET
command's AUTOCOMMIT is on every time the number
of rows specified in the AUTOSAVE option of the
SET command has been entered.
END terminates the INPUT command. If AUTOCOMMIT is
on, ISQL issues a COMMIT WORK, and the following
message appears:
Number of rows processed is n
DBEnvironment has been updated.
If AUTOCOMMIT is off, you must explicitly save
any unsaved input, as indicated by the following
message that appears after you enter END:
Number of rows processed is n
COMMIT WORK to save to DBEnvironment.
Description
* You must establish a DBE session with the CONNECT or START DBE
statement before using the INPUT command.
* ISQL formulates an SQL INSERT statement from the information
provided in the INPUT command.
* The INPUT command is processed after you enter END, unless you are
in prompting mode. In prompting mode, each row is inserted before
you are prompted for the next row.
* In prompting mode, ISQL prompts you for table names, column names,
and data values as shown here:
isql=> INPUT;
Table name> TableName;
Column names> (ColumnName1, ColumnName2...);
1> (Value1, Value2, 'CharValue3');
2>
:
5> END;
* The INPUT command assumes that you are inputting data in the
default format for the data type. If you enter something other
than a string, or if the string is the wrong size, an error
results. An example of a correct INPUT command follows:
isql=>INPUT PurchDB.SupplyBatches(VendPartNumber,BatchStamp,
MinPassRate);
1> ('90015', '1984-07-09 11:09:18.432', 0.9732);
2> ('7310', '1984-07-14 10:11:13.824', 0.9794);
3> END;
Number of rows processed is 2
COMMIT WORK to save to DBEnvironment.
isql=>
[REV BEG]
* Character data that contains a single quote must double the single
quote. For example:
isql=> INPUT PurchDB.Parts (PartNumber,PartName,SalesPrice)
> ('2002-DA-01', 'Joe''s Plotter', 500.00)
> END;
Number of rows processed is 1
COMMIT WORK to save to DBEnvironment.
isql=>[REV END]
Authorization
You must have authorization to insert a row into the named table or into
the table on which the named view is derived. Refer to the discussion of
the INSERT statement in the ALLBASE/SQL Reference Manual.
Example
In prompting mode:
isql=> INPUT PurchDB.Parts (PartNumber);
1> ('2033-KLT-01');
2> ('2034-BLT-01'),('999-99-9999');
4> END;
Number of rows processed is 3
COMMIT WORK to save to DBEnvironment.
isql=> COMMIT WORK;
In nonprompting mode:
isql=> INPUT PurchDB.SupplyPrice (PartNumber,VendorNumber,VendPartNumber)
> ('2033-KLT-01', 9002, 'A10')
> ('2034-BLT-01', 9003, 'A12')
> END;
Number of rows processed is 2
COMMIT WORK to save to DBEnvironment.
isql=> COMMIT WORK;