sql

[upaliwije]

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

[stabben23]

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?

[upaliwije]

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

[stabben23]

Does the script reload at all?

[upaliwije]

It reloads with 0 results

[stabben23]

What if you just run this:

SQL SELECT *

FROM CICL."UPL_CLM_SCH"

;

[mayankraoka]

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

[upaliwije]

If I run the following data getting loaded

SQL SELECT *

FROM CICL."UPL_CLM_SCH"

where YEAR='2015';

[stabben23 · Accepted solution]

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

and MONTH1 IN (1, 2, 3)

[upaliwije]

Thanks It works