MVSFORUMS.com

[Catherine]

I have a table Emp with the data's as below

Emp-id Emp-code
1111 A
2222 A
3333 B
4444 C
5555 B

I have 200 records in this table and I need to update Emp-code of all 200 rows with the code "A".

At present my idea is to put the UPDATE query in a LOOP that runs for 200 times.

UPDATE EMP
SET EMP_CODE = 'A'
WHERE EMP_ID = :EMP-ID

But this would naturally consume more CPU TIME. Mine is an Online module. Is there any way to minimize the CPU time?

[Catherine]

I may also get greater chance of -911 errors since I'm going to hold the table for a longer time.

The table can contain large no: of rows > 200. I need to update 200 Rows Randomly, I'm given the Emp-id of 200 Rows

[kolusu]

Catherine,

try this

[Catherine]

Kolusu,

If in the EMP table, apart from the EMP-ID I have another one coloumn EMP-IND as the Primary Key ( My table has combination of EMP-ID and EMP-IND as Primary key) . Is there any possibility that I can give a similar Multiple Row update as you mentioned , in this case?

Also are there any disadvantages to Updating Multiple rows at one stretch?

[programmer1]

[kolusu]

[Catherine]

Kolusu,

I have one key with data type CHAR and another key with SMALLINT

[Catherine]

Kolusu,

I'm not able to use concatenate operator
Here is wat I got while executing in SPUFI

UPDATE TDB2TRAM.ABBT_ABBR_TRD
SET LOCK_IN = 'Y'
WHERE (TRD_REF_ID

[kolusu]

[Catherine]

Kolusu,

Thanks a lot for ur information and time

Catherine.