Re: iNav Sql scripts

[Paul Tuohy <tuohyp@xxxxxxxxxxxxxxxxx>]

Both SYSCOLUMNS and QSYS/QADBIFLD also have the text for the columns.

Regards

Paul Tuohy
ComCon
www.comconadvisor.com 
www.systemideveloper.com 





David FOXWELL wrote:
> Sorry, I think I should have said TEXT instead of Column headings. The display you get when you use STRSQL. Our tables still have 6 letter field names so the output in iNav isn't really human readable. 
> Thanks for the SQL Assist tip that I did not know existed.
>
>
>
>
>
>
>   
> > -----Message d'origine-----
> > De : midrange-l-bounces@xxxxxxxxxxxx 
> > [mailto:midrange-l-bounces@xxxxxxxxxxxx] De la part de Paul Tuohy
> > Envoyé : mardi 28 décembre 2010 14:28
> > À : Midrange Systems Technical Discussion
> > Objet : Re: iNav Sql scripts
> >
> > You can use SQL Assist (Edit->SQL Assist or press F4 on a blank line).
> >
> > Or just do a select * from table and have a look at the 
> > headings in the result set.
> >
> > Or, if you are using a schema, run a SELECT on the SYSCOLUMNS 
> > view in the schema with a where clause on TABLE_NAME.
> >
> > Or, if you are not using a schema, run a SELECT on 
> > QSYS/QADBIFLD with a where clause selection on DBILIB and DBIFIL
> >
> > Regards
> >  
> > Paul Tuohy
> > ComCon
> > www.comconadvisor.com
> > www.systemideveloper.com 
> >  
> >