Skip to content

Language DB2 format with $ failed #203

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Closed
derPeterson opened this issue Apr 26, 2022 · 1 comment
Closed

Language DB2 format with $ failed #203

derPeterson opened this issue Apr 26, 2022 · 1 comment
Labels

Comments

@derPeterson
Copy link

derPeterson commented Apr 26, 2022

I have specified db2 language and have a select, the values with $ characters, are separated by whitespaces, which leads to SQL error....

SELECT * FROM TABLENAME AS C WHERE C.CLASSID IN $P{CLASSID} AND C.OID IN $P{OID} $P{INCLUDE}

Format Result:

SELECT * FROM TABLENAME AS C WHERE C.CLASSID IN $ P { CLASSID } AND C.OID IN $ P { OID } $ P { INCLUDE }

I'm not a DB2 expert, but my DBeaver tool formats the $ correctly and leaves them as they were....

Thanks already for the help and for the free library, otherwise it works great.

@nene nene added the bug label May 12, 2022
@nene
Copy link
Collaborator

nene commented May 12, 2022

This should now be fixed in 6.0 release.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

2 participants