Discussion Board for collaboration on QlikView Scripting.
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 *
Go to Solution.
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.
May be these threads help: Direct Discovery using DB2 data source
May you help me with the script generator for db2?
And may be this as well: QVD Generator using For..Next Loop in QlikView – Part II - QlikView Blog, QlikView Videos and Tips a...
Hi All, Thanks for your input.
The reason for the error is because there is no file in the given path.
Yes It is useful. Thank You Sunny.
I posted it earlier, but it went into moderation because of external link.
I am glad you found it useful
Check this for loops sample
Load all Excel files and all sheets in a folder
Load Multiple excel sheets using For loop
Hope this also helps you.