topic Re: SQL##f - SqlState: S0002, ErrorCode: 4294967092 in QlikView

SQL##f - SqlState: S0002, ErrorCode: 4294967092

qlikviewwizard — Thu, 13 Aug 2015 02:58:36 GMT

Hi All,

I am getting the below message when I run the script. I am using for loop in the script.

SQL##f - SqlState: S0002, ErrorCode: 4294967092, ErrorMsg: [IBM][iSeries Access ODBC Driver][DB2 UDB]SQL0204 - SAL in EMP type *FILE not found.

SQL SELECT *

FROM EMP.SAL

sunny_talwar — Thu, 13 Aug 2015 03:03:15 GMT

sunny_talwar — Thu, 13 Aug 2015 03:04:08 GMT

jagan — Thu, 13 Aug 2015 03:25:28 GMT

Hi,

What is the source of the data? Is it database / Excel file or Access database? I think the error is because there is no file in the given path.

Regards,

Jagan.

qlikviewwizard — Thu, 13 Aug 2015 03:47:41 GMT

Hi All, Thanks for your input.

The reason for the error is because there is no file in the given path.

qlikviewwizard — Thu, 13 Aug 2015 04:48:55 GMT

Yes It is useful. Thank You Sunny.

sunny_talwar — Thu, 13 Aug 2015 04:50:52 GMT

I posted it earlier, but it went into moderation because of external link.

I am glad you found it useful

Best,

Sunny

jagan — Thu, 13 Aug 2015 05:17:31 GMT

Hi,

Check this for loops sample

Hope this also helps you.

Regards,

Jagan.