can we update a coloumn in db2 cobol whithout cursor

sreelatha.rajoly · New User Joined: 27 Jan 2007 Posts: 2 Location: hyderabad

can we update a host variable in db2 using cobol program without declaring a cursor?

tarunbhardwajleo · Posted: Thu Mar 01, 2007 3:42 am

Yes, you can update a column/host variable in DB2 without a cursor, provided the predicates specified in the query yield a single result set. If there are multiple rows in the result set, then you need to use a cursor and in that case all the rows in that result set would be updated.