Re: New to informix.

Hi, The first question is very simple, just select the database you want and type: SELECT tabname, colname FROM systables, syscolumns WHERE systables.tabid = syscolumns.tabid The second question is even easier: UPDATE <tablename> SET port_number = "5061" WHERE switch_id = "2XO" josephatl@mindspring.com wrote in article <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. > > 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...: > > replace port_number with "5061" where switch_id = "2XO" > > but I don't know how to tell it which table to look in. > > Any help would be greatly appreciated. > > > -----== Posted via Deja News, The Leader in Internet Discussion ==----- > http://www.dejanews.com/ Now offering spam-free web-based newsreading >