Hello! I am trying to do a sql load in a QVD with a where clause, I have done this before and it works however now its coming up with an error saying:
Connector reply error: SQL##f - SqlState: 42000, ErrorCode: 102, ErrorMsg: Incorrect syntax near 'Liability'.,
[TDWH_Coverage_S01]:
SQL SELECT [ID]
,[FD]
,[TD]
,[CoverageExpiryDate]
,[CoverageCancellationDate]
,[LineOfBusiness]
,[CoverageStatusCode]
,[CoverageStatusDescription]
,[CoverageSourceSystemCode]
,[CoverageSourceSystemName]
,[CoverageTypeCode]
,[CoverageTypeDescription]
,[PolicyNumber]
,[ConfCoverageTypeCode]
,[ConfCoverageTypeDesc]
,[PolicyHeader]
,[CoverageDeletedFlag]
,[CoverageEffectiveDate]
,[LegalEntity]
,[RUNNO_INSERT]
,[RUNNO_UPDATE]
FROM [GBQPS1SDA01DWHPOASL].[pol]."TDWH_Coverage_S01"
where YEAR(TD) = 9999 and CoverageTypeDescription= Employers Liability;
This is the code that is in the QVD which is now coming up with a incorrect syntax? the where clause for YEAR(TD) = 9999 is working, any help would be appreciated.
Thanks Community in advance!
