Re: iNav Sql scripts

Interesting. It works with STRSQL but not with iNav... (I use iNav a lot,
only that I think in terms of column names).

I can't find a way to show column headings with iNav either so, unless you
create a view for the table(s) you want to process (kludgy, I know) it seems
you are out of luck in this case.

I'll try to dig a little more, but don't hold up your breath :-)


Regards,

Luis Rodriguez
IBM Certified Systems Expert — eServer i5 iSeries
--



On Tue, Dec 28, 2010 at 10:31 AM, David FOXWELL <David.FOXWELL@xxxxxxxxx>wrote:

Thanks Luis,

Google on 'sql label on' hits this in first position :

http://publib.boulder.ibm.com/infocenter/iseries/v5r4/index.jsp?topic=%2Frzatc%2Frzatclabelon.htm

and a nice, gentle chapter called Getting started with sql. I can change
column headings at will, and they show up in a DSPFFD.
But not in iNav! :-(

-----Message d'origine-----
De : midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] De la part de Luis Rodriguez
Envoyé : mardi 28 décembre 2010 15:37
À : Midrange Systems Technical Discussion
Objet : Re: iNav Sql scripts

David,

IIRC, Column headings default to column name AND when you do
a SELECT it only shows column headings so, as I see it, you
would need to change your headings (LABEL ON) for that.

Regards,

Luis Rodriguez
IBM Certified Systems Expert - eServer i5 iSeries

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.