cancel
Showing results for 
Search instead for 
Did you mean: 

Difference between SQL and Pushdown_SQL

Former Member
0 Kudos

Hi Experts,

Could you please explain how SQL and Pushdown_SQL differ from each other and its use case.(When to use which function)

Also if someone explain its background operation in database level/Process it will be appreciated.

Thanks,

Pradheep S

Accepted Solutions (1)

Accepted Solutions (1)

former_member198401
Active Contributor
0 Kudos

Pushdown_sql() is basically used to optimize performance, DS Engine pushes down as many transform operations as possible to the source or target database and combines as many operations as possible into one request to the database

Also refer to blog

SQL() function is used in a script for DML operations and return a single value to the user

Regards

Arun Sasi

former_member187605
Active Contributor
0 Kudos

Pushdown_sql allows you to create dynamic WHERE clauses in a Query transform.

Sql allows you to call any sql statement.Typically used in scripts.

It's all in the documentation (SAP Data Servcies Reference Guide)!!!!

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Pradheep,

Hopes below link might help you to understand.