Answer / rekha chethan

custom sql--> Doesn't takes values during run time.

dynamic sql -->Can pass the values during run time.

Answer / 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.

Answer / varadharajulareddy

Custom SQL:- We Can give the input values at design time.
Dynamic SQL:- We can give the input values at run time.
Custom SQL:- One can execute any static SQL Statement.
Dynamic SQL:- We can able to execute only input field which query you set.

Answer / jan reddy

in custom sql -we can give the input values at Design time.
in dynamic sql-we can give the input values at Run time.

i am having a csv file and it is passed to the tokenize and is passed to the three different fields without setting the indices property. my question is to which variable which value goes or all the tokenized fields tobe passed? for eg:santosh.giridhar_satish_satish.csv-->tokenize what will happen

3 Answers   Mphasis, TCS,

---

How to use SEQUENCE as the Target of a BRANCH?

2 Answers   Accenture,

---

what is indices in MAP flow step?

1 Answers  

---

If i have to move packages from one IS to another, which process would u suggest, is it thru wmDeployer or someother processes like publish/subscribe?

5 Answers   IBM,

---

What Are Event Handlers?

1 Answers   Tecnics Integration Technologies,

---

how can you find file name in file-pooling concept?

2 Answers  

---

What is the file (.jar) name that sharing between WebMethods integrated with JD Edwards???

1 Answers  

---

Difference between Trigger disable and trigger suspend?trigger queue location ?

2 Answers   Fiserv, TCS,

---

how can try and catch block can be implemented using web methods developer ? tell the steps to implement it?

3 Answers   Interra IT,

---

Why we use Local transaction and there boundaries.

2 Answers   Quinnox,

---

In webMethods Integration Platform, where is the lock information stored (such as names of elements that are locked, when they were locked, etc.)?

2 Answers  

---

What happens to the locks on elements when we replicate a package?

1 Answers  

---