I know that we can use import or load to truncate tables without
filling up trans log in DB2. Is it possible to do this in a stored
procedure? How about in CLI/C++? My impression is that import/load
are not SQL statements, hence may not be included in stored procs or
called from CLI. Is that correct? I tried to use import/load in a
stored proc and they were rejected as syntax errors.
If it is the case, we'd have only one option, that is, to call the
import/load commands from command line. I'd be surprised if this is
true since it is such a useful feature, and I hope there is a way
around?
Thanks!