Sybase 12.5.1, Руководство пользователя

Страница: 115 / 210

CHAPTER 5 Data Files
User’s Guide
101
device_name varchar (255) null,
device_reads_val int null,
device_writes_val int null,
device_io_val int null,
)
go
4 After the recording session is complete, you can use
bcp
to import data
from the view’s data file into the database table. Use the following
commands:
bcp pubs2..device_io in d1_1_device_io -c
-e d1_1_device_io.err -U username
-P password -S server -t
Cut utility example
If you are on a UNIX machine, you can put subsets of the fields from data files
into separate Adaptive Server tables if you first invoke the
cut
utility to strip
and save the desired columns from the file. Use the following command:
cut -f list -d, view_data_file > output_file_name
where:
• list is a comma-separated list of the field numbers that you want to cut and
save from the original view data file. The first field has field number 1.
• view_data_file is the name of the file where all of the recording data is
stored.
• output_file_name is the name of the file where the stripped data is to be
stored.
After using
cut
, you can use the
bcp
utility to import the data in the
output_file_name into an Adaptive Server table. Historical Server might return
lines to the view_data_file that are similar to:
1995/3/25 10:32:39,master,0,0,0
1995/3/25 10:32:39,sysprocsdev,0,0,0
1995/3/25 10:32:39,ANewDBDevice,0,0,0
1995/3/25 10:32:39,ATestDevice,0,0,0
1995/3/25 10:32:40,master,0,0,0
1995/3/25 10:32:40,sysprocsdev,0,0,0
1995/3/25 10:32:40,ANewDBDevic,0,0,0
1995/3/25 10:32:40,ATestDevice,0,0,0