Run DB2 script in Linux

Because of the different versions of DB2, The Script File Syntax is also different. Even redundant spaces may cause runtime errors.

In recent experiments, DB2 v9.5 and v9.7 encountered many strange problems when running the SQL files created by databases and tables.

Question 1. When creating tarigger, the statement must be written in one line .()

Problem 2. v9.5 does not support the create or replace syntax

Problem 3. There cannot be any extra space between language SQL reads SQL data no external action deterministic (v9.5 exists, v9.7 is normal ).

Basic Linux operations:

Database Operation: force application all;

Drop database dbname;

Su-db2inst

Db2-tvf/tmp/data_init_sprintIV. SQL