Interesting that they added the ALIAS to facilitate query tools. Surely the
TEXT keyword would have been far more useful. Not on my iSeries right now,
but know for sure that it is the TEXT that displays in QUERY, and not sure
for SQL.

----- Original Message -----
From: "Paul Nelson" <>
To: <>
Sent: Sunday, January 06, 2002 6:20 PM
Subject: Re: V5R1 Printer File CPD5237 Problem (was: What's this all about?)

> I understand what you're saying, but this file was not created with SQL.
> was created with DDS and compiled. The alias keywords were added to
> facilitate use with query tools. The irritating thing is that I was just
> trying to recompile a printer file, for crying out loud.
> I guess I'll stick to the systems management stuff and leave the
> (and all the extra keying) to you youngsters who can type faster than
> of us who are "digitally challenged".  :-)))
> Paul Nelson
> Braxton-Reed, Inc.
> 877-777-2729 Office
> 630-327-8665 Cell
> 708-923-7354 Home
> ----- Original Message -----
> From: "Paul Tuohy" <>
> To: <>
> Sent: Sunday, January 06, 2002 5:20 PM
> Subject: Re: V5R1 Printer File CPD5237 Problem (was: What's this all
> > Paul,
> >
> > Please, don't go back to internal definitions. As Robin said, you should
> be able
> > to override the ALIAS in the print file.
> > Also, as Robin said, this is the way it has always worked. But in the
> past, we
> > never bothered defining an ALIAS for a field unless our application was
> using
> > Cobol (since RPG only allowed six character field names it wasn't even
> using the
> > full ten allowed in DDS, so why bother with ALIAS).
> >
> > The difference now is SQL. When you create a file with SQL the Column
> is
> > the Alias and the Internal Field Name is the Field name we would define
> DDS.
> >
> > SQL is getting there but it still has a little way to go - maybe with
> :-)
> >
> > Paul Tuohy
> _______________________________________________
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> To post a message email:
> To subscribe, unsubscribe, or change list options,
> visit:
> or email:
> Before posting, please take a moment to review the archives
> at

As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 by and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.