5. Populating Tables : Advanced Use of the Copy Statement
 
Share this page                  
Advanced Use of the Copy Statement
You can perform advanced functions with the COPY statement using variations of the statement.
Examples in this section use a database that looks like the following:
Table Name
Column Name
Data Type
Header
Orderno
Date
Suppno
Status
integer2
date
integer2
char(1)
Suppinfo
Suppno
Suppinfo
integer2
char(35)
Detail
Orderno
Invno
Quan
integer2
integer2
integer2
Iteminfo
Invno
Descript
integer2
char(20)
Priceinfo
Invno
Suppno
Catno
Price
integer2
integer2
integer2
money