Using Oracle with clause in Qlikview script

[#1]

Hi,

I tried load below  Oracle with clause in QV scrpit

SET ThousandSep=',';

SET DecimalSep='.';

SET MoneyThousandSep=',';

SET MoneyDecimalSep='.';

SET MoneyFormat='$#,##0.00;($#,##0.00)';

SET TimeFormat='h:mm:ss TT';

SET DateFormat='M/D/YYYY';

SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT';

SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';

SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

ODBC CONNECT32 TO [YYYYYYY;DBQ=XXXXXX] (XUserId is ZfQKZZFMHLdEXaBOYG, XPassword is UHdFJVVOMLeADZAU);

LOAD

WITH DATE AS

(SELECT SYSDATE FROM DUAL)

SELECT SYSDATE FROM DATE ;

It is not loading and trowing the attached error

[#2]

try with this

replace LOAD with SQL

ODBC CONNECT32 TO [YYYYYYY;DBQ=XXXXXX] (XUserId is ZfQKZZFMHLdEXaBOYG, XPassword is UHdFJVVOMLeADZAU);

SQL

  WITH DATE AS

(SELECT SYSDATE FROM DUAL)

SELECT SYSDATE FROM DATE ;

[#3]

Tried , still same error continues…

Qlik Community<http://community.qlik.com/>

Using Oracle with clause in Qlikview script

reply from gurjeet singh<http://community.qlik.com/people/gursingh0001?et=watches.email.thread> in New to QlikView - View the full discussion<http://community.qlik.com/message/606466?et=watches.email.thread#606466>

[#4]

[#5]

i create string connect with system DSN.

i think here is the difference of our connection string

so check ur connection string and connect again from scratch after clear your script editor

[#6]

Great working fine… Thanks a lot

[#7]

ok gud... where was the problem?

[#8]

I used restricted word "DATE" as table name. It is on oracle side, since I am new to QV got confused.