UPDATE statement usage

The UPDATE statement is used to modify the data in a table.

Examples of valid IMS Universal JDBC driver UPDATE statements

Updating one column in a record

The following statement updates the root:

UPDATE HOSPITAL SET HOSPNAME = 'MISSION CREEK'
WHERE HOSPITAL.HOSPCODE = 'H001007'

Updating multiple columns in a specified record in a hierarchic path

Foreign keys allow the IMS™ Universal JDBC driver to maintain referential integrity by identifying the exact record (or segment instance) to update. The following statement updates a WARD record under a specific HOSPITAL. In this example, the WARD table has the foreign key HOSPITAL_HOSPCODE. The record will be updated if and only if there is a HOSPCODE in the HOSPITAL table with the value of 'H5140070000H'.

UPDATE WARD SET WARDNAME = 'EMGY', 
   DOCCOUNT = '2', NURCOUNT = '4' 
WHERE HOSPITAL_HOSPCODE = 'H5140070000H' 
   AND WARDNO = '01'

Examples of invalid IMS Universal JDBC driver UPDATE statements

Example of a valid IMS classic JDBC driver UPDATE query that is invalid for the IMS Universal JDBC driver

This statement is invalid for the IMS Universal JDBC driver because it does not use the correct syntax to specify a legal value for the foreign key field (HOSPITAL_HOSPCODE).

UPDATE WARD SET WARDNAME = 'EMGY', 
   DOCCOUNT = '2', NURCOUNT = '4' 
WHERE HOSPITAL.HOSPCODE = 'H5140070000H' 
   AND WARDNO = '01'

Updating a foreign key field

Making an UPDATE on a foreign key field is invalid for the IMS Universal JDBC driver. For example, the following UPDATE query will fail:

UPDATE WARD SET WARDNAME = 'EMGY', 
   HOSPITAL_HOSPCODE = 'H5140070000H' 
WHERE WARDNO = '01'