Re: SQL Naming Conventions

On 2/29/2016 10:17 AM, Vernon Hamberg wrote:

Buck - I think he refers to the Navigator tool or maybe the one in ACS.

I've been using that for many years. I keep my SQL scripts on the IFS,
and opening a .SQL file with Windows File Explorer starts the ACS SQL
Script program. However, copying a column of column names into an RPG
program, to be used for say, a FETCH data structure, is kind of ugly.

Since this is the RPG list, I was sort of hoping that Mike had a tool
that would maybe generate such an RPG structure for him. And me :-) Or
a tool to do any of the things that an RPG programmer would like to do
with a list of column names...

On 2/29/2016 8:09 AM, Joe Roden wrote:

IBM i Run SQL Scripts

Select system_column_name, column_name, data_type, dds_type, length,
numeric_scale, column_text, column_heading, table_schema, table_name
From QSYS2.SYSCOLUMNS2
Where table_name = 'MyFile' and table_schema = 'MyLibrary';

--------------------------------------------
On Sun, 2/28/16, Buck Calabro
<kc2hiz@xxxxxxxxx> wrote:

> Developers should have efficient tools to fetch a
> the list of columns from a table, so they can copy/paste them
instead of
> keying them.
This is a great idea; what do you use?