Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
May be these threads help: Direct Discovery using DB2 data source
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.
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
Best,
Sunny
Hi,
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.
Regards,
Jagan.