This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.

Learn more
I AGREE
community Data Science Portal alteryx .com community Data Science Portal alteryx .com community
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Alteryx Server Ideas

Share your Server product ideas - we're listening!
Submitting an Idea?

Be sure to review our Idea Submission Guidelines for more information!

Submission Guidelines

iSeries In-DB SQL Statement

Status: New Idea Submitted by on ‎10-15-2020 03:41 AM
2 Comments (2 New)

When using In-DB with iSeries over Generic ODBC everything works fine in Designer however when executing via Gallery process fails because a semi-colon ";" is added to the SQL statement as a terminator character and iSeries rejects this SQL0104 - Token ; was not valid. Valid Values < END OF STATEMENT > 

See more ideas labeled with:
0 Likes
2 Comments
tfrendo
5 - Atom
‎10-15-2020 03:42 AM

We have raised this as an error with support and they have directed us to suggest this as an idea as the iSeries is not officially supported for In-DB connection.

KylieF
Moderator
Moderator
‎10-20-2020 01:11 PM

Thank you for your idea!

 

We appreciate the feedback provided on how we could better improve our product. Since it looks like this is your first idea posted, I would recommend checking out our Submission Guidelines as it goes over the idea process in a bit greater detail.