I am a newbie to db2 can someone explain to me why I am getting an error
on this command.

Thanks in advance.



db2 => UPDATE PROD.S_ADDR_PER SET PER_ID = (SELECT PROD.S_CONTACT.ROW_ID


ROM PROD.S_CONTACT, PROD.S_ADDR_PER WHERE PR_PER_ADDR_ID = PROD.S_ADDR

PER.ROW_ID AND PR_PER_ADDR_ID = '1-MMY9O')

DB21034E The command was processed as an SQL statement because it was
not a

valid Command Line Processor command. During SQL processing it returned:


SQL0904N Unsuccessful execution caused by an unavailable resource.
Reason

code: "00C90096", type of resource: "00000304", and resource name:
"SBLP02

.H0008005.X'002A28' '.X'09' ". SQLSTATE=57011


DB2 & UDB email list listserv db2-l LazyDBA home page