Re: New to informix.
josephatl@mindspring.com wrote in message
<6m5n8f$u07$1@nnrp1.dejanews.com>...
>Hello everyone. I'm new to informix & isql in general, so this is going to
be
>simple for you.
1) Get a book on SQL or take a class
>
>I need to know how to find the field names in all my tables, and then how
to
>replace the value of a field in one record based on the value of another
>field. ie...:
2) On a UNIX machine ===> dbschema -d database myschema
>
>replace port_number with "5061" where switch_id = "2XO"
3) vi myschema, find port_number and the table it is in.
isql mydatabase <<!
UPDATE sometable
SET port_number = "5601"
WHERE switch_id = "2XO";
!
>
>but I don't know how to tell it which table to look in.
>
>Any help would be greatly appreciated.
4) Give a man a fish and feed him for a day.
Teach a man to fish and feed him for life.
Seek and you shall find.