Peoplesoft Tools Interview Question:

How the output of a sql query be stored in a variable using peoplecode?

Submitted by: Muhammad

You can use SQLExec to do the same.
SQLExec("SELECT EMPLID FROM JOB",&Emplid);
The value of EMPLID gets stored in the variable &Emplid.
Submitted by: Muhammad