Custom vs Dynamic SQL: In Custom SQL, SQL query (statement) is fixed. In

Difference between custom sql ,dynamic sql ? when we use custom sql,when we use dynamic sql?

Question Posted / kumar

4 Answers
13486 Views
Quinnox, I also Faced
E-Mail Answers

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

Please Help Members By Posting Answers For Below Questions

Explain about pub-sub architecture, where do you implemented this?

1080

How we can catch exception error on run time mode using flow language in webmethods?

1233

how to configure sap adapter6.1

2589

How many kinds of log files in webmethods?

1104

how to configure sap adapter 4.1

5873

If I have a parent sequence with the property set- exit on success, and the try sequence block set to exit on failure, and the catch sequence block too set to failure, what is the result?

1143

How many minutes have you spent in your lifetime reading documentation or actually (gasp) working with any webMethods product on a real project?

2646

post me important interview question on webmethods

2832

Where do you implemented pub-sub architecture?

1139

When Should You Use Flow Diagram View?

2674

Explain about pub-sub architecture?

1142

Explain what are the new features in 8.0 compared to 7.1?

1041

can any one please post Q and Ans for Trading Networks in webMethods

2536

can we build loop step with in the branch in such a way that the interface is look like that branch sequence: Deposit loop xxxxxx sequence: current loop xxxxxxx sequence: savings loop can we achieve the above senario.

2520

When we use repeate flow steps?

1101