Posted on 2000-02-29
Medium Priority
Last Modified: 2011-10-03
What's the difference between ISQL and DSQL and SQL ???
Question by:arocio

Accepted Solution

stino earned 60 total points
ID: 2571283
SQL is Structured Querying Language.  It is basically a standard framework for retrieving information from databases.  So, theoretically once you know this standard, you can get information from any database.  ISQL is Informix SQL, which uses the standard SQL as its base but there are certain features unique to only Informix databases.  I'm not sure what DSQL is though, but probably its for another database or maybe dynamic Sql ?

LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 2619486
I agree about the Definition of SQL.

ISQL stands, when speaking in the context of ORACLE or SQL Server, for the tool ISQL.exe, which is used to execute SQL statements interactively (SQL Server 7 now has added OSQL.exe)

DSQL is effectively Dynamic SQL, which are Statements build dynamically and executed onto the database (the structure is not known in advance by the Query Compiler).


Featured Post

Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Creating a Cordova application which allow user to save to/load from his Dropbox account the application database.
A method of moving multiple mailboxes (in bulk) to another database in an Exchange 2010/2013/2016 environment...
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…

586 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question