LOAD DATA
INFILE
.txt
INTO TABLE
(
person_id POSITION(1:9) CHAR(9)
surname POSITION(10:34) CHAR(25)
given_names POSITION(35-59) CHAR(25)
)
####
#!/usr/bin/perl
#configuration variables
$lpath="/u04/tmp/log";
$cpath="/u04/tmp/ctl/";
$cfile="control.ctl";
$dirname="/u04/tmp/txt/";
# load the control file data
open(SOURCE, "< $cpath$cfile")
or die "Couldn't open $cpath for reading: $!\n";
@control =