Oracle Loading and Parenthesis Problems

[#1]

I get the following error when I add the //line into the load script below.

SQL##f - SqlState: 37000, ErrorCode: 907, ErrorMsg: [Microsoft][ODBC driver for Oracle][Oracle]ORA-00907: missing right parenthesis

Can anyone help please?

SQL SELECT "ANT_PART_NO",

    "ANT_PART_NO2",

    "ANT_RELEASE_LEVEL",

    "ANT_RELEASE_LEVEL2",

    "ANT_SITE",

    "ANT_SITE2",

    COMMENTS,

    "CREATED_BY",

    "CREATED_DATE",

    "CREATED_REASON_CODE",

    "CREATED_REASON_TEXT",

    "CUSTOMER_INSTALL",

    "CUSTOMER_NO" AS NOTIFMCUSTNOS,

    "CUSTOMER_REFERENCE",

    "CUSTOMER_SIGN_DATE",

    DATA,

    "ENG_ACTUAL_FINISH",

    "ENG_ACTUAL_START",

    "ENG_ASSIGNED_CODE",

    "ENG_BILLABLE_TIME",

    "ENG_ORIGINAL_CODE",

    "ENG_PLANNED_START",

    "ENG_PO_NO",

    "FM_VEHICLE",

    "INSTALLATION_DATE",

    INVOICED AS NOTIFMASINVCED,

    "LAST_AMENDED_BY",

    "LAST_AMENDED_DATE",

    "LEASE_END_DATE",

    "LEASE_PERIODS",

    "LEASE_START_DATE",

    "LINKED_TO",

    "LINKED_TO_SERVICE",

    "LOC_ID_NUMBER",

    //IF (LEFT("LOC_ID_NUMBER",2) = '1.','DT','FM') AS "DATABASE",

    "LOC_PART_NO",

[krishnacbe]

Hi,

can you share the full query to debug the issue.

[Anonymous]

The // is a Qilk comment not a SQL comment, try deleting the line.

[sunny_talwar]

This is not the complete query, right? I don't see any issue in what you have provided, may be if you can paste the rest of the query it might help

[Anonymous]

or use a SQL comment, usually --

or the /*  */ comment style

[sunny_talwar]

Bill I think QlikView style commenting does work in SQL code. I have been running a code with // commenting and it seems that it works for me.

[Anonymous]

Do you prefix your SELECT with SQL ?

[sunny_talwar]

Checking now

[sunny_talwar]

I did

[Anonymous]

Sunny:  May have been sorted with some QlikView Release

Ian:     What version are you on ?