Invalid object name 'MetaStage_Loc_Info'
Posted: Mon Sep 12, 2005 12:33 pm
There are a couple of topics that mention this error, but no one seems to answer the question, "Why does DataStage generate the following SQL Statement?".
SELECT DISTINCT "Computer", "SoftwareProduct", "DataStore" FROM MetaStage_Loc_Info
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'MetaStage_Loc_Info'.
It seems to be an unnecessary overhead. Does anyone know what triggers DataStage to make this call, and whether or not there is a way to tell it not to?
Thanks in advance,
Heather
SELECT DISTINCT "Computer", "SoftwareProduct", "DataStore" FROM MetaStage_Loc_Info
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'MetaStage_Loc_Info'.
It seems to be an unnecessary overhead. Does anyone know what triggers DataStage to make this call, and whether or not there is a way to tell it not to?
Thanks in advance,
Heather