Re: Create SQL Table With Labels

[Brian Johnson <brian.johnson.mn@xxxxxxxxx>]

On Fri, Mar 27, 2009 at 4:24 PM, RWMunday <RWMunday@xxxxxxxxxxxxx> wrote:

> I have been assigned to create some files, but instead of going native we
> are to create them as SQL tables.  I am trying to imitate what I can of the
> DDS TEXT and COLHDG which I put in every DDS for a PF I create.  Query is
> much easier to use as a tool when those two elements are defined.
>
> I looked on the IBM site for SQL tables and the LABEL ON option looked
> good.
> However, my system didn't like it.
>
> Do you have an example of an SQL table create using labels or whatever I
> need to use to replicate what I can do in DDS?
System i Navigator is an excellent tool for this.  Navigate the tree down to
Databases/Schemas/.../Tables.  Select a table, right-click and select
Generate DDS.  You will see how use LABEL ON for file and field text and
column headings.