DB2 Load Data From File

greenspun.com : LUSENET : DBAzine : One Thread

Hi there,

How to load the data from a file by skipping the header and footer by using LOAD. As refer to DB2 documentation, I couldn't find the option to do so. Instead, I found RESTARTCOUNT for IMPORT where it can skips the no of lines that we have specified, which may works for skipping the header but not footer. But the RESTARTCOUNT is not included in the LOAD. What can I do then?

Thank you for your help.

Regards, Celine

-- Celine Chan (kuiheong@yahoo.com), February 07, 2003


Well, sometimes a simple solution can work the best. Have you thought about editing the file to remove the footer (and header if possible). If these are required for other applications, just create a copy of the file without the header/footer for loading to DB2.

-- Craig S. Mullins (craig_mullins@bmc.com), March 17, 2003.

Moderation questions? read the FAQ