topic Re: Using Oracle with clause in Qlikview script in QlikView

Using Oracle with clause in Qlikview script

Wed, 10 Sep 2014 12:45:16 GMT

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

Re: Using Oracle with clause in Qlikview script

Wed, 10 Sep 2014 13:30:39 GMT

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 ;

Re: Using Oracle with clause in Qlikview script

Wed, 10 Sep 2014 13:35:06 GMT

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>

Re: Using Oracle with clause in Qlikview script

Wed, 10 Sep 2014 13:38:13 GMT

Re: Using Oracle with clause in Qlikview script

Wed, 10 Sep 2014 13:40:47 GMT

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

Re: Using Oracle with clause in Qlikview script

Wed, 10 Sep 2014 13:45:18 GMT

Great working fine… Thanks a lot

Re: Using Oracle with clause in Qlikview script

Wed, 10 Sep 2014 13:47:17 GMT

ok gud... where was the problem?

Re: Using Oracle with clause in Qlikview script

Wed, 10 Sep 2014 14:17:18 GMT

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