Topic:   what is the diff between custom and dynamic sql services
Jul 08, 2014 15:30 10 Replies 1239 Views Drectole
Prev Next
Topic Replies (10)
  1. 1
    idnkx user

    Drectole

    what is the diff between custom and dynamic sql services? please provide full fledged explanation...

    1
    idnkx user

    Tomas

    Custom SQL: executes custom SQL to perform
    database operations. You can execute almost
    any SQL statement required by integrations,
    such as data management statements.

    Dynamic SQL : d executes a SQL statement, part of
    which you set at run time through the input
    field.

    1
    idnkx user

    Ansari

    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.

    1
    idnkx user

    Drectole

    Ansari4u for both we can give the input at runtime only..

    1
    idnkx user

    Tomas

    Drectole; As per my understanding , By using custom SQL, u can execute any SQL statements but by using dynamic we can able to execute only input field which query you set.

    1
    idnkx user

    Raj Kumar

    In CustomSQL, 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 (like the where clause) can be passed at runtime; along with inputs to it. In simple words, with dynamicSQL you can dynamically build your SQL statement at runtime.

    1
    idnkx user

    George

    Rajkumar exact explaination

    1
    idnkx user

    Drectole

    Rajkumar thanks a lot

    1
    idnkx user

    Pia

    DrectoleIn CUSTOM THE SQL QUERY IS FIXED WITH INPUTS VARIABLES THAT ARE PASSED TO THE CUSTOM aDAPTER SERVICE IN RUNTIME
    YOU USE DYNAMIC SQL IF SQL QUERY CHANGES DURING THE RUNTIME IN THIS CASE YOU PREPARE THE sql QUERY AND PASS IT to DYNAMIC
    ADAPTER SERVICE IN THE RUNTIME.. Hope this helps

Leave a Reply
Guest User

Not sure what course is right for you?

Choose the right course for you.
Get the help of our experts and find a course that best suits your needs.


Let`s Connect