Skip to Content
author's profile photo Former Member
Former Member

SQL statement

Have u used SQL statement or Stored Procedures?

If my client changes from SQL server to Oracle then where you have

to change?

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Posted on Jan 30, 2008 at 05:35 AM

    There ll be installation of the JDBC drivers first. Then the communication channel parameters like the connection string etc ll change. But the SQL statement in the channel ll remain same



    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 30, 2008 at 05:39 AM

    Hello Ragunath,

    Kind request, please consolidate all of your questions together and post in single thread. It will be easy for us to answer also it will be easy for you to refer.

    In addition to Prateek's reply, sometimes there is need to change the SQL too... For example let's say in my legacy AS/400 the database is not journaled hence I will use WITH NONE in the sql query, but the same is not supported in SQL Server!!

    Hence there is some worst cases where we need to change the sql too..


    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.