Union operator problem
Posted: Thu Apr 09, 2009 4:05 am
Hi Friends,
When i generated Union script in ODBC connector its showing the failure message. Please can check this one is correct or want to write some other way.
below are the errors
IIS-CONN-ODBC-000004] ODBC function {0} reported: SQLSTATE = 42S02: Native Error Code = 208: Msg = [IBM (DataDirect OEM)][ODBC SQL Server Driver][SQL Server]Invalid object name 'dbo.SR_MVGB_OCUSMA'.
SR_MVDE_OCUSMA,0: [IIS-CONN-ODBC-000004] ODBC function {0} reported: SQLSTATE = 42000: Native Error Code = 8 180: Msg = [IBM (DataDirect OEM)][ODBC SQL Server Driver][SQL Server]Statement(s) could not be prepared. (CC_OdbcDBStatement::executeSelect, file CC_OdbcDBStatement.cpp, line 1 140)
Script
SELECT OCUSAD.OPCUNO,
OCUSAD.OPADID,
OCUSAD.OPCUNM,
OCUSAD.OPCUA1,
OCUSAD.OPCUA2,
OCUSAD.OPCUA3,
OCUSAD.OPCUA4
FROM
dbo.SR_MVGB_OCUSAD AS OCUSAD
UNION
SELECT TR_UK_SLS_CUA_CD001.SAP_DESC,
TR_UK_SLS_CUA_CD001.SAP_VALUE
FROM
dbo.TR_UK_SLS_CUA_CD001;
When i generated Union script in ODBC connector its showing the failure message. Please can check this one is correct or want to write some other way.
below are the errors
IIS-CONN-ODBC-000004] ODBC function {0} reported: SQLSTATE = 42S02: Native Error Code = 208: Msg = [IBM (DataDirect OEM)][ODBC SQL Server Driver][SQL Server]Invalid object name 'dbo.SR_MVGB_OCUSMA'.
SR_MVDE_OCUSMA,0: [IIS-CONN-ODBC-000004] ODBC function {0} reported: SQLSTATE = 42000: Native Error Code = 8 180: Msg = [IBM (DataDirect OEM)][ODBC SQL Server Driver][SQL Server]Statement(s) could not be prepared. (CC_OdbcDBStatement::executeSelect, file CC_OdbcDBStatement.cpp, line 1 140)
Script
SELECT OCUSAD.OPCUNO,
OCUSAD.OPADID,
OCUSAD.OPCUNM,
OCUSAD.OPCUA1,
OCUSAD.OPCUA2,
OCUSAD.OPCUA3,
OCUSAD.OPCUA4
FROM
dbo.SR_MVGB_OCUSAD AS OCUSAD
UNION
SELECT TR_UK_SLS_CUA_CD001.SAP_DESC,
TR_UK_SLS_CUA_CD001.SAP_VALUE
FROM
dbo.TR_UK_SLS_CUA_CD001;