Difference between custom sql ,dynamic sql ? when we use custom sql,when we use dynamic sql?
- 4 Answers
- 11354 Views
- Quinnox, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / rekha chethan
custom sql--> Doesn't takes values during run time.
dynamic sql -->Can pass the values during run time.
| Is This Answer Correct ? | 13 Yes | 3 No |
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.
| Is This Answer Correct ? | 8 Yes | 0 No |
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.
| Is This Answer Correct ? | 5 Yes | 0 No |
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.
| Is This Answer Correct ? | 1 Yes | 0 No |
How ACLs Affect locking?
How webMethods Developer Supports Tables?
What Happens When a Breakpoint is Encountered?
What Is an ACL?
Why we use Local transaction and there boundaries.
can we build loop step with in the branch in such a way that the interface is look like that branch <transactiontype > sequence: Deposit loop <accno> xxxxxx sequence: current loop <accno> xxxxxxx sequence: savings loop <accno> can we achieve the above senario.
In ftp, if we need to change username and password. what we have to do?
the document is published but not subscribed where the document stored and how to trace the document?
1 Answers Cap Gemini, Tech Mahindra,
in which scenario we will use no tx,in which scenarion we use local tx?
2. What are the different ports in IS?
i have partner A,and partner B, then i want to send a document to partner B, what are requirements i will provide to partners ?
IS is thread or process ?
WebMethods 
