DB2 ODBC Driver invalid token issue

More
3 years 11 months ago #21941 by ashokv
Every time we edit or run any transformation in the ETL tool, we get an error message 42000 IBM system i access ODBC Driver DB2 for i5/OS sql0104 - Token< was not valid. Valid tokens: NEW FINAL TABLE UNNEST LATERAL XML TABLE JSONTABLE < IDENTIFIER>. All transformation working fine until we upgrade ETL Tool Version:6.3.10.7. Currently we are using ETL Tool Version:6.3.10.7,
Attachments:

Please Log in or Create an account to join the conversation.

More
3 years 11 months ago #21942 by admin
Try setting the driver to ANSI and let us know the outcome


Mike
ETL Architect
Attachments:

Please Log in or Create an account to join the conversation.

More
3 years 11 months ago #21954 by ashokv
Getting same error when I change odbc setting to Ansi driver.
Please let me know how to fix DB2 ODBC Driver invalid token issue.
Attachments:

Please Log in or Create an account to join the conversation.

More
3 years 11 months ago #21955 by admin
You might have an Error in your SQL statement
www.ibm.com/docs/en/i/7.2?topic=se-sql01...valid-valid-tokens-2

Have you tried running it in any other tools?

Mike
ETL Architect

Please Log in or Create an account to join the conversation.

More
3 years 11 months ago #21956 by ashokv
There is no error in any transformations sql . I ran transformations sql in the Winsql tool without any errors.
I get DB2 ODBC Driver invalid token issue when I edit any transformation or run any transformation in the Advance ETL processor tool.
All transformations work fine until we upgrade ETL Tool Version:6.3.10.7.

Please Log in or Create an account to join the conversation.

More
3 years 11 months ago #21957 by admin
We would like to connect remotely and investigate.

Please email us connection details

Mike
ETL Architect

Please Log in or Create an account to join the conversation.

Cookies user preferences
We use cookies to ensure you to get the best experience on our website. If you decline the use of cookies, this website may not function as expected.
Accept all
Decline all
Read more
Marketing
Set of techniques which have for object the commercial strategy and in particular the market study.
Google
Accept
Decline
Analytics
Tools used to analyze the data to measure the effectiveness of a website and to understand how it works.
Google Analytics
Accept
Decline
Google Analytics
Accept
Decline
Functional
Tools used to give you more features when navigating on the website, this can include social sharing.
Advertisement
If you accept, the ads on the page will be adapted to your preferences.
Google Ad
Accept
Decline
Save