CODEWITHSUNDEEP
sqldatabaseodbc
programmer
programmer

Reputation: 1094

Writing SQL queries for an ODBC data source

I usually write SQL queries for SQL Server and MySQL but I just recently started to work with an ODBC data source that points to a Progress database. My question is where can I find a good syntax reference for writing SQL for an ODBC data source. I need to know what I can or can't do but there seems to be no guides I can find out on the internet.

Thanks!

Upvotes: 3

Views: 5587

Answers (3)

Garry M. Biggs
Garry M. Biggs

Reputation: 46

Try these --

Progress SQL-89 Guide and Reference

Progress SQL-92 Guide and Reference

Of course the guide that you need will depend upone the ODBC driver you are using.

(Only OpenLink Software do a SQL-89 driver which offers better functionality with older Progress databases - particularly when working with Extent/Array datatypes etc...)

Upvotes: 1

Olaf
Olaf

Reputation: 6289

As Adrian mentioned, you can just use the same queries you used before for the database that you connect to. If you want to leverage the fact that you are using ODBC data source and add some database server platform independence, you can consider using ODBC escape sequences: http://msdn.microsoft.com/en-us/library/ms715364(v=vs.85).aspx .

Upvotes: 1

Adriano Carneiro
Adriano Carneiro

Reputation: 58625

ODBC is just a kind of connection. SQL queries syntax will still depend on the RDBMS which will process them in the other end.

Upvotes: 1

Related Questions