Re: fields in a PF

On 14-Feb-2012 12:13 , fbocch2595@xxxxxxx wrote:

if I add a new field to a PF, is there a way the system can assign a
unique value to the new field without updating the field within the
program code? I've been told it can so I figured if anyone would
know how it would be you folks.

If an SQL TABLE is OK, then review this scenario:

<code>

/* setup; i.e. presumes existing PF is TABLE ID */
create table id (c char, d dec)
;
insert into id values(0, 0), (1, 1), (2, 2), (3, 3), (4, 4)
; -- 5 rows inserted in ID in LIB
/* action: have database assign a unique value to the */
/* new\added column for all existing rows */
alter table id
add column i int not null generated always as identity
( start with 0 increment by 1 cycle)
add constraint id_i_pk primary key (i)
; -- ALTER completed for table ID in LIB
/* review the effect of the action */
select * from id
; -- report from the SELECT follows:
....+....1....+....2....+.
C D I
0 0 0
1 1 1
2 2 2
3 3 3
4 4 4
******** End of data ********

</code>

Regards, Chuck