What is the diffrence between SQLExec and CreateSQL?

Sqlexec is used to select, insert, update or delete a single record using a sql statement. Sqlexec executes the sql command from within peoplecode bypassing the component processor and interacts directly with database server.


But in the case of Create SQL we can able insert the data in bulk. If you want to select, insert, update or delete a series of record then use getsql or createsql and then execute sql class method.