How to use Peoplecode While Fetch

Posted on by

How to use Peoplecode While Fetch

How to use Peoplecode While Fetch of peoplesoft. You can use function while with fetch data from sql for get data from sql.

Local SQL &SQL_DM = CreateSQL( ” SELECT MANAGER, NAME FROM TABLE “);
&i = 0;
While &SQL_DM.Fetch(&MANAGER,&NAME );

/* Do statement*/

End-while;

Posted in Peoplecode, PeopleSoft.