January 2012 8.12 Tables 1629
INSERT In an INSERT statement the table and the values to be set which are to be
enclosed within parentheses, separated by commas and preceded by the
keyword VALUES must be specified. Be sure to assign all columns. The
INSERT command appends a new row to the table. It is not possible to insert
a new row between two rows.
Definition
insert-list := '(' expression-list ')'
insert-statement:= INSERT INTO table VALUES insert-list
Examples:
INSERT INTO TOOL VALUES (9,1,'T2000',0,1000)
INSERT INTO 'OEM:\TOOL.T' VALUES (9,1,'T2000',0,1000)
RENAME TABLE The name of a table file is changed. If a logical table name is specified, the file
identified by the name will be edited. Make sure that the name of the target
file does not already exist. The name stored internally will be edited
accordingly.
With this command, the previous table is copied into a new table. Then the
previous table is deleted. This command allows you to move a table to another
directory.
Definition
rename-table-statement:= RENAME TABLE table TO table
Examples:
RENAME TABLE TOOL TO 'OEM:\TOOL.T'
RENAME TABLE 'OEM:\TOOL.T' TO 'OEM:\TOOL2.T'
To Next Page
Loading...
