ETL Problem With Direct Query

[pkpandey]

While using Direct Query in ETL with Qlikview 11.2 SR6 I am getting the error. Please help

Error snapshot and qvw are attached.

P.K.Pandey

[#2]

Hi!

Using SAP connector as a datasource you need to set following environment variables:

SET DirectFieldColumnDelimiter=' ';

SET DirectIdentifierQuoteChar=' ';

Here is the quote from Reference manual:

"For SAP, Direct Discovery can be used only with the QlikView SAP SQL Connector, and it requires the following parameters in SET variables:

SET DirectFieldColumnDelimiter=' ';

SET DirectIdentifierQuoteChar=' ';

SAP uses OpenSQL, which delimits columns with a space rather than a comma, so the above set statements

cause a substitution to accommodate the difference between ANSI SQL and OpenSQL."