I have a text file containing SQL statements. I wish to run this file in DB2 database to execute the statements. The file contains a series of simple row inserts.

eg.
INSERT INTO x (a, b, c, d, e) VALUES ('f', 'g', 'h', 'i', 'j')
INSERT INTO ....
etc.

Can anyone please assist? I aware that there is an 'insert into x from file y' command somewhere.

Thanks.

Put this in a file:

connect to sample;

INSERT INTO x (a, b, c, d, e) VALUES ('f', 'g', 'h', 'i', 'j');
INSERT INTO x (a, b, c, d, e) VALUES ('f', 'g', 'h', 'i', 'j');

connect reset;

The from command window:

db2 -tvf <file-name>

Alternatively, have a look at the "import" command.

italia1980,
if you don't have ";" at the end of each command, you must have each command in its separate row. If so, you can use command:
db2 -f <file-name>