var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: clp - run a external sql file
I have to say I am sorry in advance for asking such a basic question but I could not find it through a search.
From the DB2 CLP how do I run a external .sql file?
db2 -tvsf <filename>
This assumes that the statement are terminated by a semicolon (.
If you have something else as a terminator (e.g. the @ sign):
db2 -td@ -svf <filename>
If you are in the db2 prompt, then you may do
db=>!db2 -td@ -svf <filename>
Visit the new-look IDUG Website
, register to gain access to the excellent content.