SQL query - from the file vs. direct

ykropivykropiv Member Posts: 1 Contributor I
edited December 2018 in Help

Hey everybody,

 

I am using RM 7.6.003. 

I query oracle DB with a query with macros and running into following issue:

- I take my query and paste it directly to RM, it runs fine.

- I save the same query into sql file (utf-8 encoding) and use "query file" as a source. And getting an error "Database error occurred: Non supported SQL92 token at position: ...."

 

Could somebody advise pls?

Tagged:

Answers

  • MartinLiebigMartinLiebig Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert, University Professor Posts: 3,503 RM Data Scientist

    Hi @ykropiv,

    please connect with our professional support team at support.rapidminer.com . Since you have a commercial license you can access this portal. It feels to me that this is rather a question for them.

     

    My best guess: Line ending characters from windows?

    Best,
    martin

    - Sr. Director Data Solutions, Altair RapidMiner -
    Dortmund, Germany
  • Edin_KlapicEdin_Klapic Moderator, Employee, RMResearcher, Member Posts: 299 RM Data Scientist

    Hi @ykropiv,

     

    Does your SQL query include curly {} brackets? Are you using RapidMiner Macros %{} in the query?

    It might be that those are handled differently then used in a file vs. the query editor in RapidMiner ("escaping" is the magic word).

     

    Happy Mining,

    Edin

  • SGolbertSGolbert RapidMiner Certified Analyst, Member Posts: 344 Unicorn

    Hi @ykropiv,

     

    you can try changing the encoding of RM to UTF-8:

     

    Unbenannt.PNG

    Just replace "SYSTEM" with "UTF-8".

     

    Regards,

    Sebastian

Sign In or Register to comment.