Problem with Execute SQL Operator

david_schwarzdavid_schwarz Member Posts: 2 Contributor I
edited November 2018 in Help

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, Member Posts: 1,761 Unicorn

    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 Member Posts: 2 Contributor I

    Yes it is system, see attachment.

Sign In or Register to comment.