Update with select

If I try to execute an update of one or more columns with the results of a select I always get a syntax error !!! update cust_shp set (ship_name, address_1) = (select tabname, tabname from systables where tabid = 1) # ^ # 201: A syntax error has occurred. # where slmn_num[1,1]="2" Also with constants: update cust_shp set (ship_name, address_1) = (select 'a', 'b' from systables where tabid = 1) # ^ # 201: A syntax error has occurred. # Or with only one column: update cust_shp set (ship_name) = (select 'a' from systables where tabid = 1) # ^ # 201: A syntax error has occurred. # But this works !!! So, I can't update several columns in one update !!! update cust_shp set ship_name = (select 'a' from systables where tabid = 1) I have: Informix Dynamic Server Version 7.31.UC2 DB-Access Version 7.31.UC2 SCO Release = 3.2v5.0.4 Does somebody else have a similar problem? -- Manuel A. Daponte Santiago Systems Consultant, ICP