Import

redwolf · #1 (**permalink**) 08-30-06, 14:40

Is there a way to tell the db2 import utility to skip the last row in an input file?

85I Instance "db2inst1" uses "32" bits and DB2 code release "SQL08022"
with level identifier "03030106".
Informational tokens are "DB2 v8.1.0.89", "special_15295", "U800790_15295", and
FixPak "9".
Product is installed at "/opt/IBM/db2/V8.1".

Peter.Vanroose · #2 (**permalink**) 08-30-06, 15:43

You could use standard unix tools (like "wc -l" and "head -'n'") to pipe all but the last line of that file to a named pipe, then call the "load" or "import" utility with the filename of the named pipe in the FROM clause.
Something like:

Code:

head -$(tail +2 FILE|wc -l) FILE > /tmp/named_pipe & \
db2 import from /tmp/named_pipe of del insert into my_table

Internet Services

Web Development

Digital Marketing

Consumer Tech