| < Day Day Up > |
|
The additional Web material that accompanies this redbook includes the following files:
convert_load.zip | Perl scripts to convert Oracle control files. Includes: conv_ctl.pl gen_load_update.pl |
data_unload.zip | Shell scripts to unload data from Oracle tables. Includes: data_unload.sh count.awk desc.awk |
db2_emp.zip | Scrips to create DB2 UDB example database. Includes: crtdb.sql - create database crttbs.sql - create tablespaces |
db2bkp.sh | Script to backup DB2 example database |
exp.sh | Script to export Oracle logical DB |
export_table.zip | Sample stored procedure to unload Oracle data. Includes: export_table.sql |
hierarch_query.zip | DB2 UDB functions for recursive SQL. Includes: hierachical_query.fnc |
put_line.zip | Zipped User-define function samples to enable file output from pure SQL for AIX, HP, Linux, Sun Solaris and Windows. Includes: put_lin_readme.pdf put_line_aix.db2v72.tar.Z put_line_aix.db2v81.tar.Z put_line_hpux.db2v72.tar.Z put_line_solaris.db2v72.tar.Z put_line_linux.db2v72.tar.Z put_lin_w2k.ZIP |
ora_emp.zip | Scrips to create Oracle example database. Includes: 01_ora_emp_create_tbs.sql 02_ora_emp_create_user.sql 10_ora_emp_build_all.sql 11_ora_emp_seq.sql 12_ora_emp_tables.sql 13_ora_emp_fk.sql 14_ora_emp_views.sql 15_ora_emp_proc.sql 16_ora_emp_trigger.sql 17_ora_emp_indexes.sql 21_ora_emp_drop_fk.sql 22_ora_emp_drop_trigger.sql 23_ora_emp_drop_tables.sql 24_ora_emp_drop_indexes.sql accounts.ctl accounts.dat db2_emp.zip departments.ctl departments.dat employees.ctl employees.dat emp_photo.ctl emp_photo.dat emp_resume.ctl emp_resume.dat offices.ctl offices.dat readme.txt |
The following system configuration is recommended:
Hard disk space: | 5 MB minimum |
Operating System: | Windows 2000 |
Processor: | Intel 386 or higher |
Memory: | 16 MB |
To download to AIX Linux or UNIX, use the equivalent or higher system capacity as specified for Windows
Create a subdirectory (folder) on your workstation, and unzip the contents of the Web material zip file into this folder. Ftp to the proper platform.
| < Day Day Up > |
|