[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Jeff Crosby
Sent: Monday, October 22, 2007 10:12 AM
To: 'Midrange Systems Technical Discussion'
Subject: SQL derived/virtual colimn
I seem to remember hearing something about the ability of SQL
to define what I would call virtual columns in a table. (Or
was it views only?)
A very simple example would be if a table had fields "Sales"
and "Cost", then in a Create Table you could specify a field
called "Profit" and define it as "Sales - Cost". Am I
dreaming? I could be because my googling hasn't turned up
examples, nor do I seem to see it in the IBM manuals. OTOH,
SQL could refer to it by some term other than "virtual" or
"derived". That has happened to me more times than not.
P.O. Box 13369
Ft. Wayne, IN 46868-3369
The opinions expressed are my own and not necessarily the
opinion of my company. Unless I say so.
This is the Midrange Systems Technical Discussion
(MIDRANGE-L) mailing list To post a message email:
MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting,
please take a moment to review the archives at