Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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."