What is open sql vs native sql?

Showing Answers 1 - 5 of 5 Answers

vijayan

  • May 3rd, 2005
 

open sql connect database through dbinterface.but native sql directly affected db(it is not recomended it usefull for basis only)

  Was this answer useful?  Yes

sarath

  • Jul 24th, 2005
 

native sql we can access tables with specific database . 
open sql we can access tables regard less of its database system. 

  Was this answer useful?  Yes

Nilesh G

  • Jun 12th, 2007
 

Open sql only uses DML(Data manipulation Lang) stms for database like select,delete,etc....

Where as native sql uses both DDL(Data Definition lang),DML, like 
create table index ,  

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions