RE: capital alias

Posted in 2000

Bernstein, Rick — Thu, 6 Jan 2000 10:33:19 -0800 — source: Informix-list mailing list archive (1991-1998)

You do something like: export DELIMIDENT=1 $INFORMIXDIR/bin/dbaccess <your-database> - 0<<-EOF! select tv_lops "TV_LOPS" from vmproxy EOF! However, this approach has its own set of drawbacks. Rick Bernstein -----Original Message----- From: Art S. Kagel [mailto:kagel@bloomberg.net] Sent: Thursday, January 06, 2000 9:31 AM To: informix-list@iiug.org Subject: Re: capital alias Sadly you cannot. Art S. Kagel Sunil Bhaskarla wrote: > > Hi, > How can format a alias to all caps? > > sample: > > select > tv_lops 'TV_LOPS' > from vmproxy > > shows alias as 'tv_lops'! > > Thanks, > Sunil