Problem with Execute SQL Operator

david_schwarz
david_schwarz New Altair Community Member
edited November 2024 in Community Q&A

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_Ott
    Thomas_Ott New Altair Community Member

    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_schwarz
    david_schwarz New Altair Community Member

    Yes it is system, see attachment.

Categories