Re: SQL Naming Conventions

I use a function like these on the host which return a delimited list of
columns for a table -

https://drive.google.com/open?id=0B86kLoHq8E_PcHJ3YUJCRVR6dk0

To make it fast and easy to use, I call it from a Microsoft Access custom
UI screen that prompts for a System Name, Schema Name, Table Name, with a
check box to turn on/off copying the result fetched from the host UDTF into
the clipboard. The copy to clipboard check box is turned on by default.
Once on the clipboard, I paste it into whatever editor I'm using at the
time. I'm not impressed with Access as a database, but it works very well
for rapidly creating tool user interfaces to access the IBM i host.