What Is The Difference Between Sqlexec And Createsql?

1.	What Is The Difference Between Sqlexec And Createsql?
Answer» SqlExec MEANS it bypasses the component buffer and it is directly contacts DATABASE to retrieve data. But it RETRIEVES the data row by row and not POSSIBLE for bulk insert. But in the CASE of Create SQL we can able insert the data in bulk.

Answer»

SqlExec MEANS it bypasses the component buffer and it is directly contacts DATABASE to retrieve data.
But it RETRIEVES the data row by row and not POSSIBLE for bulk insert.
But in the CASE of Create SQL we can able insert the data in bulk.

Discussion