How do I modify the generated SQL from the Db2 for i extension

[JonFP]

The default SELECT * ... is great for small test files - but sometimes I want to add a WHERE close or something. However, when I do I just get syntax errors even when I know the syntax is fine.

What am I missing?

[worksofliam]

I'm curious as to what error you're getting. Are you able to share any screenshots?

[JonFP]

There you go.

If I complete the clause anyway and press the "Play" button I get this:

In fact I get that error even if the syntax is accepted e.g. replace the text with (say) SELECT * FROM PARTNER400.CATEGOR

[worksofliam]

Looks like a bug on my end. Will let you know when it's fixed.

[worksofliam]

@JonFP

The validator isn't perfect. It's a Db2 validator and not specific to Db2 for i. I wonder if it was erroring because you had some special characters in your column names (which I don't think Db2 LUW likes?). You can turn off the validator in the VS Code settings for the Db2 extension.

Seems the play button is bugged and I am working on that now, but in the meantime the shortcut (Control / Command + R) does work to run a statement!

[worksofliam]

@JonFP Update the Db2 for IBM i extension (vscode-db2i) to 0.2.1 and the problem should be resolved. Thanks!

[JonFP]

Seems to still be a bit flakey but it sorta works. Will try to be more definitive when I've had more time to play.
When I first tried to add a WHEN clause it just produced no output. Then tried an ORDER BY and that worked. So tried a WHERE again - no joy until in desperation I used double quotes instead of single around the comparison value. That was errored as expected but when I then corrected it back to single quotes the statement ran correctly and continued to do so. Go figure.

[JonFP]

Nope - the names are as vanilla as you can get. Jon Paris ***@***.***

…

On Jul 10, 2022, at 8:57 AM, barry ***@***.***> wrote: @JonFP <https://github.com/JonFP> The validator isn't perfect. It's a Db2 validator and not specific to Db2 for i. I wonder if it was erroring because you had some special characters in your column names (which I don't think Db2 LUW likes?). You can turn off the validator in the VS Code settings for the Db2 extension. Seems the play button is bugged and I am working on that now, but in the meantime the shortcut (Control / Command + R) does work to run a statement! — Reply to this email directly, view it on GitHub <#739 (reply in thread)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ADGZWQOOAWFMOUH7OEZANNTVTLCCNANCNFSM53D7IQEA>. You are receiving this because you were mentioned.