db2i (IBM i "Db2 for i" syntax issue.

[bobcozzi]

When using IBM i SQL, there are 2 supported syntaxes for qualified schema/table names.
The period or the forward slash are supported by and used interchangeably.
When the language: 'db2i' is selected, this syntax for the FROM clause should be respected.
Instead of translating
SELECT * FROM qgpl/custfile
to
SELECT *
FROM
qgpl / custfile

It should translate to:
SELECT *
FROM qgpl/custfile

Note that as I mentioned the standard SQL syntax of qgpl.custfile is also supported by Db2 for i.

[nene]

Thanks for pointing out. You might want to report this as an issue though, not just as a discussion. If you do, it would be great if you could provide a link to DB2 docs that mentions this syntax.

Without digging much further, I have to say that this is probably going to be pretty tricky to fix as it seems like a syntax that's hard to distinguish from plain division. For all I know it might be completely context-dependent, in which case the formatter couldn't even tell the difference.