SQL statement

[Former Member]

Have u used SQL statement or Stored Procedures?

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

to change?

[justin_santhanam]

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

raj.

[Former Member]

Hi raj

sorry,

I thought that it will be easy to answer for u one by one.

Thats y i did like that.

Regards

Raghu

[prateek]

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

Regards,

Prateek