SQLExec("SELECT A.XLATSHORTNAME, A.XLATLONGNAME FROM PSXLATITEM A WHERE A.EFFDT = (SELECT MAX(B.EFFDT) FROM PSXLATITEM B WHERE

This PeopleCode function uses effective-date logic to return the current row from PSXLATITEM.
SQLExec(“SELECT A.XLATSHORTNAME, A.XLATLONGNAME FROM PSXLATITEM A
WHERE A.EFFDT = (SELECT MAX(B.EFFDT) FROM PSXLATITEM B WHERE

A.
FIELDNAME = B.FIELDNAME AND

B.
FIELDVALUE = B.FIELDVALUE AND

C.
EFFDT <= <date>)”);
Which system variable should be substituted for <date> so the function correctly returns the
current row as of the run date for all supported databaseplatforms?

D.
%Date

E.
%AsOfDate

F.
%DateTime

G.
%EffDtCheck

H.
%CurrentDateIn

I.
%CurrentDateOut

Explanation: