Has there been any reported issues with the “Link SQL file” option when utilizing the select to file activity in automation?
I have queries that are erroring out saying “File_1 - [IBM][System i Access ODBC Driver][DB2 for i5/OS]SQL0104 - Token was not valid. Valid tokens: ( + - ? : DAY INF NAN RID ROW RRN CASE CAST CHAR DATE DAYS HASH.”
When I run the query (which is a .sql) file in editor it works just fine. Also, when I use the Export Wizard for the query it works absolutely fine. Also, I can browse for the .sql file itself and not choose the Link to SQL file and it will run. It seems that the link SQL file selection is what causes the issue.
Also, I’m running into an issue with the delimiter in the select to file. I have the query going to a .csv file and again when I pull it in the editor and manually export or when I pull it using the export wizard, it exports the delimited values just fine, but when I run the query in the select to file (without using the Link SQL file), it delimits wierd and puts ’ ’ around half of the records causing it to delimit out one extra column. When I export as excel it also does just fine. It seems like it’s just an issue with .csv.
I’d really love to use the select to file option for simple .csv or excel without ahving to use the export wizard so I dont have to build a lot of templates.
Just wanted to see if there were known issues or not. I’m attaching a copy of the .sql file. Thanks
Central_Basic_Subs_Camp_Pkg.sql (3.59 KB)