Select and Update one row at a time

Torch · #1 (**permalink**) 09-01-10, 20:43

Can someone please help me with this.

I have a table with the following columns (example in XML format)

Code:

<PersonID>0031620</PersonID> 
<POSNUM>000126021</POSNUM> 
<Event>2</Event> 
<TTYPE>1</TTYPE> 
<DateCommenced>020100201</DateCommenced> 
<DateCompleted>099999999</DateCompleted> 
<ManagementUnitCode>21325</ManagementUnitCode> 
<PositionLevelCode>CL1/2</PositionLevelCode> 
<RECSTS>N</RECSTS> 
<TSTAMP>2010-06-17-11.28.13.182000</TSTAMP>

I'm trying to select and update a single row in a table at a time. I think the select will be something like this:

Code:

select * from cpdta10ua.OCC where RECSTS = 'N' order by TSTAMP fetch first 1 rows only

Not quite sure how to do the update though?

Jack Vamvas · #2 (**permalink**) 09-02-10, 08:06

Normally you would do an UPDATE statement as :
UPDATE cpdta10ua.OCC SET [ColumnName]=[Value]
WHERE RECSTS = 'N'

Do you also mean to return a recordset to the client?

Internet Services

Web Development

Digital Marketing

Consumer Tech