Answer Detail: RE: Can the output of a sql query be stored in a variable using peoplecode?if so how it be done?

GeekInterview.com > Interview Questions > Peoplesoft > PeopleTools

Print |

Question: Can the output of a sql query be stored in a variable using peoplecode?if so how it be done?

Answer: i want to store the output of a query say

select EMPLID from Job;

the output of this column should be stored in a variable. how it can be done?

November 11, 2008 02:10:44	#1
psft1017	Member Since: November 2008 Total Comments: 1
RE: Can the output of a sql query be stored in a variable using peoplecode?if so how it be done?
You can use SQLExec to do the same. SQLExec("SELECT EMPLID FROM JOB",&Emplid); The value of EMPLID gets stored in the variable &Emplid.

Back To Question