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.
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.