AW: AW: Referencing SQL Table Alternative Names in a RPG module

["Birgitta Hauser" <Hauser@xxxxxxxxxxxxxxx>]

Thanks for information

Mit freundlichen Grüßen / Best regards

Birgitta Hauser

"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"

-----Ursprüngliche Nachricht-----
Von: rpg400-l-bounces+hauser=sss-software.de@xxxxxxxxxxxx
[mailto:rpg400-l-bounces+hauser=sss-software.de@xxxxxxxxxxxx] Im Auftrag von
Barbara Morris
Gesendet: Wednesday, 12. October 2011 23:11
An: rpg400-l@xxxxxxxxxxxx
Betreff: Re: AW: Referencing SQL Table Alternative Names in a RPG module

On 2011/10/9 6:08 AM, Birgitta Hauser wrote:
> Barbara,
>
> just a question.
> In SQL tables it is possible to define columns with "case sensitive" and
> "invalid" names, for example "My New Column" or "BugetPrice" or even
> "Änderungs-Datum".
> Is it possible to handle those column names when specifying the keyword
> ALIAS?

No, if the name starts with the double-quote, the alternate name is 
ignored for that subfield, and the short name is used instead.