Problem with Execute SQL Operator

david_schwarzdavid_schwarz MemberPosts:2Contributor I
edited November 2018 inHelp

Hi Community

I want to run some SQL Code with Execute SQL.
If I copy & past the code everything is working but if i read the code from file (attached as a csv, I saved codef in VisualStudio and saved the file as a .sql file) i get the following error:

Datbase error occured: Incorrect syntax near '>>' (see attached picture, i can't type it properly...)
Is this a problem with my file-encoding?

Cheers,
David

Tagged:

Answers

  • Thomas_OttThomas_Ott RapidMiner Certified Analyst, RapidMiner Certified Expert, MemberPosts:1,761Unicorn

    My initial thought is that it could be an encoding issue. Can you verify what the encoding is for RapidMiner (Settings > Preferences). The default is "System" which sets it to system's encoding where the process runs.

  • david_schwarzdavid_schwarz MemberPosts:2Contributor I

    Yes it is system, see attachment.

    setting.PNG 29.5K
Sign InorRegisterto comment.