Difference between custom sql ,dynamic sql ? when we use custom sql,when we use dynamic sql?
Answer Posted / kumar
Custom vs Dynamic SQL:
In Custom SQL, SQL query (statement) is fixed. In Dynamic SQL, query is not fixed rather it changes dynamically.
In Custom SQL, 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 can be passed at runtime; along with inputs to it. So basically you can build your SQL dynamically at runtime.
You use Custom SQL when SQL query is fixed with input variable that are passed to the custom adapter service. You use dynamic SQL, if SQL query changes during the runtime; in this cases you prepare the sql query and pass it to dynamic adapter service in the runtime.
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.
Custom SQL is faster than the Dynamic SQL because Custom SQL is pre-compiled (at design time) but dynamic SQL is not pre-compiled (compiled at runtime).
Dynamic SQL is more versatile than the Custom SQL.
Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
Explain what is indices in map flow step?
How to convert document list to document? If document list contain documents and documents contain strings field. How to convert?
What are the advantages of eai?
Explain about pub-sub architecture, where do you implemented this?
Explain header handlers in web services
in filepooling process the document is not updated in target location means its in error directory how to achieve this problem?
How we can catch exception error on run time mode using flow language in webmethods?
post me important interview question on webmethods
Explain about pub-sub architecture?
can any one please post Q and Ans for Trading Networks in webMethods
Explain what are the new features in 8.0 compared to 7.1?
How many interfaces you implemented sofar?
When we use repeate, exit flow steps?
how to configure sap adapter 4.1
how to configure sap adapter6.1