-- **----------------------------------------------------------**
-- ** Creates DB2 table for TESTER user to store binary files  **
-- **                                                          **
-- ** Download4J/DB2 7.2 sample script.                        **
-- ** http://www.javazoom.net/jzservlets/download4j/           **
-- ** Copyright JavaZOOM 1999-2002.                            **
-- **----------------------------------------------------------**
-- drop table TESTER.DOWNLOAD;

create table TESTER.DOWNLOAD (
  FILENAME varchar(255) NOT NULL,
  BINARYFILE blob(2M) NOT NULL,
  primary key(FILENAME));

-- Insert 4 files available in c:\temp\ an listed in c:\temp\files_db2.txt
import from c:\temp\files_db2.txt of del lobs from c:\temp\ modified by lobsinfile commitcount 1000 insert into TESTER.DOWNLOAD (FILENAME, BINARYFILE);
-- Tests have been successfully made with big (more than 50MB) files