PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

Populating unlike fields in a Rowset

In the Peoplecode excerpt below,  like fields are copied from  &MYRS1 to &MYRS2. Let's say I have a field in &MYRS2 that's not part of &MYRS1. In a normal scenario those fileds will have a null value when copyto method is used, How do I assign a value to that field for all the record entries in &MYRS2 ?

Local Rowset &MYRS1, MYRS2;

Local String &EMPLID;

&MYRS1 = CreateRowset(RECORD.SOMEREC1);

&MYRS2 = GetRowset(RECORD.SOMEREC2);

&EMPLID = '8001';

&MYRS1.Fill("where EMPLID = :1", &EMPLID);

&MYRS1.CopyTo(&MYRS2, RECORD.SOMEREC1, RECORD.SOMEREC2);

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center