PeopleCode Question:
Download Questions PDF

Tell me What is the difference between SQl Object and SQl Exec?

Answer:

SQL Object is a peopletool definition which can be created using app designer as well as using peoplecode command CREATESQL( ) , it is mainly used for reuseablility of the sql statements. so whenever this statement is required no need to hard code, just create an sql object of the same and use where ever it is required.

sqlexec is a peoplesoft delivered function used to retrive only one row and u can update multiple rows of data. It directly interacts with the database.

Download PeopleCode Interview Questions And Answers PDF

Previous QuestionNext Question
How to comment out a piece of the peoplecode in a program?Tell me What is the diff between component level peoplecode and record level peoplecode?