SQL Views
Posted in 1993
Hello Informix Net:
I have been working with ISQL v. 2.10 for MS-DOS for some time.
I have successfully created a view using the RDSQL language format, everything
in the informix system says the view is ok.
Question: How do I now use the view to display data on the screen, query data,
add data, update data, or delete data?
The "Informix Users Manual and Reference Manual state that all these functions
can be accomplished, BUT they do not seem to illustrate how these functions
are performed once the view has been created.
I have included the RDSQL command to create the view.
database employee;
create view emp_view as
select *
from employee
where lname is not null
with check option;
What do we do with the view now?
Thanks in advance to all those who can provide unsight and direction.
Michael S. Gordon
Foreman, Gyroscope Section
Avionics Division
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* *
* Michael Gordon Sacramento Army Depot *
* Foreman, Gyroscope Section Directorate For Maintenance *
* E-Mail: maint72@saad-emh1.army.mil Attn: SDSSA-MAV-320 *
* DSN: 839-2367 Michael S. Gordon *
* Comm.: (916) 388-2367 Sacramento, CA 96813-5036 *
* *
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *