Register or Login to Your Account
what is the diff between custom and dynamic sql services? please provide full fledged explanation...
Custom SQL: executes custom SQL to perform
database operations. You can execute almost
any SQL statement required by integrations,
such as data management statements.
Dynamic SQL : d executes a SQL statement, part of
which you set at run time through the input
Custom SQL and Dynamic SQL we have to write the queries explicitly.The main difference between Custom SQL and Dynamic SQL is, In Custom SQL we can give the input values at design time. In Dynamic SQL we can give the input values at run time.
Ansari4u for both we can give the input at runtime only..
Drectole; As per my understanding , By using custom SQL, u can execute any SQL statements but by using dynamic we can able to execute only input field which query you set.
In CustomSQL, you can pass inputs to your SQL query at runtime. With DynamicSQL, you can pass your entire SQL statement, or part of your SQL statement (like the where clause) can be passed at runtime; along with inputs to it. In simple words, with dynamicSQL you can dynamically build your SQL statement at runtime.
Rajkumar exact explaination
Rajkumar thanks a lot
DrectoleIn CUSTOM THE SQL QUERY IS FIXED WITH INPUTS VARIABLES THAT ARE PASSED TO THE CUSTOM aDAPTER SERVICE IN RUNTIME
YOU USE DYNAMIC SQL IF SQL QUERY CHANGES DURING THE RUNTIME IN THIS CASE YOU PREPARE THE sql QUERY AND PASS IT to DYNAMIC
ADAPTER SERVICE IN THE RUNTIME.. Hope this helps