topic Re: sql in QlikView

sql

upaliwije — Thu, 20 Apr 2017 06:23:40 GMT

Dear Friends,

I have following script in data load syntax

SQL SELECT *

FROM CICL."UPL_CLM_SCH"

where YEAR='2015'

and MONTH1 IN('1','2','3')

But no records is loaded to QV document though data appear when I run the sql in SQL navigator. Can you pls show me where I have made the error

Re: sql

stabben23 — Thu, 20 Apr 2017 06:28:13 GMT

Should work, the only thing is ; at the end of the script.

SQL SELECT *

FROM CICL."UPL_CLM_SCH"

where YEAR='2015'

and MONTH1 IN('1','2','3')

;

Do you have a Connect to the database?

Re: sql

upaliwije — Thu, 20 Apr 2017 06:31:01 GMT

Yes I have out ; in my document. Still it does not work

Re: sql

stabben23 — Thu, 20 Apr 2017 06:34:19 GMT

Does the script reload at all?

Re: sql

upaliwije — Thu, 20 Apr 2017 07:18:30 GMT

It reloads with 0 results

Re: sql

stabben23 — Thu, 20 Apr 2017 07:21:58 GMT

What if you just run this:

SQL SELECT *

FROM CICL."UPL_CLM_SCH"

;

Re: sql

mayankraoka — Thu, 20 Apr 2017 07:22:08 GMT

Hi Upali,

To cross check can you please reload the application without where condition?If you are getting data can you post sample qvw here.

Regards,

Mayank

Re: sql

upaliwije — Thu, 20 Apr 2017 07:46:57 GMT

If I run the following data getting loaded

SQL SELECT *

FROM CICL."UPL_CLM_SCH"

where YEAR='2015';

Re: sql

stabben23 — Thu, 20 Apr 2017 08:09:25 GMT

OK, try to modify this part then, remove ' sign and see if that helps.

and MONTH1 IN (1, 2, 3)

Re: sql

upaliwije — Thu, 20 Apr 2017 08:21:07 GMT

Thanks It works