Which set of statements will write both the AUDIT_ACTN and SETID_TBL rows to the file?

View the Exhibit, which shows the file layout for SETID_FILE. You have been asked to write the PeopleCode to export SETIDs to a flat file, along with an action row indicating whether the action is an addition or a change.
The resulting flat file will contain a row indicating the action followed by a row containing transaction data. The PeopleCode will be placed on the SETID_TBL.SETID.SavePostChange event.


Which set of statements will write both the AUDIT_ACTN and SETID_TBL rows to the file?
A. &SETID = SETID_TBL.SETID;
If %Mode = "A" Then
&rRec1.AUDIT_ACTN.Value = "A";
Else
&rRec1.AUDIT_ACTN.Value = "C";
End-If;
&SETIDOUT.WriteRecord(&rRec1);
&rRec2 = GetRecord();
&SETIDOUT.WriteRowset(&rRec2);
B. &SETID = SETID_TBL.SETID;
If %Mode = "A" Then
&rRec1.AUDIT_ACTN.Value = "A";
Else
&rRec1.AUDIT_ACTN.Value = "C";
End-If;
&SETIDOUT.WriteRecord(&rRec1);
&rRec2 = GetRecord();
&SETIDOUT.WriteRecord(&rRec2);
C. &SETID = SETID_TBL.SETID;
If %Mode = "A" Then
&rRec1.AUDIT_ACTN.Value = "A";
Else
&rRec1.AUDIT_ACTN.Value = "C";
End-If;
&SETIDOUT.WriteRowset(&rRec1);
&rRec2 = GetRecord();
&SETIDOUT.WriteRowset(&rRec2);

Download Printable PDF. VALID exam to help you PASS.

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.