db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Patrick Meyer <meyer...@gmail.com>
Subject importing file with header
Date Fri, 18 Mar 2011 17:25:58 GMT
Is it possible to import data via SYSCS_UTIL.SYSCS_IMPORT_DATA when the
first row of data is a header that contains column names? For example the
data are orgnized like this:

name,age,weight
bob,17,150
sue,18,120

If not, does anyone know a workaround? I have large data files and
the SYSCS_UTIL.SYSCS_IMPORT_DATA imports data much faster than a prepared
statement.

Thanks

Mime
View raw message