SQL query - from the file vs. direct

ykropiv

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?

MartinLiebig

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