Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

ISQL, DSQL, SQL ??

Posted on 2000-02-29
2
Medium Priority
?
1,253 Views
Last Modified: 2011-10-03
What's the difference between ISQL and DSQL and SQL ???
0
Comment
Question by:arocio
2 Comments
 
LVL 1

Accepted Solution

by:
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 ?

HTH
0
 
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).

0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Your data is at risk. Probably more today that at any other time in history. There are simply more people with more access to the Web with bad intentions.
Backups and Disaster RecoveryIn this post, we’ll look at strategies for backups and disaster recovery.
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…
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …
Suggested Courses

916 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