vcramachandran

 Profile Answers by vcramachandran 

• May 29th, 2006

 

Sql Objects are the objects in the sql server and sqlexec is the built in function in peoplecode

kishor

• May 30th, 2006

 

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.

Jiju

• Jun 8th, 2006

 

SQLExec should ideally be used for looping through data while SQLExecs (if used with select) should be used while returning a single row.

arungati

 Profile 

• Jun 18th, 2006

 

SQL object is used for reusability, in the sense, once instantiated the data retrieved out of it can be used for further caculations logically. Physically at a database level, it takes a trip to the database server only once. SQL Exec takes a trip to the database server evertime its used.