Chapter 9 SQL Statements
553
♦
LOTUS The file is a Lotus WKS format worksheet. INPUT assumes
that the first row in the Lotus WKS format worksheet is column names.
If the table doesn’t exist, it will be created. In this case, the types and
sizes of the columns created may not be correct because the information
in the file pertains to a cell, not to a column.
♦
SQL/92 Vendor extension
♦
Sybase Not applicable
♦ The following is an example of an INPUT statement from an ASCII text
file.
INPUT INTO employee
FROM new_emp.inp
FORMAT ascii;
Standards and
compatibility
Example
To Next Page
Loading...