🎉Community Raffle - Win $25

An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.

Join and Win

Problem with Execute SQL Operator

david_schwarz

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

Find more posts tagged with

AI Studio

SQL

Accepted answers

All comments

Thomas_Ott

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

Yes it is system, see attachment.

setting.PNG