Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
We value your feedback – take our 5-minute QlikView modernization survey
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Oracle Loading and Parenthesis Problems

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",

1 Solution

Accepted Solutions
bill_markham
Champion III
Champion III

Put that line as a preceding load above the load

Load

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

    *

;

SQL SELECT "ANT_PART_NO",

    "ANT_PART_NO2",

    "ANT_RELEASE_LEVEL",

    "ANT_RELEASE_LEVEL2",

.... the rest of your sql here ...............

It is a Qlik statement and not SQL so will fail if placed as part of the SQL statement.

View solution in original post

17 Replies
krishnacbe
Partner - Specialist III
Partner - Specialist III

Hi,

can you share the full query to debug the issue.

bill_markham
Champion III
Champion III

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

bill_markham
Champion III
Champion III

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.

bill_markham
Champion III
Champion III

Do you prefix your SELECT with SQL ?

sunny_talwar

Checking now

sunny_talwar

I did

Capture.PNG

bill_markham
Champion III
Champion III

Sunny:  May have been sorted with some QlikView Release

Ian:     What version are you on ?