Execute Query: ERROR [42000] [IBM][System i Access ODBC Driver][DB2 for i5/OS]SQL0104

[radu.spantu]

Hello guys,

I am having a process that at some point has to do some validations using SQL.
I created a small process “Connect to database” to output a database connection that looks like the picture below

The output is a database connection and it is not null ( “out_dbConnection”: “UiPath.Database.DatabaseConnection”, ) .

I am passing this argument to another xaml that does the actual query.
When the query is executed, i get the following error: “Execute Query: ERROR [42000] [IBM][System i Access ODBC Driver][DB2 for i5/OS]SQL0104 - Token ; was not valid. Valid tokens: .”

I’m not sure how to advance with this.

Any suggestions?

[radu.spantu]

Hello,

My issue was a semicolon ( ; ) in the query i was using.
After removig the semicolon, everything works fine.