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

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

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

When we use repeate flow steps?

616


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

1999


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.

2000


How many kinds of log files in webmethods?

609


When Should You Use Flow Diagram View?

2094






can anyone explain in brief about TN Consloe and Webmethods...? As well as All flow steps in webmethods: Branch Repeat Loop Sequence (explain also Try -Catch block for error Handling)

1426


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?

655


in filepooling process the document is not updated in target location means its in error directory how to achieve this problem?

2259


post me important interview question on webmethods

2318


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

589


how to configure sap adapter 4.1

5300


How to convert document list to document? If document list contain documents and documents contain strings field. How to convert?

645


When we use repeate, exit flow steps?

604


Explain about pub-sub architecture?

641


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

2013