Beginner - SQL LOAD in QVD

QlikBeginner1 — Tue, 28 Dec 2021 20:10:07 GMT

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!

Re: Beginner - SQL LOAD in QVD

dplr-rn — Wed, 16 Sep 2020 16:25:14 GMT

shouldnt there be quotes around the string value in where clause

CoverageTypeDescription= 'Employers Liability'

topic Beginner - SQL LOAD in QVD in Connectivity & Data Prep

Beginner - SQL LOAD in QVD

Re: Beginner - SQL LOAD in QVD