I am wondering how other people do CRUD stored procedures.
We have some CRUD stored procedures and I am wondering how you guys handle
the Update part. We are using RPG. Creating a procedure with the input
parms of an action code 'CRT', 'UPD', 'DLT' and all of the columns to the
table. The CRT and DLT are easy. But the UPD. The caller may not know
all of the values of all the columns. They know the keys and the values
they want updated. How do you handle the values that are not to be
We came up with if the column is char if the value is a pipe change to
blanks if blanks no change. other values then change it. Same type of
thing with numeric values -99999999 = zero, zero no change other values
For a small table this is okay but you get a table with 25+ columns, what a
programming pain on both sides.
Is there a better way?
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.