I've written a scheduled agent that uses the DB2 LSX to export data contained in a Notes database to a DB2 database. For some reason, my code is able to connect to the DB2 database just fine. However, when the second statement below:

con.Metadata = "schema.tablename"
Call con.Action ( LCACTION_TRUNCATE )

I get this LSX error:

Error 12545 occurred in INITIALIZE at line 48: Error: Metadata object 'tablename' does not exist, Connector 'db2', Method -Action [Truncate]-

I'm not sure what to do about this error, as the same Lotusscript agent runs fine on a test Notes server when hitting a test DB2 database.

No comments.