This article shows you how to use the i Series Projects perspective, which is shipped with the Web Sphere Development Studio Client for i Series, V5.0.It starts off by describing an existing green screen application, and lists some modifications that need to be done to enhance the application.

updating a blog on the iseries-23

Updating a blog on the iseries video

If you do not specify FOR UPDATE OF, SQL assumes that you want to update all columns (fields).

Second, list only the columns that you will update.

SQL will consider using access paths to speed up the update, but it will not use an access path over an updated column.

When you tell SQL which columns will be updated, SQL knows that it can use access paths over other columns. Notice the FOR UPDATE OF clause in the cursor declaration. // Change Code now has a new value for the customer.

If the error is for preload or postload operation, or if it is for regular load operation and load triggers are defined, please check the SQL.

Otherwise, for (3) and (4), please contact your local DBA. PUB_AREA SET ADB_L_DELIVERY = 'C' WHERE ADB_SEQUENCE = 22849415 If the select query is not filtered, below four update SQLs are Generated by the DI Job, Driver error is displayed on this Bulk records update. PUB_AREA SET ADB_L_DELIVERY = 'C' WHERE ADB_SEQUENCE = 22849415 UPDATE TIBCO_STG.

But if you only want to update some of the rows, then yes, you must include a WHERE clause in the UPDATE statement. Suppose you have a master file of vendors that includes a vendor-type code.

The code has never been loaded, but now you need to update the code based on a file that was created from a user’s spreadsheet. The file of updates is called VENDORUPDT, and it has two fields only: vendor ID number and type code.

If the select Query for the DI job is filtered for only one record, below update statement is generated and is executed through Data Integrator. PUB_AREA SET ADB_L_DELIVERY = 'C' WHERE ADB_SEQUENCE = 22849416 UPDATE TIBCO_STG.


I do not understand the redundancy in the first code example. This is the example to which you refer: The direct answer to your question is “no”. In this case, there is no need for a WHERE clause in the UPDATE statement. To sum it up, the WHERE clause specifies which rows are to be updated.