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

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?

Hello,

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

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.