Diagnostics
Problem
The wrong table name is created when using ON TABLE HOLD FORMAT SQLMSS. The table is given the schema value specified by the HOLD statement instead of the intended table name. The table is also created in the adapter connection's default schema instead of the intended schema.
For example, the following is creating a table named schema1 with the schema of dbo instead of creating tablename1 in schema1.
ON TABLE HOLD AS schema1.tablename1 FORMAT SQLMSS
Solution
The proper syntax for creating HOLD files in an Relational Database Management System is to use the TABLENAME keyword. For example:
ON TABLE HOLD AS appname/mastername FORMAT SQLMSS TABLENAME schema1.tablename1
TABLENAME identifies the table or view. It may contain the owner ID, as well as the table name. For some synonyms, it must also contain the data source name. This value may be a variable.