QlikView Direct Discovery Syntax Issue

[#1]

I was trying my hand at Direct Discovery and i ran into some trouble with creating a direct discovery table. When inserting the direct Key-word I get the following error message:

Error -- expected "query", found "SELECT CUSTOMER_ID,
    ID,
    PRODUCT_CODE,
    QUANTITY
FROM PIVOT_TEST"

DIRECT SELECT CUSTOMER_ID,
    ID,
    PRODUCT_CODE,
    QUANTITY
FROM PIVOT_TEST

The Code snippet (for which the error is occuring) is as follows:

CONNECT TO [Provider=OraOLEDB.Oracle.1;Persist Security Info=False;User ID=XXXXXXX;Data Source=XXXXXXXX;Extended Properties=""] (XPassword is SVBFVBFISKReVJFIGKRIVMBa);

DIRECT SELECT CUSTOMER_ID,
    ID,
    PRODUCT_CODE,
    QUANTITY

FROM PIVOT_TEST;

Setting the value for STALE too has no effect, the same error occurs. Any idea why this occurs? On another note, where do I look for information around direct access?

Thanking you in anticipation,

Regards,

Mohit.

[maxgro · Accepted solution]

DIRECT QUERY

dimension

CUSTOMER_ID,
    ID,
    PRODUCT_CODE

measure
    QUANTITY
FROM PIVOT_TEST;

[maxgro]

http://community.qlik.com/blogs/qlikviewdesignblog/2012/11/08/qlikview-112-and-direct-discovery

QlikView Direct Discovery FAQ 11.2_SR5.pdf

http://community.qlik.com/docs/DOC-3710

[#4]

Awesome. Thank you very much.