On Aug 12, 8:53 am, "Mark A" <nob...@nowhere.comwrote:
"Serge Rielau" <srie...@ca.ibm.comwrote in message
news:5i*************@mid.individual.net...
Mark I added the -td option to db2look myself in DB2 V7.2 to support SQL
functions. If you don't use it db2look will actually append a -- to each
line with a semicolon at least for triggers and functions.
(That should be changed to --#SET TERMINATOR)
Cheers
Serge
Thanks for that tip. I never noticed that in the doc.
Hi,
Can we take a dump/backup of a schema with the following db2move
command.
db2move <DB_NAMEexport -tc <SCHEMA_NAME>
It gives the ixfs of all the tables and db2look for the other db
objects.
Since you didn't suggest it, i assume that this will miss something.
What could be the problem with taking a dump like this.
Thanks again
Rahul