Peoplesoft Tools Question:
Download Questions PDF

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

Answer:

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

Download Peoplesoft Tools Interview Questions And Answers PDF

Previous QuestionNext Question
Explain the numbers of sub pages and secondary pages that can be created in one level?How to creating prompt table dynamically for the specified field?